OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Sorting Problem - Validity - Combobox

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Ozgur Emre
General User
General User


Joined: 18 Sep 2008
Posts: 8

PostPosted: Wed May 02, 2012 3:21 am    Post subject: Sorting Problem - Validity - Combobox Reply with quote

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.
Back to top
View user's profile Send private message MSN Messenger
Robert Tucker
Moderator
Moderator


Joined: 16 Aug 2004
Posts: 3407
Location: Manchester UK

PostPosted: Wed May 02, 2012 6:21 am    Post subject: Reply with quote

Of course, if you enter the alphabet as a "List"...
_________________
OpenOffice 4.0.0 and LibreOffice 4.x.x on Fedora 20, Ubuntu 13.10, Windows 8.1 Preview (Triple Boot)
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed May 02, 2012 7:49 am    Post subject: Reply with quote

Robert Tucker wrote:
Of course, if you enter the alphabet as a "List"...

... into Tools>Options>Calc>Sort Lists
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Ozgur Emre
General User
General User


Joined: 18 Sep 2008
Posts: 8

PostPosted: Thu May 03, 2012 4:29 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message MSN Messenger
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu May 03, 2012 4:34 am    Post subject: Reply with quote

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 https://forum.openoffice.org
Back to top
View user's profile Send private message
Robert Tucker
Moderator
Moderator


Joined: 16 Aug 2004
Posts: 3407
Location: Manchester UK

PostPosted: Thu May 03, 2012 6:52 am    Post subject: Reply with quote

Data->Validity->List




_________________
OpenOffice 4.0.0 and LibreOffice 4.x.x on Fedora 20, Ubuntu 13.10, Windows 8.1 Preview (Triple Boot)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group