[Libreoffice-bugs] [Bug 126505] New: Wrong Subtotal of auto-filtered rows on opening XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126505

            Bug ID: 126505
           Summary: Wrong Subtotal of auto-filtered rows on opening XLSX
           Product: LibreOffice
           Version: 5.4.7.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: satit at thonburi.com

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:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190722/a1e0f611/attachment.html>