https://bugs.documentfoundation.org/show_bug.cgi?id=115022
Bug ID: 115022
Summary: subtotal in .xlxs
Product: LibreOffice
Version: 5.4.4.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 139108
--> https://bugs.documentfoundation.org/attachment.cgi?id=139108&action=edit
XLXS file with autofilter
When opening a file with autofilter and subtotal saved as .xlxs the sum is
totalling all values and not only the filtered. When saved as .ods this sum is
showing the sum of the filtered values.
Expected that a file saved as .xlxs would sum the value correctly.
Also a hard recalculation does not update, but only editing the formula.
How to verify this bug
1. In row 1 we make in column A Index and B Amount
2. In column a we make to indexes called a and be in row 3 and row 7 the below
values:
Index amount
a 1
b 4
a 2
b 5
a 3
b 6
3. Now mark row 1 and use Data/Autofilter to enable filtering.
4. Open the filter using the dropdown for Column A and press on all to have no
values marked.
5. Now mark value a
6. Use the icon for summing in B9.
7. This creates the formula =Subtotal(9,B2:B8) and returns the value 6 which is
correct.
8. Now save the file as an ,XLXS file.
9. CLose the file and reopen it. Now the value is 21 which is incorrect.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
