Created attachment 121634 [details] Example XLSX file which does not correctly import into LibreOffice When an XLSX file containing formulae but not calculated values is imported into LibreOffice, "0" is incorrectly shown as the result of the calculations. Microsoft Excel and Google Sheets correctly calculate the values on import. Such files are easily generated using XLSX generating libraries, I have attached a minimal example. Best regards, Dave Lambley
Created attachment 121635 [details] Code to generate XLSX file that incorrectly imports.
Created attachment 121636 [details] Screen shot of incorrectly imported XLSX file.
1) Try a newer version, 4.2.8 is pretty old by now. 2) Set: options > LO Calc > Recalculation.... to 'Always recalculate'.
Yes, I can reproduce the problem in version 5.0.1.2. Changing the setting at [Option -> LibreOffice Calc -> Formula -> Excel 2007 and newer] to "Always recalculate" gets the correct value to appear. Pressing F9 to recalculate, whether "AutoCalculate" is set or not, does not make the correct value appear.
(In reply to Dave Lambley from comment #4) > Pressing F9 to recalculate, whether "AutoCalculate" is set or not, does not > make the correct value appear. Hmmmm, shift - ctrl - f9 should do the trick.
Yes, shift-control-F9 successfully causes calculation. Confirmed in version 4.2.8.2.
Tested with Version: 5.2.0.0.alpha0+ Build ID: a27fac3b8f2bae18f62bab315051732df1bb29ab CPU Threads: 4; OS Version: Linux 4.2; UI Render: default; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-01-01_05:08:26 after changing options > LO Calc > Recalculation.... to 'Always recalculate' is value correctly recalculated. In xlsx file is saved value O, so closing as notabug. <sheetData> <row r="1" spans="1:1"> <c r="A1"> <v>100</v> </c> </row> <row r="2" spans="1:1"> <c r="A2"> <f>A1</f> <v>0</v> -> zero here </c> </row> </sheetData> File is probably created in excel <Application>Microsoft Excel</Application> <AppVersion>12.0000</AppVersion>