Created attachment 148360 [details] Autofilter list in Calc with different cased options Having a word in different cases in a Calc column and applying autofilter to the column results in all different versions being displayed in the autofilter list. However the actual filtering is not case sensitive, i.e. I have to unmark all the different cased options to actually hide them. In Excel, the filter list is not case sensitive and there is only the first occurrence of the word listed. Unselecting it hides all different cased options. Version: 6.3.0.0.alpha0+ Build ID: 17dd2662ccfa9d04efbea74e5d7548db5b2126d4 CPU threads: 4; OS: Windows 6.3; UI render: GL; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc:
Created attachment 148361 [details] The same situation in Excel - only one option is listed
Created attachment 148362 [details] Example file from Calc
In Versiune: 6.0.7.3 everythnig is ok. Identificator construire: dc89aa7a9eabfd848af146d5086077aeed2ae4a5 Fire CPU: 4; OS: Linux 4.15; Redare UI: implicit; VCL: gtk2; Setări regionale: ro-RO (ro_RO.UTF-8); Calc: group
In Version: 6.3.0.0.alpha0+ everything is ok, just 2 options: else and Caps. Build ID: afbbdcc216a84b59fb263777659b044c4a7cf6f0 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-01-13_03:54:12 Locale: ro-RO (ro_RO.UTF-8); UI-Language: en-US Calc: threaded
No reproduction in Version: 6.3.0.0.alpha0+ Build ID: 3c964980da07892a02d5ac721d80558c459532d0 CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45 Locale: en-US (en_US); UI-Language: en-US Calc: threaded
Okay, the xlsx attachment is not a good example, sorry. Try with a new document, in current 6.3 master I can reproduce it.
Created attachment 148379 [details] Autofilter in current Calc master Version: 6.3.0.0.alpha0+ Build ID: 5843e14a4ddc6d2b1e375ca26eec33033bfad455 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: hu-HU (hu_HU.UTF-8); UI-Language: en-US Calc: threaded
Created attachment 148380 [details] Autofilter in Calc 6.0.7 No repro with: Verzió: 6.0.7.3 Build az.: 1:6.0.7-0ubuntu0.18.04.2 CPU szálak: 4; OS: Linux 4.15; Felületmegjelenítés: alapértelmezett; VCL: gtk3; Területi beállítások: hu-HU (hu_HU.UTF-8); Calc: group
NO PROBLEM With a new file on Version: 6.3.0.0.alpha0+ (x64) Build ID: 423d70f7e45749fad680b3dfe0ccdaed1c1afb19 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-01-14_23:07:06 Locale: ro-RO (ro_RO); UI-Language: en-US Calc: threaded
No problem in a new file on Version: 6.3.0.0.alpha0+ (x64) Build ID: 62ce65fe042543e7aeaf83bf66f8c2357ff902c6 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-01-17_02:33:10 Locale: ro-RO (ro_RO); UI-Language: en-US Calc: threaded
I can reproduce it on Windows 8.1 (git hash: 0515ffdb2e4c975f1d19257dfed2a24ff3cbfdb4) with creating a column with the same word with different letter cases. The autofilter dropdown list has all the different case words as separate entries. However I can't reproduce it on Linux (git hash: 0515ffdb2e4c975f1d19257dfed2a24ff3cbfdb4). Maybe it's a Windows specific issue or it was fixed between the two git versions (my Windows build is older).
I can't reproduce it in Versión: 6.2.0.2 Id. de compilación: 2ce5217b30a543f7666022df50f0562f82be0cff Subprocs. CPU: 1; SO: Windows 6.1; Repres. IU: predet.; VCL: win; Configuración regional: es-ES (es_ES); Idioma de IU: es-ES Calc: threaded nor in Version: 6.3.0.0.alpha0+ Build ID: 3fa4674615b747e219afe5bf0a9b689df3840439 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc:
@Gabor, do you reproduce it in safe mode ?
Created attachment 148500 [details] In current master from bibisect-win32 repo Still the same. Version: 6.3.0.0.alpha0+ Build ID: 309ab4419b1d1a4cd0ce939c3a0af4d4af5d4b6b CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: threaded
don't repro in Версия: 6.3.0.0.alpha0+ ID сборки: 51af3179cf972809d6495c7d58033e069f647bbf Потоков ЦП: 4; ОС:Linux 4.18; Отрисовка ИП: по умолчанию; VCL: kde5; TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-02-01_00:15:00 Локаль: ru-RU (ru_RU.UTF-8); UI-Language: ru-RU Calc: threaded may be really it's only win problem?
Seems to not happen in: Version: 6.4.0.0.alpha1+ (x86) Build ID: 80109586e6cb6d3e2e0a53a9079c3125ec9b8368 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; Locale: en-US (hu_HU); UI-Language: en-US Calc: CL But it does in: Version: 6.4.0.0.alpha1+ (x86) Build ID: 80109586e6cb6d3e2e0a53a9079c3125ec9b8368 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: CL Hungarian locale specific :(.
Attila Szűcs committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0baa63eb00cf42712584dc87cc9874df1195c24a tdf#122759 sc: fix Autofilter case sensitivity for Hungarian It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Solved, verified in Version: 7.1.0.0.alpha0+ Build ID: e2f4e65a7b8024c00b049eebf0d87637efda7f24 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
(In reply to BogdanB from comment #18) > Solved, verified in > Version: 7.1.0.0.alpha0+ > Build ID: e2f4e65a7b8024c00b049eebf0d87637efda7f24 > CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 > Locale: ro-RO (ro_RO.UTF-8); UI: en-US > Calc: threaded You did not use Hungarian locale. But it is indeed fixed in: Version: 7.1.0.0.alpha0+ (x64) Build ID: 1e0cfd5662d95cea84e80e4fe10d52c3b1101ae6 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: CL
Ok, so I let this as verified based on your comment. ;)
Attila Szűcs committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/d2cf0df6696e42c36b2de4ca5548da6e656f08c5 tdf#122759 sc: fix Autofilter case sensitivity for Hungarian It will be available in 7.0.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.