Bug 150077

Summary: Allow to choose several color options in the automatic filter
Product: LibreOffice Reporter: Matías Benzo <mgb1508>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED DUPLICATE    
Severity: enhancement CC: 79045_79045, libreoffice-ux-advise, mgb1508
Priority: medium Keywords: needsUXEval
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 142076    
Attachments: Automatic filter example spreadsheet to filter by color.

Description Matías Benzo 2022-07-20 16:18:12 UTC
Created attachment 181348 [details]
Automatic filter example spreadsheet to filter by color.

Currently the background color or font color filter in the Calc automatic filter does not allow several color options to be selected.
It should be noted that this is possible from the standard filter by accumulating several filters with the boolean function Or.
It would be practical to allow you to choose several color options in the automatic filter (in the same way that you can choose multiple numbers, text strings, dates, etc.).

Steps to reproduce:
1. Open the attached spreadsheet.
2. Filter in the column "Color", choosing Background Color.
3. Select Red 1 and Yellow.

Current results:
Only one color at a time is allowed.

Expected results:
Many colors can be chosen simultaneously.
Comment 1 Roman Kuznetsov 2022-07-23 16:14:02 UTC
I think we already discussed it and there was a UX/dev decision don't realize it because Excel doesn't do so.

Heiko, do you remember something about it?
Comment 2 Heiko Tietze 2022-07-25 13:39:20 UTC
The request on the duplicate ticket was resolved as "works for me". Cannot confirm on macOS with latest master. Will reopen it.

*** This bug has been marked as a duplicate of bug 142522 ***
Comment 3 syevale111 2022-12-08 09:06:21 UTC Comment hidden (spam)
Comment 4 ashnamalik 2023-04-19 09:12:24 UTC Comment hidden (spam)
Comment 5 Rishu Agarwal 2023-04-19 09:52:43 UTC Comment hidden (spam)
Comment 6 nimritkaur12 2023-04-19 09:54:32 UTC Comment hidden (spam)
Comment 7 Rishu Agarwal 2023-04-19 09:59:59 UTC Comment hidden (spam)
Comment 9 Heiko Tietze 2023-06-12 11:09:26 UTC

*** This bug has been marked as a duplicate of bug 142522 ***