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