Created attachment 111074 [details] File which has what is discussed in the description Opening the attached file has fields incorrectly show with '0' instead of showing nothing "": ID : cash Name : Cash Sale Address : 0 Delivery Instructions : 0 Phone : 0 Phone : 0 Email : 0 Email : 0 If you delete the 'cash', press Enter, enter 'cash' (without the apostrophes) it then shows correctly as: ID : cash Name : Cash Sale Address : Delivery Instructions : Phone : Phone : Email : Email : It would be appreciated if LibreOffice Calc would once again show fields with "" instead of '0'. If I remember correctly, the versions of LibreOffice Calc prior to 4.2 or 4.1 showed the correct "" on opening.
Created attachment 111078 [details] screenshot 4.2.7 vs 4.3.0 I confirm issue under Win8.1 64bit using LibO 4.3.0 and 4.3.4 compare screenshot versus LibO 4.2.7
CC'ing Markus. is that change intended?
0 result is due to the IF function. VLOOKUP alone returns empty string.
ok, but why a different file display between 4.2.x and 4.3.x? which one is right?
(In reply to GerardF from comment #3) > 0 result is due to the IF function. VLOOKUP alone returns empty string. If you delete 'cash' and re-type 'cash' then the result is a blank (different to when the file was opened). The output value of the function is different even though the input values are the same. The value a function outputs should be the same for given input values; however, the output of the function is different based on if the file is opened or if it is entered once the file is opened.
The problem is in the file: <table:table-cell table:style-name="ce17" table:formula="of:=IF(ISNA(VLOOKUP([.B$1];[People.$A$2:.$H$65200];[People.$F$1];0));"";VLOOKUP([.B$1];[People.$A$2:.$H$65200];[People.$F$1];0))" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p/> </table:table-cell> Without checking our import code, reading the spec and some thinking I can currently not decide if this is an import or an export bug. I think you can workaround the problem by switching to Always recalculate for the ODF import.
It seems that this bug has been fixed with LibreOffice 5.3 on Windows 8.1 64-bit; however, the bug is still present on Linux Mint 18.1 Cinnamon 64-bit. Can someone reproduce that the bug is fixed with LibreOffice 5.3 on Windows, yet the bug is still present in Linux? If so, is there a way to implement the Windows fix on Linux? Thank you
(In reply to Óvári from comment #7) > Can someone reproduce that the bug is fixed with LibreOffice 5.3 on Windows, > yet the bug is still present in Linux? If so, is there a way to implement > the Windows fix on Linux? If have retested, and it does work correctly with: LibreOffice Version: 5.3.0.3 Build ID: 7074905676c47b82bbcfbea1aeefc84afe1c50e1 CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; VCL: gtk2; Layout Engine: new Operating system: Linux Mint 18.1 Cinnamon 64-bit Thank you