<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Formula in generated XLSX not calculating when opening the file"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118692">118692</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Formula in generated XLSX not calculating when opening the file
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.7.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>oosthm@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>