[Libreoffice-bugs] [Bug 114331] New: FILEOPEN: Opening XLSX documents does not recalculate sheet formulae

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=114331

            Bug ID: 114331
           Summary: FILEOPEN: Opening XLSX documents does not recalculate
                    sheet formulae
           Product: LibreOffice
           Version: 5.4.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dancol.95 at gmail.com

When creating XLSX files with the Python package, XlsxWriter (
http://xlsxwriter.readthedocs.io/ ), which contains formulae, Calc when opening
that file will not recalculate the values. Apparently there is a global flag in
the XLSX spec which indicates that upon opening, the spreadsheet application
should recalculate all the formulae.[1] When opening in Microsoft Excel, the
formulae are recalculated as they should be.

[1] - http://xlsxwriter.readthedocs.io/ ( "XlsxWriter doesn’t calculate the
result of a formula and instead stores the value 0 as the formula result. It
then sets a global flag in the XLSX file to say that all formulas and functions
should be recalculated when the file is opened." )

-- 
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/20171208/9ad684a8/attachment.html>