https://bugs.documentfoundation.org/show_bug.cgi?id=171180
Bug ID: 171180
Summary: Subtotal Row Disappear When Filter Is Active
Product: LibreOffice
Version: 26.2.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When a subtotal row is placed at the last row of a dataset and a filter is
applied to the entire range, activating the filter hides the subtotal row along
with the filtered data.
If the filter is cleared (showing All), the subtotal row becomes visible again.
However, whenever any filter condition is applied, the subtotal row is filtered
out and no longer displayed.
Steps to Reproduce:
1. Data rows are located from row 2 to row 40.
2. Subtotal formula is placed in row 41.
3. Auto Filter is applied to the entire dataset.
4. Apply a filter on a column (e.g., Area) to display only "West".
5. The subtotal row (row 41) is also filtered out and becomes hidden.
5. The subtotal row gets filtered too.
Actual Results:
The subtotal row is hidden when the filter is applied.
Expected Results:
The subtotal row should remain visible so the aggregated value can still be
seen after filtering.
Reproducible: Always
User Profile Reset: No
Additional Info:
1st workaround is to put the subtotal row above the data range, that is at row
1.
2nd workaround is to leave 3 blank rows after the last data row, and that is at
row 44.
Yes, I understand it is technically working as intended since the column "Area"
of the subtotal row is blank.
Version: 26.2.1.2 (X86_64)
Build ID: 8399f6259d8c87f40e7255cdb3c9b958f5e08948
CPU threads: 16; OS: Linux 6.19; UI render: default; VCL: gtk3
Locale: en-US (C.UTF-8); UI: en-US
Flatpak
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
