https://bugs.documentfoundation.org/show_bug.cgi?id=126470
Bug ID: 126470
Summary: Sheet doesn't compute formulas when XLSX is generated
by Apache POI
Product: LibreOffice
Version: 6.1.6.3 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: wagner.shima...@gmail.com
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:
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs