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.
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
Created attachment 190983 [details] Demo document
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
This seems to have begun at the below commit in bibisect repository/OS linux-64-7.4. Adding Cc: to Xisco Fauli ; Could you possibly take a look at this one? Thanks ff232b32dd0237c259d738eb676bfcf1994cee8e is the first bad commit commit ff232b32dd0237c259d738eb676bfcf1994cee8e Author: Jenkins Build User <tdf@pollux.tdf> Date: Thu Oct 13 19:52:50 2022 +0200 source 1b1ad0e3d5988c5e16dabfaa40252a22dab517b7 141288: tdf#125363, tdf#123095 - Use CaseTransliteration for autofilter | https://gerrit.libreoffice.org/c/core/+/141288
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
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.
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)
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.
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.
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.