https://bugs.documentfoundation.org/show_bug.cgi?id=159420
Bug ID: 159420
Summary: EDITING Autofilter for empty cells disabled when by
Autofilter in other column empty cells filtered out
Product: LibreOffice
Version: 24.8.0.0 alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: stefan_lange...@t-online.de
Created attachment 192214
--> https://bugs.documentfoundation.org/attachment.cgi?id=192214&action=edit
Test document to show the behavior.
In the Autofilter list for a column the entry "empty" is disabled when in an
other column empty cells are filtered out (excluded, not displayed).
Reproducing the behavior:
- open the attached document "Alte Fotoapparate_Test_3_Autofilter.ods"
- select by autofilter in column B e.g. "Altix IV" or "Altix V" (or in column C
e.g. "ohne") but not "(empty)" in such manor that also some empty cells in
column F remain displayed
- look to the autofilter list of column F
expected: Also the entry "(empty)" is enabled (black)
found: The entry "(empty)" is disabled (gray)
The behavior depends on setting LibreOfficeDev Calc - Compute - Search criteria
= and <> ...:
- when unchecked the wrong behavior also occurs when in the filter first set
empty cells are not excluded
- when checked then behavior as decribed above
Reproduced with
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: ace5f5cbee7ea2c21ff9a3fe9b859b83a006edd6
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
from Win-x86_64@tb77-TDF/2024-01-28_03.25.59
The wrong behavior first occured with
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 4d0f2d5ec9f7f988a1493916ae35bac1986c95a8
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
from Win-x86_64@tb77-TDF/2024-01-18_21.35.44.
The behavior was OK (as expected) until
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 25276df12abd9d002f7f899900434617b256f745
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
from Win-x86_64@tb77-TDF/2024-01-06_02.53.48
--
You are receiving this mail because:
You are the assignee for the bug.
