User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 Build Identifier: LibreOffice 5.2.1.2, 31dd62db80d4e60af04904455ec9c9219178d620 When I open an Excel (xlsx) file no formulas are calculated in it. I can go to an individual cell that contains the formula and hit Data->Calculate->Recalculate (F9) the calculation does happen. I can also trigger the calculation by changing any of the values in the range it refers to. as a side note: if I select multiple cells with formulas and hit Recalculate (F9) none of the formulas get triggered, I think more intuitive behaviour would be for all of them to update. I did make sure that the Data->Calculate->AutoCalculate is "checked" Reproducible: Always Steps to Reproduce: 1. Open an Excel(xlsx) spreadsheet 2. Observe that none of the formulas have been calculated 3. Go to individual cell with a formula and Recalculate(F9) it - should work 3a. Go to any of the cells which are part of range for any formula and change it's value - observe the formula calculation updated Actual Results: no autocalculation happens on open Expected Results: all formulas should be autocalculated once the file is open [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Mac OS X (All) OS is 64bit: no Reset User Profile?No (brand new installation)
Additionally I should mention that the Excel file was created through a report-generation tool, it's downloaded through a website and since LO is the default handler for xlsx files that's what opens them. I don't have an Excel copy to replicate this. However I did try to create an xlsx file in LO with a formula, save, re-open it - the issue doesn't occur. Without knowing the particulars of xlsx format I would venture a guess that maybe formula fields have a "last known result" attribute which gets saved when the file is created in application, and when LO opens the file it initially displays that value. Since my files are created in some third party code it may not set this attribute on the formula field, so it's defaulted to a "0"
Usually spreadsheet files are calculated, hence it is not done when loading. You can activate it under Tools - Options - Calc - Formula "Recalculation on File Load". You can also recalculate an entire spreadsheet document once by hitting Shift+Ctrl+F9
missed that configuration option - thanks for the quick response!