Bug 41040

Summary: Calc - in autofilter, words with accents displayed in wrong order
Product: LibreOffice Reporter: PeterG <support>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INVALID    
Severity: major CC: ilmari.lauhakangas
Priority: medium    
Version: 3.4.3 RC1   
Hardware: x86 (IA32)   
OS: Linux (All)   
See Also: https://bz.apache.org/ooo/show_bug.cgi?id=88748
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: a spreadsheet with words, some starting with an accent

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