Apache OpenOffice (AOO) Bugzilla – Issue 105232
Wrong sorting of documents when using diacritics and user defined sort lists
Last modified: 2014-03-09 08:13:27 UTC
Umlauts like Ä, Ö, Ü should be sorted as if they are A, O, U. This works fine normally but when applying a user defined sort list, the sort fails. Do the following: 1. Open the attached file sort_test_c.ods 2. First simply sort it by the first column (name): Data > Sort > Sort by... name. 3. You will get a correct sorting (AÄ, OÖ, UÜ, Z). 4. Now do it again and include the second column (month): Data > Sort > Options > User-defined sort order (select this option and highlight the entry Jan/Feb/Mar...). Then go to the first tab and select to sort first by name and second by month. 5. The sorting changes to an incorrect order: Ä, Ö, Ü, A, O, U, Z. Actually the sorting should remain the same, since all names are different.
Created attachment 64876 [details] Calc file for reproducing the scenario
I can reproduce this with 3.1.1. The issue is likely that when multiple column sort is enabled, the 'User-defined sort' is applied to all columns, but one should apply it only to the columns that contain the of that type. So the 'User-defined sort' should become a property of each sort column on the first tab, or Calc should be smart enough to figure out with column(s) is(are) according the 'User-defined sort' order. The next issue will become that an user wants to sort on Month and Weekday, so to 'User-defined sort' orders are involved....
Reset assignee on issues not touched by assignee in more than 2000 days.
After step 4 in description: Anders Ohnsorg Ullmeier Zypries Aller Ohremann Umit AOO410m1(Build:9750) - Rev. 1543812 Rev.1543812 Win 7
Version has been modified erroneous, so back to most early version Comment 2 seems plausible, but sample document is unlikely to for detailed tests. And currently I do not see relation to diacritics. I will do some more research, soon.