https://bugs.freedesktop.org/show_bug.cgi?id=79249
--- Comment #5 from Markus Mohrhard <[email protected]> --- (In reply to Kevin Suo from comment #0) > Created attachment 99844 [details] > 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. That file contains error cells which are not available in calc therefore we translate them to formulas. This is the closest that we can do. -- 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
