https://bugs.freedesktop.org/show_bug.cgi?id=79180
Priority: medium
Bug ID: 79180
Assignee: [email protected]
Summary: VLOOKUP with #N/A value is showing blank when save as
xlsx
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.3.0.0.beta1
Component: Spreadsheet
Product: LibreOffice
Created attachment 99715
--> https://bugs.freedesktop.org/attachment.cgi?id=99715&action=edit
the test case ods file
Description:
In calc, if the VLOOKUP formular has an "#N/A" value (i.e., there is no match),
when save as MSO 2010 (xlsx) format the cell shows blank rather than "#N/A".
Steps to reproduce:
1. Save the attached ods test file as MSO 2007/2010 XLSX.
2. Reopen with calc.
Current behaviour:
Cell B9 is showing blank (empty) value, with the formular still in the cell. F9
to recalculated do not solve the problem.
(For information, cell B11 with the formular "=NA()" is also showing "#N/A"
when save as xlsx)
Expected:
Cell B9 should show value "#N/A".
OS: ubuntu 13.10
LibreOffice Version: 4.3.0.0.beta1
Build ID: 2e39c7e59c8fc8b16a54c3d981dceef27fb0c07f
--
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
