Bug 150077 - Allow to choose several color options in the automatic filter
Summary: Allow to choose several color options in the automatic filter
Status: CLOSED DUPLICATE of bug 142522
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks: AutoFilter-Color
  Show dependency treegraph
 
Reported: 2022-07-20 16:18 UTC by Matías Benzo
Modified: 2023-06-12 11:09 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Automatic filter example spreadsheet to filter by color. (10.31 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-07-20 16:18 UTC, Matías Benzo
Details

Note You need to log in before you can comment on or make changes to this bug.
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 ***