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
Status: UNCONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
Calc file for reproducing the scenario (8.97 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-09-21 08:35 UTC, cordyph 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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:
Anders
Ohnsorg
Ullmeier
Zypries
Aller
Ohremann
Umit

AOO410m1(Build:9750)  -  Rev. 1543812
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.