Bug 41040 - Calc - in autofilter, words with accents displayed in wrong order
Summary: Calc - in autofilter, words with accents displayed in wrong order
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.3 RC1
Hardware: x86 (IA32) Linux (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-20 07:17 UTC by PeterG
Modified: 2017-05-28 15:03 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
a spreadsheet with words, some starting with an accent (8.74 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-09-20 07:17 UTC, PeterG
Details

Note You need to log in before you can comment on or make changes to this bug.
Description PeterG 2011-09-20 07:17:14 UTC
Created attachment 51404 [details]
a spreadsheet with words, some starting with an accent

In Calc, using autofilter, words in a column starting with an accent are displayed in wrong order.
Calc either places these words to the start or to the end, but not in order.
Comment 1 Dotan Cohen 2011-09-20 09:32:00 UTC
Which LibreOffice locale is set? This looks like a collation issue.
Check here:
Tools → Options... → LanguageSettings → Languages → Locale Setting
Comment 2 PeterG 2011-09-21 01:24:49 UTC
(In reply to comment #1)
> Which LibreOffice locale is set? This looks like a collation issue.
> Check here:
> Tools → Options... → LanguageSettings → Languages → Locale Setting


I tried it on 2 machines and 3 instances. The error exists in each setting:


1. LibreOffice 3.3.4  "default - Hungarian"   (on Ubuntu Linux)

2. OpenOffice 3.2.0  "default - English (USA)"  (on Ubuntu Linux)

3. LibreOffice 3.4.3 "default - Hungarian" or "default - English (USA)"  (on Windows XP)
Comment 3 Björn Michaelsen 2011-12-23 12:36:07 UTC Comment hidden (obsolete)
Comment 4 Florian Reisinger 2012-08-14 14:02:51 UTC Comment hidden (obsolete)
Comment 5 Florian Reisinger 2012-08-14 14:03:47 UTC Comment hidden (obsolete)
Comment 6 Florian Reisinger 2012-08-14 14:08:21 UTC Comment hidden (obsolete)
Comment 7 Florian Reisinger 2012-08-14 14:10:25 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2017-05-28 15:03:46 UTC
There was some talk on IRC about this type of issue, but the sorting works for me either with Finnish or Eng (USA) locale.

There is also this old report of the same: https://bz.apache.org/ooo/show_bug.cgi?id=88748

Arch Linux 64-bit, KDE Plasma 5
Version: 5.3.3.2
Build ID: 5.3.3-1
CPU Threads: 8; OS Version: Linux 4.10; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group