Sorting Problem - Validity - Combobox

Ozgur Emre · General User Joined: 18 Sep 2008 Posts: 8

Hi.
I'm from Turkey. We have letters as "ç" (c with dot); "ı" (i without dot); "ş" (s with dot) ..

When you select a column; follow Data->Sort (ascending) there's no problem; "ç" (c with dot) comes after c; "ş" (s with dot) comes after s...

But when you choose Data->Validity->Cell Range (Sort entries ascending checked) ;
in combobox , it sorts the array but "ç" (c with dot); "ı" (i without dot); "ş" (s with dot) letters go to bottom of list; seem after "z".

Is there a way to fix this?

Thank you.

Robert Tucker · Posted: Wed May 02, 2012 6:21 am Post subject:

Of course, if you enter the alphabet as a "List"...
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)

Villeroy · Posted: Wed May 02, 2012 7:49 am Post subject:

Ozgur Emre · General User Joined: 18 Sep 2008 Posts: 8

I added Turkish alphabet as a list but it doesn't work. it's still in wrong order.
But interesting; after the letter z ; it's correct; "ç" before "ö" before "ü".. (coincidence?)

http://imageupload.org/en/file/222917/sort-list.png.html
http://imageupload.org/en/file/222918/error.png.html

Villeroy · Posted: Thu May 03, 2012 4:34 am Post subject:

I am not sure about this and I don't have any time to test it right now:
Select your list range.
Data>Define... give a name (only letters, no spaces), button [Add], [OK]
Choose your sort list in Data>Sort... Tab #2 (Options).
All sort options will be stored in the defined database range.
You may also try to set the font locale of the "Default" cell style to Turkish. This indicates that all text values are in Turkish language.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

Robert Tucker · Posted: Thu May 03, 2012 6:52 am Post subject:

Data->Validity->List

_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)