[Libreoffice-bugs] [Bug 123095] Auto filter result is wrong when cell value contains full-width and half-width characters and case-insensitive filtering is used
https://bugs.documentfoundation.org/show_bug.cgi?id=123095 Andreas Heinisch changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |andreas.heini...@yahoo.de |desktop.org | Status|NEW |ASSIGNED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 123095] Auto filter result is wrong when cell value contains full-width and half-width characters and case-insensitive filtering is used
https://bugs.documentfoundation.org/show_bug.cgi?id=123095 --- Comment #9 from stragu --- (In reply to Takeshi Abe from comment #4) > By the way the reported behavior is due to the default case-insensitive > filtering. > A simple workaround is to open the Standard Filter dialog by choosing > "Standard Filter ..." in the popup, check "Case sensitive" in the "Options" > drawer, and enter OK. Then both "乙二醇(进口料件)" and "乙二醇(进口料件)" appears in the > drop-down list. I don't think that is right, or maybe the behaviour has changed since then, but with original attachment 148812 you'll notice that: 1. Copy cell A3 and paste into AutoFilter search field, click OK 2. Result: nothing is shown 3. Go back to showing all (or Ctrl + Z) 4. Open Standard Filter, make sure "Case sensitive" is _not_ ticked 5. Paste the same contents to create the condition "Name = 乙二醇(进口料件)" 6. Result: the corresponding row (row 3) is shown So, with AutoFilter (by default case-insensitive) and Standard Filter (regardless of case sensitivity), we get different results in the case of those special characters. Reproduced with: Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 94d552f94b427f884c004dba5d4619ecf729d605 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-18_13:30:27 Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123095] Auto filter result is wrong when cell value contains full-width and half-width characters and case-insensitive filtering is used
https://bugs.documentfoundation.org/show_bug.cgi?id=123095 himajin100...@gmail.com changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||5363 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123095] Auto filter result is wrong when cell value contains full-width and half-width characters and case-insensitive filtering is used
https://bugs.documentfoundation.org/show_bug.cgi?id=123095 --- Comment #8 from Kevin Suo --- Maybe we can treat "(x)" and "(x)" to be the same because case-sensitive is off, but the problem is that if they are treated the same, then if I select "(x)" in the dropdown list and click OK, then the filtered result should include both "(x)" and "(x)". Steps to Reproduce: 1. Produce the following records: a (x) (x) y 2. Set autofilter. --> It shows "(x)" and "y". (Fine, if we agree that the half-width and full-with brackets are the same). 3. Select "(x)" only in the dropdown, click OK. --> Bug! Only the "(x)" is in the filtered result. (This is the risk part I am concerning. You will miss the "(x)" in your data analyzing flow.) I have no idea whether there are other chars being treated this way. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123095] Auto filter result is wrong when cell value contains full-width and half-width characters and case-insensitive filtering is used
https://bugs.documentfoundation.org/show_bug.cgi?id=123095 --- Comment #7 from Kevin Suo --- Maybe we can treat "(x)" and "(x)" to be the same is case-sensitive is off, but the problem is the if they are treated the same, then if I select "(x)" in the dropdown list and click OK, then the filtered result should include both "(x)" and "(x)". Steps to Reproduce: 1. Produce the following records: a (x) (x) y 2. Set autofilter. --> It shows "(x)" and . (Fine if we agree that the half-width and full-with brackets are the same). 3. Select "(x)" only in the dropdown, click OK. --> Bug! Only the "(x)" is in the filtered result. (This is the risk part I am concerning. You will miss the "(x)" in your data analyzing flow.) I have no idea whether there are other chars being treated this way. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123095] Auto filter result is wrong when cell value contains full-width and half-width characters and case-insensitive filtering is used
https://bugs.documentfoundation.org/show_bug.cgi?id=123095 Kevin Suo changed: What|Removed |Added Keywords||bisected -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123095] Auto filter result is wrong when cell value contains full-width and half-width characters and case-insensitive filtering is used
https://bugs.documentfoundation.org/show_bug.cgi?id=123095 --- Comment #6 from Kevin Suo --- I confirm it is caused by commit 338140e5201bc23625eacd1a4740622e6241cbc2 author Kohei Yoshida Wed Jan 30 22:32:28 2013 -0500 bnc#492440: Sort autofilter popup items correctly. Changing GetCaseCollator back to GetCaseTransliteration will make the autofilter in this case work OK again. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123095] Auto filter result is wrong when cell value contains full-width and half-width characters and case-insensitive filtering is used
https://bugs.documentfoundation.org/show_bug.cgi?id=123095 Kevin Suo changed: What|Removed |Added CC||ko...@libreoffice.org --- Comment #5 from Kevin Suo --- Still reproducible on libreoffice 7.0. This behaviour is very dangerous - It may cause hard-to-identify error in your spreadsheet results. Adding cc to Kohei Yoshida as it was bibisected to one of your old commit. Could you please take a loook? Thanks. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123095] Auto filter result is wrong when cell value contains full-width and half-width characters and case-insensitive filtering is used
https://bugs.documentfoundation.org/show_bug.cgi?id=123095 Buovjaga changed: What|Removed |Added Summary|Auto Filter Result is Wrong |Auto filter result is wrong |When Cell Value Contains|when cell value contains |Full-width and Half-width |full-width and half-width |Characters |characters and ||case-insensitive filtering ||is used -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs