Bug 122759

Summary:	AutoFilter list is created not case sensitive but filtering is case sensitive
Product:	LibreOffice	Reporter:	Gabor Kelemen (allotropia) <kelemeng>
Component:	Calc	Assignee:	Attila Szűcs <attila.szucs>
Status:	VERIFIED FIXED
Severity:	normal	CC:	buzea.bogdan, himajin100000, libreoffice, nemeth, xiscofauli
Priority:	medium
Version:	6.3.0.0.alpha0+
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=123204
Whiteboard:	target:7.1.0 target:7.0.3
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	103512
Attachments:	Autofilter list in Calc with different cased options The same situation in Excel - only one option is listed Example file from Calc Autofilter in current Calc master Autofilter in Calc 6.0.7 In current master from bibisect-win32 repo

Description Gabor Kelemen (allotropia) 2019-01-16 15:28:27 UTC

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:

Comment 1 Gabor Kelemen (allotropia) 2019-01-16 15:28:56 UTC

Created attachment 148361 [details]
The same situation in Excel - only one option is listed

Comment 2 Gabor Kelemen (allotropia) 2019-01-16 15:29:34 UTC

Created attachment 148362 [details]
Example file from Calc

Comment 3 BogdanB 2019-01-16 15:36:33 UTC

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

Comment 4 BogdanB 2019-01-16 15:37:52 UTC

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

Comment 5 Durgapriyanka 2019-01-16 17:17:36 UTC

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

Comment 6 Gabor Kelemen (allotropia) 2019-01-16 22:30:20 UTC

Okay, the xlsx attachment is not a good example, sorry.

Try with a new document, in current 6.3 master I can reproduce it.

Comment 7 Gabor Kelemen (allotropia) 2019-01-16 22:38:59 UTC

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

Comment 8 Gabor Kelemen (allotropia) 2019-01-16 22:40:49 UTC

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

Comment 9 BogdanB 2019-01-17 10:07:58 UTC

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

Comment 10 BogdanB 2019-01-17 14:05:30 UTC

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

Comment 11 Tamás Zolnai 2019-01-18 11:18:59 UTC

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).

Comment 12 Xisco Faulí 2019-01-21 18:19:18 UTC

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:

Comment 13 Xisco Faulí 2019-01-21 18:20:18 UTC

@Gabor, do you reproduce it in safe mode ?

Comment 14 Gabor Kelemen (allotropia) 2019-01-22 07:22:43 UTC

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

Comment 15 Roman Kuznetsov 2019-02-03 19:55:46 UTC

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?

Comment 16 NISZ LibreOffice Team 2019-11-08 13:31:55 UTC

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 :(.

Comment 17 Commit Notification 2020-08-28 12:26:34 UTC

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.

Comment 18 BogdanB 2020-08-31 09:56:17 UTC

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

Comment 19 NISZ LibreOffice Team 2020-08-31 10:06:58 UTC

(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

Comment 20 BogdanB 2020-08-31 10:12:09 UTC

Ok, so I let this as verified based on your comment. ;)

Comment 21 Commit Notification 2020-10-10 21:45:36 UTC

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.