Bug 166227 - Calc AutoFilter not reset completely after filtering a color
Summary: Calc AutoFilter not reset completely after filtering a color
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: AutoFilter-Color
  Show dependency treegraph
 
Reported: 2025-04-17 13:45 UTC by Johannes
Modified: 2025-04-18 10:01 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file (10.92 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-04-17 13:45 UTC, Johannes
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Johannes 2025-04-17 13:45:36 UTC
Description:
The AutoFilter isn't completely reset after filtering a background color or a font color.

Steps to Reproduce:
1. Open attached example file
2. Filter column A: click on AutoFilter▼ > filter by color > background color > lime
3. Reset filter: data > more filters > reset filter
4. Filter column A: click on AutoFilter▼ > filter by color > background color > lime

Actual Results:
In AutoFilter > filter by color > background color lime is still selected (see the dot).

Expected Results:
Because the filter has been reset, no color should be selected in the AutoFilter.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
This is the case for both background color and font color.
Comment 1 Johannes 2025-04-17 13:45:46 UTC
Created attachment 200375 [details]
Example file
Comment 2 Johannes 2025-04-17 13:48:09 UTC
Reproducable in
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: ea4921a3e31cf87c60e2eceeec46cccdc6a79b23
CPU threads: 4; OS: Linux 6.14; UI render: default; VCL: kf5 (cairo+wayland)
Locale: nl-NL (nl_NL.UTF-8); UI: en-US
Calc: threaded
Comment 3 m_a_riosv 2025-04-18 10:01:27 UTC
And sometimes after reset the filter, filter by color needs twice to work.
Reproducible
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7dddd449068d69ec2f47bfca2487f01fa7067fd0
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-GB
Calc: CL threaded