Description: If some API uses Apache POI to populate a XLSX spreadsheet (Microsoft Office format) and this spreadsheet has formula in some cells, it doesn't compute the values. This same spreadsheet file is opened successfully by Microsoft Excel (2007, 2010, 2012 and Web), Google Docs, Apple Numbers and WPS Office. All them computes correctly the formula in cells. Steps to Reproduce: 1. Download the example file from https://drive.google.com/file/d/147DX3weDQS4ZX5g1LSaLl3RZIC1YSUuO/view?usp=sharing 2. Open this file with LibreOffice 3. Look the formula on cells B9 and C9 (it remais with value 0) 4. Open the same file in Microsoft Office (desktop or web), Apple Numbers (on Mac) or WPS Office. All them will calculate the cell formulas. Actual Results: It doesn't calculate the cell formulas. Expected Results: Calculate the cell formulas properly. Reproducible: Always User Profile Reset: Yes Additional Info:
i can reproduce it, if recalculate on load is disabled: Menu Tools/Options.../LibreOffice Calc/Formula Recalcualtion in File Load Excel 2007 and newer [Never recalculate] please set to [Always recalculate] / [Prompt user] or do a "Recalulate Hard" Ctrl+Shift+F9 after loading.