Bug 118692 - Formula in generated XLSX not calculating when opening the file
Summary: Formula in generated XLSX not calculating when opening the file
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-07-11 12:34 UTC by Martin Oosthuizen
Modified: 2018-07-11 21:06 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample file with formula bug (13.42 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-07-11 12:36 UTC, Martin Oosthuizen 		Details
xl/worksheets/sheet1.xml (27.17 KB, image/png)
2018-07-11 21:05 UTC, raal 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Martin Oosthuizen 2018-07-11 12:34:43 UTC 
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
Comment 1 Martin Oosthuizen 2018-07-11 12:36:58 UTC 
Created attachment 143458 [details]
Sample file with formula bug
Comment 2 MM 2018-07-11 15:45:59 UTC 
Unconfirmed on windows 7 x64 with Version: 6.0.5.2 (x64)
Build ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16
CPU threads: 3; OS: Windows 6.1; UI render: GL
Comment 3 raal 2018-07-11 21:05:47 UTC 
Created attachment 143492 [details]
xl/worksheets/sheet1.xml

if you unzip xlsx file and you can see in xl/worksheets/sheet1.xml  that value is not set. You can recalcute value in LO with CTRL+SHIFT+F9 or set in options - Calc options- Formula - Recalculation on file load. Not a bug.