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.