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
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ͤ).
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.
User Profile Reset: No
CPU-Threads: 4; OS: Linux 4.15; UI-Render: Standard; VCL: kde4;
Localization schema: de-DE (de_DE.UTF-8); Calc: group
That should have been 'vröudᵉ', not *vröudͤ.
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.
Created attachment 152087 [details]
Example as requested by comment #2
Added example file as requested by Xisco Faulí in comment #2
Confirm with Version: 18.104.22.168.alpha0+
Build ID: 2812610f4f39ed5892da08864893c758325d1d39
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
but not in LO Version 22.214.171.124.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Created attachment 153646 [details]
bibisected with bibisect-41max. The result is a range of 70 commits.