Created attachment 99846 [details] MS Excel file The attachment MS Excel file is working fine but with LibreOffice Calc show some cells content as #N/A
Created attachment 99847 [details] Calc file errors Print Screen
Created attachment 99848 [details] MS Excel file Print Screen This file is working fine with MS Excel
Created attachment 99854 [details] pdf showing the result in 4.2.4.2 I do not reproduce this in 4.2.4.2. See the attached pdf file for the results.
You should not mark your own bug as NEW or ASSIGNED
UNCONFIRMED. I also can not reproduce in 4.3.0 beta 1. Fomeel would you please upgrade to 4.2.4.2 and test again? is this also reproducible in 4.1.6?
Not reproducible for me under Ubuntu 14.04 with LO 4.0.6, LO 4.1.6, LO 4.2.7.0.0+ and LO 4.3.1.0.0+. Best regards. JBF
I can reproduce. Not at opening the file but after playing with listbox (cells B4, B5...). I don't know how it works with Excel, but with Calc Listbox always returns 'text", not numeric value. So LOOKUP("24";range) can't find text "24" in the range containing numeric value 24. IMHO, this is not a bug. Let status to NEEDINFO for other opinion.
Similar with Gerard's finding, I can reproduce by playing cell B4 and/or B5 in "Main" sheet. I'm using LO 4.3.0.3 and Ubuntu 12.04 x86 while testing. Those cells refer to, respectively, cell F3 and J3 in "Sheet2" sheet. F3 and J3, respectively, referred cell F2 and J2 in the same sheet (which initially has 'Number - Standard' format). But if we playing B4 and/or B5 in "Main", cell F2 and/or J2 in "Sheet2" changed to 'Text - @' format. So F3 and/or J3 will have result #N/A, as well some cells in "Main" sheet which refer to those cells. I think it's a bug, not reproducible in AOO 4.1.0
(In reply to comment #8) Reproduced with same behavior in LO 4.2.5.2, 4.1.6.2 Reproduced with different behavior in LO 4.0.6.2, 3.6.7.2, 3.5.7.2 : F2 and J2 in "Sheet2" still have 'Number - Standard' format after playing with B4 and/or B5 in "Main", BUT those cell contents will be added punctuation mark in the beginning (so it's the same as text format)
Steps to reproduce from scratch: 1. Input cell A1 with value: 1 2. View > Toolbars > Form Controls 3. Hit "List Box" button > draw a box in cell C1 > Cancel 4. Hit "Control" button 5. Fill 'Linked cell..." with: B1 6. Fill 'Source cell range..." with A1 7. Close the control box by hitting "x" 8. Hit "Design Mode On/Off" 9. Verify that cell B1 has format "Number-Standard" 10. Select '1' in List Box (in cell C1) Expected result: cell B1 should keep "Number-Standard" format Unexpected result: cell B1 change to "Text-@" format Tested with LO 4.2.6.2 - Ubuntu 12.04 x86 Set NEW as problem identified Platform: All Importance: not critical I think, lowering a bit
(In reply to comment #10) Reproduced with same behavior: LO 4.1.6.2 Reproduced with different behavior: LO 4.0.6.2, AOO 4.1.0 -> cell B1 keep the 'Number-Standard' format but cell content become: '1 (begin with punctuation mark) I was wrong in comment 8: AOO 4.1.0 also have this bug, but the results is not updated so the #N/A not appear
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.