Issue 88748 - wrong sort in autofilter with accent
Summary: wrong sort in autofilter with accent
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-04-26 11:13 UTC by oooforum (fr)
Modified: 2017-05-20 11:33 UTC (History)
4 users (show)

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

OOo and MS-Excel autofilter (22.47 KB, image/jpeg)
2008-04-26 11:14 UTC, oooforum (fr)
no flags Details
Autofilter sorting (26.21 KB, image/png)
2008-07-04 16:56 UTC, oooforum (fr)
no flags Details
The column on the left has been sorted correctly. The order in the menu is wrong (14.34 KB, text/plain)
2010-07-21 18:29 UTC, camillem
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description oooforum (fr) 2008-04-26 11:13:05 UTC

Input this list:

Apply an autofilter: items are sorted in wrong order. 

Take a look to the screenshot to see the difference between OOo and MS-Excel
Comment 1 oooforum (fr) 2008-04-26 11:14:07 UTC
Created attachment 53205 [details]
OOo and MS-Excel autofilter
Comment 2 oooforum (fr) 2008-07-04 16:54:16 UTC
This problem has changed with 3.0 beta but not fully fixed 

See the new screenshot below
Comment 3 oooforum (fr) 2008-07-04 16:56:24 UTC
Created attachment 54946 [details]
Autofilter sorting
Comment 4 amy2008 2008-08-20 08:51:11 UTC
Can reproduce it in DEV300_m28_EN on WinXP.
Comment 5 camillem 2010-05-26 10:37:31 UTC
The problem is still present in OOo 3.2.
The filter should use the same algo to sort the entries as the Sort function.
Please let me know if you need further info.
Could anyone switch the status to "New" ? Thanks
Comment 6 camillem 2010-07-21 18:27:49 UTC
One point : the bug is not about to following the Ecxel way. Calc's behaviour is
just faulty.
Comment 7 camillem 2010-07-21 18:29:58 UTC
Created attachment 70765 [details]
The column on the left has been sorted correctly. The order in the menu is wrong
Comment 8 Mechtilde 2010-09-03 09:34:26 UTC
The problem is that there is used a different sort algorithm between the normal
sort function and the sort function in the autofilter
Comment 9 oc 2011-03-03 07:42:04 UTC
@er: please have a look
Comment 10 Béla Körmöndi 2011-10-25 14:03:21 UTC
Hi All! Is there anything new about this bug? It's still present in the latest OpenOffice and LibreOffice versions and it's a very annoying bug. It makes Calc unusable for a professional user with grand tables...  Please help!
Comment 11 Marcus 2017-05-20 11:33:28 UTC
Reset assigne to the default "".