[Libreoffice-bugs] [Bug 118692] New: Formula in generated XLSX not calculating when opening the file

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118692
           Summary: Formula in generated XLSX not calculating when opening
                    the file
           Product: LibreOffice
           Version: 5.3.7.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: oosthm at gmail.com

Description:
I am using Cuba Platform to develop custom applications.  I am using
LibreOffice 5 to convert reports to PDF in the background as described by Cuba
Platform's documentation.

I've noticed that when the PDF is created, the sum function displays 0 instead
of the correct value.  I've created the report in xlsx, opened it in
LibreOffice and saw that the sum value displays 0.  If one updates the formula,
it calculates correctly.  There is nothing to undo.

I can provide a sample xlsx file.


Steps to Reproduce:
1.Open file

Actual Results:
Look at total formula.  Value displays 0.

Expected Results:
Sum of values within the formula range.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 5.3.7.2 (x64)
Build ID: 6b8ed514a9f8b44d37a1b96673cbbdd077e24059
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new; 
Locale: en-US (en_US); Calc: group

-- 
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/20180711/5a5657b9/attachment.html>