<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - UI: LibreOffice Calc's AutoFilter treats combining and modifier letters the same as plain letters in the value list"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125363">125363</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>UI: LibreOffice Calc's AutoFilter treats combining and modifier letters the same as plain letters in the value list
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.7.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>carbeck+bugzilla@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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: <a href="https://i.imgur.com/DTZhV6e.png">https://i.imgur.com/DTZhV6e.png</a>
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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>