Description: The latest update of LibreOffice calc introduced the ability to filter by Background or text colour which works if you manually change the cell colours. If the Background or text colour are changed by conditional formatting this does not show in the filter selection so you cannot filter by it. Steps to Reproduce: 1.Create a list of numbers with some duplicates 2.used the conditional format - condition to format the duplicate values as 'errors' which have white text on a red background. 3.Apply an auto filter to the list. 4:Neither the red background or white text appear in the Text Colour or Background colour in the filter selection. Actual Results: Background & text colour not shown in filter selection Expected Results: Background & Text colour should appear in filter selector allowing cells formatted by conditional formatting to be filtered. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: [Information automatically included from LibreOffice] Locale: en-GB Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes https://gerrit.libreoffice.org/gitweb?p=core.git;a=log;h=9a9c6381e3f7a62afc1329bd359cc48accb6435b (the rest will not copy)
Thanks for reporting. The issue with supporting colors from conditional formatting has been raised in bug 142579 and bug 142580. But since those are about XLSX compatibility specifically, I'm not marking any duplicates yet, and let the developers or senior QA people decide.
Yeah this should be fixed with bug 142579 and bug 142580. *** This bug has been marked as a duplicate of bug 142579 ***
If it still doesn't work with the next daily build, please provide a sample document so that I can reproduce.