https://bugs.documentfoundation.org/show_bug.cgi?id=150647
Bug ID: 150647
Summary: Autofilter result is wrong when filtering (empty)
records
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 182055
--> https://bugs.documentfoundation.org/attachment.cgi?id=182055&action=edit
test.ods
Steps to Reproduce:
1. Open the attached test ods file.
Observe that there are 7581 records.
(Note that the non empty items in column E are prefixed with several spaces.)
2. Click on the autofilter dropdown in column E named "Cashflow Item", make the
item named "(Empty)" unchecked (i.e. all other non-empty items are checked),
then click OK.
--> Good, there are 47 non-empty records.
3. Click on the autofilter dropdown in column E again, make the item named
"(Empty") checked (i.e., all other non-empty items are not checked).
Current Result:
None records are shown in step 3.
Expected:
There are 7581 - 47 = 7534 records are empty in column E, thus 7534 records
should show up in step 3.
It works OK if you filter in column B.
Version: 7.3.6.1 / LibreOffice Community
Build ID: 92b673af3a5e8f7cf4716be88dfaca424612f244
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
