Issue 105232 - Wrong sorting of documents when using diacritics and user defined sort lists
Summary: Wrong sorting of documents when using diacritics and user defined sort lists
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows, all
: P4 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-09-21 08:34 UTC by cordyph
Modified: 2014-03-09 08:13 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Calc file for reproducing the scenario (8.97 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-09-21 08:35 UTC, cordyph
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description cordyph 2009-09-21 08:34:19 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.
Comment 1 cordyph 2009-09-21 08:35:54 UTC
Created attachment 64876 [details]
Calc file for reproducing the scenario
Comment 2 eremmel 2010-01-28 17:03:42 UTC
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....
Comment 3 Rob Weir 2013-07-30 02:13:36 UTC
Reset assignee on issues not touched by assignee in more than 2000 days.
Comment 4 Edwin Sharp 2013-11-27 16:38:39 UTC
After step 4 in description:

AOO410m1(Build:9750)  -  Rev. 1543812
Win 7
Comment 5 Rainer Bielefeld 2014-03-09 08:13:27 UTC
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.