https://bugs.documentfoundation.org/show_bug.cgi?id=145889
Bug ID: 145889
Summary: Autofilter result is wrong if the column contains the
number "1000" and the text "'1000"
Product: LibreOffice
Version: 7.3.0.0 alpha0+ Master
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: suokunl...@126.com
Steps to Reproduce:
1. Type the following in cells A1, A2 and A3:
a
1000
'1000
i.e., the data label is "a", the first value is the number 1000, and the second
value is the text 1000.
2. Set autofilter, click the dropdown, deselect the first item, OK.
--> The filter result is empty.
Expected: The filter result should either show the number 1000, or the text
'1000.
Further Steps:
3. Based on step 2, now click the dropdown and select "All", OK.
--> Autofilter is still set, with empty result.
Expected: The autofilter should reset and all the records should show up.
One such real-world use case document is column B ("Allocation") in attachment
176404 of bug 136838.
Version: 7.3.0.0.alpha1+ / LibreOffice Community
Build ID: a029e07ffbd6ea4a4a191188c5be2eca7e10066d
CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN
Build Platform: Fedora34@X64, Branch:master, bibisect-linux-64-7.3-CN
Calc: threaded
Fedora 34 Wayland
--
You are receiving this mail because:
You are the assignee for the bug.
