<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 - subtotal XLSX"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119913">119913</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>subtotal XLSX
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.1.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>p_kongstad@op.pl
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=144920" name="attach_144920" title="File with correct sum">attachment 144920</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=144920&action=edit" title="File with correct sum">[details]</a></span>
File with correct sum
Hi,
When you use subtotal to show the sum using autofilter and save it as .XLSX
then when opening the file again the sum is not according to the filter. It
works ok with .ODS.
I have attached the same file saved as XLSX and ODS to show the issue.</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>