<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 - Sheet doesn't compute formulas when XLSX is generated by Apache POI"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126470">126470</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Sheet doesn't compute formulas when XLSX is generated by Apache POI
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.6.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</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>wagner.shimatai@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
If some API uses Apache POI to populate a XLSX spreadsheet (Microsoft Office
format) and this spreadsheet has formula in some cells, it doesn't compute the
values.
This same spreadsheet file is opened successfully by Microsoft Excel (2007,
2010, 2012 and Web), Google Docs, Apple Numbers and WPS Office. All them
computes correctly the formula in cells.
Steps to Reproduce:
1. Download the example file from
<a href="https://drive.google.com/file/d/147DX3weDQS4ZX5g1LSaLl3RZIC1YSUuO/view?usp=sharing">https://drive.google.com/file/d/147DX3weDQS4ZX5g1LSaLl3RZIC1YSUuO/view?usp=sharing</a>
2. Open this file with LibreOffice
3. Look the formula on cells B9 and C9 (it remais with value 0)
4. Open the same file in Microsoft Office (desktop or web), Apple Numbers (on
Mac) or WPS Office. All them will calculate the cell formulas.
Actual Results:
It doesn't calculate the cell formulas.
Expected Results:
Calculate the cell formulas properly.
Reproducible: Always
User Profile Reset: Yes
Additional Info:</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>