[Libreoffice-bugs] [Bug 126470] New: Sheet doesn't compute formulas when XLSX is generated by Apache POI

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: wagner.shimatai at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190718/4a375481/attachment.html>