Created attachment 148812 [details]
Test ODS File
The attached ODS file contains values "乙二醇(进口料件)" and "乙二醇（进口料件）". The first value has half-width parentheses (i.e., "()"), while the second value has full-width parentheses (i.e., "（）"). When using auto-filter, the autofilter dropdown box shows only the half-width value.
Steps to Reproduce:
1. Click the drop-down list of auto filter in the attached ODS file.
The list shows values "乙二醇(进口料件)" and "乙二醇（进口料件）". These are different values.
The list shows value "乙二醇(进口料件)" only.
This issue is hard to identify. I produced wrong results in many mission-critical work. Calc autofilter is useless under this circumstance.
Reproduced in versions:
CPU 线程：4; 操作系统：Linux 4.15; UI 渲染：默认; VCL: gtk3;
区域语言：zh-CN (zh_CN.UTF-8); Calc: group
Build ID: f18954c1ba9116b85c32b6bdbc0188d3e0fd24c7
CPU 线程: 4; 操作系统: Linux 4.15; UI 渲染: 默认; VCL: gtk2;
区域语言: zh-CN (zh_CN.UTF-8); Calc: group threaded
Ubuntu 18.04 LTS.
Thank you for reporting the bug. I confirm this bug in
Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win;
TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04
Locale: en-US (en_US); UI-Language: en-US
Bibisected on Linux with 41max to range https://gerrit.libreoffice.org/plugins/gitiles/core/+log/8a39c27633e75819e219bc5d179375fb4308a3ca..dc173b7f2a550185404aacbc6da744cb6d1880fc
This seems to be the one: https://gerrit.libreoffice.org/plugins/gitiles/core/+/338140e5201bc23625eacd1a4740622e6241cbc2%5E%21/
bnc#492440: Sort autofilter popup items correctly.
The severity is normal rather than major as there is no crash or a completely nonworking feature https://wiki.documentfoundation.org/images/0/06/Prioritizing_Bugs_Flowchart.jpg
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.