Description: There is no way to select cells without color text or color filling in Autofilter Steps to Reproduce: 1. Open file from attach 2. open Autofilter window in A1 cell 3. Try select cells without color text or color filling => no way MS Excel has an item with label "Without fill" as subitem in Filter by Color item in Autofilter Actual Results: There is no way to select cells without color text or color filling in Autofilter Expected Results: There is way to select cells without color text or color filling in Autofilter Reproducible: Always User Profile Reset: No Additional Info: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: de7356c2e0cb099fac396808b5a86a0393b48e5f CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: threaded
Created attachment 173053 [details] Example file with Autofilter and color filling in cells
Samuel, Heiko, what do you think about it? I asked do it in bug 76258, but today I don't see we have this opportunity
Sounds like a good idea. Can you share a screenshot of how this looks like in Excel? IIRC in Excel 2013 this feature was not yet there.
would it be possible to solve it this way? Thanks Bug 142761 - optimization of the ergonomics and appearance of the automatic filter menu
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 5fb7f66d240fec32a4751d331a215307ad994cbb CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: threaded I can select '3' without any other step.
Created attachment 173056 [details] How it looks in Excel
(In reply to m.a.riosv from comment #5) > Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community > Build ID: 5fb7f66d240fec32a4751d331a215307ad994cbb > CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: > win > Locale: es-ES (es_ES); UI: en-US Calc: threaded > > I can select '3' without any other step. But I want to select 1, 3 and 5 that don't have any filling at an one time using filtering by color as I can do it in Excel now
I think understood now.
Created attachment 173241 [details] XLSX Bugdoc
The attribute fo:background-color in file source can have the value "transparent" in addition to rgb- color values. Transparent is missing in the list of color values in the Autofilter. LibreOffice writes attribute style:use-window-fontcolor="true" in case "Automatic" was chosen in the UI. Which means, that the font color is White if the background is too dark. The item "Automatic" is missing in the list of color values in the Autofilter. This situation is not yet included in the proposal for ODF.
The proposal in https://issues.oasis-open.org/browse/OFFICE-4107 has in filter-condition in the comparison the value "window-font-color" for text color and "transparent" for background-color.
Samuel Mehrbrodt committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/ba1e42f05e785c30d03553acd5647eebd7cdede6 tdf#142965 color filter: allow filtering by no fill/automatic color It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.