Bug 125363 - UI: LibreOffice Calc's AutoFilter treats combining and modifier letters the same as plain letters in the value list
Summary: UI: LibreOffice Calc's AutoFilter treats combining and modifier letters the s...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks:
 
Reported: 2019-05-18 19:24 UTC by Carsten Becker
Modified: 2019-08-25 19:39 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example as requested by comment #2 (10.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-06-11 05:36 UTC, Carsten Becker
Details
bisect result (3.58 KB, text/plain)
2019-08-25 19:39 UTC, raal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Carsten Becker 2019-05-18 19:24:56 UTC
Description:
LibreOffice Calc's 'AutoFilter' popup menu treats combining diacritic letters (like U+0364, U+0366) and modifier letters (like U+1D49) as identical to their plain equivalents in the value list. For instance, in a column that contains both 'tuon' and 'tuͦn' (variant spellings of Middle High German for 'to do'), only one variant will be listed (see screenshot). As expected, filtering for the listed variant indeed only lists those cells in which that variant appears verbatim, but not the other variant.

Steps to Reproduce:
1. Create a list of words in a column containing words with a plain, regular letter and the corresponding combining diacritic letter or modifier letter in its place (e.g. tuon, tuͦn; guet, guͤt; vröude, vröudͤ), make the first cell in the column some field identifier like 'mylist', 'example', or '123'.
2. Data > AutoFilter
3. OK, use first line as header
4. Click the dropdown arrow in the header of the column that contains our word list

Actual Results:
Only one variant of the word is listed in the value list: either with the plain letter (tuon, guet, vröude) or the combining/modifier letter (tuͦn, guͤt, vröudͤ).

Expected Results:
Both variants are listed—AutoFilter doesn't treat superscript/modifier letters the same as their plain equivalents, i.e. all of tuon, tuͦn, guet, guͤt, vröude, vröudͤ are listed as values occuring in the selected column.


Reproducible: Always


User Profile Reset: No



Additional Info:
Screenshot: https://i.imgur.com/DTZhV6e.png
Version: 6.0.7.3
Build-ID: 1:6.0.7-0ubuntu0.18.04.5
CPU-Threads: 4; OS: Linux 4.15; UI-Render: Standard; VCL: kde4; 
Localization schema: de-DE (de_DE.UTF-8); Calc: group
Comment 1 Carsten Becker 2019-05-18 19:29:46 UTC
That should have been 'vröudᵉ', not *vröudͤ.
Comment 2 Xisco Faulí 2019-06-10 16:28:19 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 3 Carsten Becker 2019-06-11 05:36:15 UTC
Created attachment 152087 [details]
Example as requested by comment #2

Added example file as requested by Xisco Faulí in comment #2
Comment 4 raal 2019-08-12 19:17:28 UTC
Confirm with Version: 6.4.0.0.alpha0+
Build ID: 2812610f4f39ed5892da08864893c758325d1d39
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
but not in LO Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 5 raal 2019-08-25 19:39:19 UTC
Created attachment 153646 [details]
bisect result

bibisected with bibisect-41max. The result is a range of 70 commits.