https://bugs.documentfoundation.org/show_bug.cgi?id=96828
Bug ID: 96828
Summary: FILEOPEN: XLSX files containing formulae but not
values are not recalculated
Product: LibreOffice
Version: 4.2.8.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: documentfoundation....@davel.me.uk
Created attachment 121634
--> https://bugs.documentfoundation.org/attachment.cgi?id=121634&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
