https://bugs.documentfoundation.org/show_bug.cgi?id=166955
Bug ID: 166955
Summary: CALC: Autofilter indicator (and data display) is lost
when data is filtered and a new filtered column is
added to the array - then removed
Product: LibreOffice
Version: 25.2.3.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When an already filtered table is extended by the addition of another column
AND the filter controls at the top of the table are then extended by selecting
the header row and pressing the "autofilter" button on the ribbon, the
predefined and filtered column(s) will lose their "active filter" indication.
If the new column is then deleted, the pre-filtered column still has no active
filter indication, the pre-filtered items are still included and selected in
the "dropdown" - but they are not present in the displayed array.
It is possible to recover by "de-selecting" the "invisible" item (If you can
remember which one(s)) and then re-selecting. NOTE "Clear Filter" is not
available at this juncture
Steps to Reproduce:
Using the attached file:
Select row 4 and make it a "Filtered Table" with [Ctrl]+[Shft]+[L] or the
predefined autofilter button on the ribbon.
Filter out a selection of days using the Column F Filter
Observe that the "active filter" symbol is present and some days are concealed
Enter the text string "Aitch" at H4
It's irrelevant whether any data is entered into any of the cells in column H
Select row 4 and use either method to extend the filtered headers into Column H
Observe that the "active filter" symbol is no longer present in the Header for
column F
Observe that the days you just filtered out are also not present
Observe that the filter "drop-down" for Column F now includes all days even
though you have de-selected some
Select Column H and using your favourite method - Delete column H
Observe that the de-selected days are still not visible and the filter dropdown
for column F still tries to convince you that they are present
You will be able to repair the false representation by deselecting and
re-selecting any day(s)
Actual Results:
Filter integrity is compromised with a misleading activity and content status
Expected Results:
Adequacy and accuracy of the filter display
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: bbb074479178df812d175f709636b368952c2ce3
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Raster; VCL: win
Locale: sv-SE (en_SE); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
