https://bugs.documentfoundation.org/show_bug.cgi?id=163619
Bug ID: 163619
Summary: FILEOPEN XLSX Read the Subtotal options "Add subtotal
to" and "Use function"
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 109330
Created attachment 197237
--> https://bugs.documentfoundation.org/attachment.cgi?id=197237&action=edit
Example file from Excel 2016
In the attached file in the Subtotal dialog I have set the "Add subtotal to"
setting to "Value 1" and "Value 2" columns and the "Use function" setting to
"Max"
When opened in Calc, these are not recognized by the Subtotals dialog.
1. Open attached file
2. On the "Below" sheet select the Data - Subtotals menu item
-> On the "1st group" tab the "Calculate subtotals for" does not have "Value 1"
and "Value 2" checked, and in the "Use function" does not have "Max"
highlighted when I select "Value 1" and "Value 2" in the "Calculate subtotals
for" box.
Pressing OK in this setup results in losing the use of Subtotal feature on this
sheet.
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: dd41459378bca78a18f32e61bfac77aa48fabb8d
CPU threads: 14; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: default
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=109330
[Bug 109330] [META] Subtotal function bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
