https://bugs.documentfoundation.org/show_bug.cgi?id=153972
Bug ID: 153972 Summary: Calc autofilter can't choose background colour when cell has no content Product: LibreOffice Version: 7.4.5.1 release Hardware: All OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: lob...@web.de Created attachment 185755 --> https://bugs.documentfoundation.org/attachment.cgi?id=185755&action=edit Autofilter can't choose background colour If you want to filter cells with the autofilter, you can't choose background colour if the cells has no content. 1. Open attached file. Description of the columns: Column a: All cells has no content. Column b: One cell of each background colour has content. Column c: All cells of each background colour has context. 2. Click in column a the autofilter and try to choose background colour, this is no possible. 3. Click in column b the autofilter and choose any background colour, this is possible. If the cells are filtered, all cells with the selected background are shown. 4. Click in column c the autofilter and choose any background colour, this is possible. If the cells are filtered, all cells with the selected background are shown. Works as in column b. It is not possible to filter by a background color unless at least one cell has a content. Occurs in Version: 7.4.5.1 (x86) / LibreOffice Community Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: threaded Version: 7.5.0.3 (X86_64) / LibreOffice Community Build ID: c21113d003cd3efa8c53188764377a8272d9d6de CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: threaded Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1309e6332d7ff2bd1f9b6bf87385b8b570e59158 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.