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.

Reply via email to