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.
