<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 - Wrong Subtotal of auto-filtered rows on opening XLSX"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126505">126505</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Wrong Subtotal of auto-filtered rows on opening XLSX
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.7.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>satit@thonburi.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When open a Calc sheet (saved in xlsx format), the subtotal(9,range) with
auto-filter rows display sum of all rows instead of filtered rows.
Ex. ALL ROWS
ITEMS 6000 <-- subtotal(B3:B10)
----- ----
AAAA 4000
XXXX 1000
XXXX 2000
Then do auto filter with only XXXX items. Calc display correctly as 3000
But after save(in XLSX)-close & reopen the sheet, it display like following:
ITEMS 6000 <= SUBTOTAL(9,B3:B10)
---- ----
XXXX 1000
XXXX 2000
Steps to Reproduce:
1. ENTER ALL ROWS and subtotal as following:
ITEMS 6000 <-- subtotal(B3:B10)
----- ----
AAAA 4000
XXXX 1000
XXXX 2000
2. Create Auto-Filter on the above rows/columes
3. Choose XXXX of dropdown at ITEMS Filter (the subtotal still calculates
correctly)
4. Save the sheet in xlsx format
5. Reopen the sheet, it will displays like following
ITEMS 6000
---- ----
XXXX 1000
XXXX 2000
Actual Results:
6000
Expected Results:
3000
Reproducible: Always
User Profile Reset: No
OpenGL enabled: 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>