<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Auto filter result is wrong when cell value contains full-width and half-width characters and case-insensitive filtering is used"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123095#c9">Comment # 9</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Auto filter result is wrong when cell value contains full-width and half-width characters and case-insensitive filtering is used"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123095">bug 123095</a>
from <span class="vcard"><a class="email" href="mailto:stephane.guillou@member.fsf.org" title="stragu <stephane.guillou@member.fsf.org>"> <span class="fn">stragu</span></a>
</span></b>
<pre>(In reply to Takeshi Abe from <a href="show_bug.cgi?id=123095#c4">comment #4</a>)
<span class="quote">> 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.</span >
I don't think that is right, or maybe the behaviour has changed since then, but
with original <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=148812" name="attach_148812" title="Test ODS File">attachment 148812</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=148812&action=edit" title="Test ODS File">[details]</a></span> 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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>