https://bugs.freedesktop.org/show_bug.cgi?id=79249
Priority: medium
Bug ID: 79249
Assignee: [email protected]
Summary: #N/A value is shown as "={nan}" in formular bar and
"Err:512" as cell value
Severity: critical
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.2.4.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 99844
--> https://bugs.freedesktop.org/attachment.cgi?id=99844&action=edit
test xlsx file with #N/A value
Problem description:
The attached xlsx file has "#N/A" value in cell A1:A4. The file was created by
MSO 2010. The "N/A" value was generated by VLOOKUP function and pasted special
only values (thus there should be no formular in any of the cells)
When open in Calc, it shows value "Err:512" rather than "N/A", while in the
formular bar it shows "={nan}".
Steps:
1. Just open the attached xlsx file in LibreOffice.
Current Behaviour:
It is showing "Err:512" in A1:A4, and "={nan}" in formular bar.
Expected:
It should show "#N/A" in A1:A4; there is no formular in the cells, so it should
show "#N/A" in the formular bar.
OS: reproducible in windows xp, ubuntu 13.04 lts, and Fedora 20. So: ALL.
LibreOffice: 4.2.4.2.
Still reproducible in 4.3 beta 1.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
