Bug 158326 - FILTER autofilter seems to convert ß in ss and ignores value
Summary: FILTER autofilter seems to convert ß in ss and ignores value
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:24.8.0 target:24.2.1 target:7.6.6
Keywords: bibisected, bisected, regression
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
 
Reported: 2023-11-22 20:56 UTC by bugzilla-libreoffice
Modified: 2024-02-27 09:42 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
Demo document (11.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-11-23 06:04 UTC, BogdanB
Details
Showing additional problems (19.49 KB, image/png)
2023-11-28 15:01 UTC, Andreas Heinisch
Details

Note You need to log in before you can comment on or make changes to this bug.
Description bugzilla-libreoffice 2023-11-22 20:56:56 UTC
If a dataset contains following values:

...
Strasser
Straßer

and an autofilter is applied, the value Straßer is ignored and not visible in the filter list.

If the dataset changes to 
...
Strasser
Straßer <--- with space

the value "Straßer " is in the filter list, but the values will still be not shown after selection.

If the dataset changes to 
...
Strasser
 Straßer

with space on the beginning it works as it should.

Thank you very much for your great work.
Comment 1 m_a_riosv 2023-11-22 23:06:23 UTC
Reproducible:
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: bc5c767e9aebadf12aa6a181a6ce066cbfff71ad
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: default; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Version: 7.4.7.2 (x64) / LibreOffice Community
Build ID: 723314e595e8007d3cf785c16538505a1c878ca5
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: es-ES Calc: CL


Last working for me:
Version: 7.2.7.2 (x64) / LibreOffice Community
Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: es-ES Calc: CL
Comment 2 BogdanB 2023-11-23 06:04:18 UTC
Created attachment 190983 [details]
Demo document
Comment 3 BogdanB 2023-11-23 06:13:15 UTC
7.3.0.0.alpha0+ is working well for me
Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 9df0e11c48071fb5ed98d474ea036a3f7d10e7ba
CPU threads: 16; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

Also in
Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 10981fb2fa26474f432e85165b1babbca6d74e16
CPU threads: 16; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

Also in
Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: b419eb4bd407c26ee813a347fdf14424908379e1
CPU threads: 16; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded


NOT WORKING in
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 16; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

NOT working in
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 94d2d9a59450fa4bccd0a3a450d8b273271d2ff2
CPU threads: 16; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 4 raal 2023-11-26 08:30:55 UTC Comment hidden (obsolete)
Comment 5 Xisco Faulí 2023-11-28 09:13:08 UTC
Regression introduced by:

author	Andreas Heinisch <andreas.heinisch@yahoo.de>	2022-10-07 11:59:33 +0200
committer	Xisco Fauli <xiscofauli@libreoffice.org>	2022-10-13 18:10:10 +0200
commit 1b1ad0e3d5988c5e16dabfaa40252a22dab517b7 (patch)
tree e16f9991c80867690ada1a88bc2f7bcb3f5b71a7
parent 09c9346960afaab5a9c03a0e4cf3dd8eb21ca4a0 (diff)
tdf#125363, tdf#123095 - Use CaseTransliteration for autofilter

Adding Cc: to Andreas Heinisch
Comment 6 Andreas Heinisch 2023-11-28 10:15:36 UTC
The German Eszett will be transliterated to ss with the problematic change and therefore only Strasser is shown. Maybe Eike knows how to overcome this problem.
Comment 7 Andreas Heinisch 2023-11-28 15:01:34 UTC
Created attachment 191100 [details]
Showing additional problems

Imho we have to divide sorting and filtering for the auto filter because this causes additional problems (see attachment)
Comment 8 Commit Notification 2024-02-01 12:33:14 UTC
Andreas Heinisch committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/6d0fddb697fd619d11da3469f4dd72782334f3bb

tdf#158326 - Auto Filter: separate sorting and removing of duplicates

It will be available in 24.8.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 9 Commit Notification 2024-02-08 12:32:26 UTC
Andreas Heinisch committed a patch related to this issue.
It has been pushed to "libreoffice-24-2":

https://git.libreoffice.org/core/commit/bacf30464c601663c7c58020e7bf230cd3661768

tdf#158326 - Auto Filter: separate sorting and removing of duplicates

It will be available in 24.2.1.

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 10 Commit Notification 2024-02-27 09:42:23 UTC
Andreas Heinisch committed a patch related to this issue.
It has been pushed to "libreoffice-7-6":

https://git.libreoffice.org/core/commit/d2d8332dc9dee0baed504470a3b80d431bc255a8

tdf#158326 - Auto Filter: separate sorting and removing of duplicates

It will be available in 7.6.6.

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.