sort order

classic Classic list List threaded Threaded
11 messages Options
Gary Collins Gary Collins
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

sort order

Hello
Id like to know if there is a character, preferably some sort of discreet punctuation mark, that will come *after* z in the sort order when using natural sort. My problem is that i have some codes beginning Aa which really speaking should come after Z. As a number of up to 3 digits follows the letter(s) in each case, im getting A# followed by Aa# then B# which really wont do. I have to use natural sort as i need eg A12 to come after A3. Ive tried a few punctuation characters and some special characters but i cant find one that works. Any light that can be shed on this would be very   welcome indeed. I really dont want to have to precede Aa with a z if that can possibly be avoided.
Thanks
Gary

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
robert leleu robert leleu
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sort order

Just google for "characters sorting order"...you'll have to choose by
yourself...


Je la 11/03/2017 18:58, Gary Collins skribis :
> Hello
> Id like to know if there is a character, preferably some sort of discreet punctuation mark, that will come *after* z in the sort order when using natural sort. My problem is that i have some codes beginning Aa which really speaking should come after Z. As a number of up to 3 digits follows the letter(s) in each case, im getting A# followed by Aa# then B# which really wont do. I have to use natural sort as i need eg A12 to come after A3. Ive tried a few punctuation characters and some special characters but i cant find one that works. Any light that can be shed on this would be very   welcome indeed. I really dont want to have to precede Aa with a z if that can possibly be avoided.
> Thanks
> Gary
>

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Brian Barker Brian Barker
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sort order

In reply to this post by Gary Collins
At 17:58 11/03/2017 +0000, Gary Collins wrote:

>I'd like to know if there is a character, preferably some sort of
>discrete punctuation mark, that will come *after* z in the sort
>order when using natural sort. My problem is that i have some codes
>beginning Aa which really speaking should come after Z. As a number
>of up to 3 digits follows the letter(s) in each case, im getting A#
>followed by Aa# then B# which really wont do. I have to use natural
>sort as i need eg A12 to come after A3. Ive tried a few punctuation
>characters and some special characters but i cant find one that
>works. Any light that can be shed on this would be very welcome
>indeed. I really dont want to have to precede Aa with a z if that
>can possibly be avoided.

These are not punctuation marks, but a bit of experimentation
suggests that any Greek character, upper or lower case, will serve.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Gary Collins Gary Collins
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sort order

In reply to this post by Gary Collins
Thank you, yes it does. I got it to work with Greek iota which is about the least obtrusive. Strangely (to my mind) some less obtrusive characters with higher unicode *dont* work. Its a bit of a mystery whats going on, i can only surmise that there is somewhere a table of 'blacklisted' characters which are not taken into account for sorting purposes. This new (ish) sort order lark has been a right pain in the proverbials for me, generally speaking. I'll now just scour the table in the hope of finding something even better but at least there is *something* that'll work

Thanks,
G.
--------------------------------------------
On Sun, 12/3/17, Brian Barker <[hidden email]> wrote:

 Subject: Re: [libreoffice-users] sort order
 To: [hidden email]
 Date: Sunday, 12 March, 2017, 5:51
 
 At 17:58 11/03/2017 +0000, Gary
 Collins wrote:
 >I'd like to know if there is a character, preferably
 some sort of
 >discrete punctuation mark, that will come *after* z in
 the sort
 >order when using natural sort. My problem is that i have
 some codes
 >beginning Aa which really speaking should come after Z.
 As a number
 >of up to 3 digits follows the letter(s) in each case, im
 getting A#
 >followed by Aa# then B# which really wont do. I have to
 use natural
 >sort as i need eg A12 to come after A3. Ive tried a few
 punctuation
 >characters and some special characters but i cant find
 one that
 >works. Any light that can be shed on this would be very
 welcome
 >indeed. I really dont want to have to precede Aa with a
 z if that
 >can possibly be avoided.
 
 These are not punctuation marks, but a bit of
 experimentation
 suggests that any Greek character, upper or lower case, will
 serve.
 
 I trust this helps.
 
 Brian Barker
 
 
 --
 To unsubscribe e-mail to: [hidden email]
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and
 cannot be deleted
 
 

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
robert leleu robert leleu
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sort order

see
https://en.wikipedia.org/wiki/Unicode_collation_algorithm
now the problem is "where is the "collation algorithm" of calc ? An
algorithm which obviously has to change according to the language.....

Je la 12/03/2017 18:50, Gary Collins skribis :

> Thank you, yes it does. I got it to work with Greek iota which is about the least obtrusive. Strangely (to my mind) some less obtrusive characters with higher unicode *dont* work. Its a bit of a mystery whats going on, i can only surmise that there is somewhere a table of 'blacklisted' characters which are not taken into account for sorting purposes. This new (ish) sort order lark has been a right pain in the proverbials for me, generally speaking. I'll now just scour the table in the hope of finding something even better but at least there is *something* that'll work
>
> Thanks,
> G.
> --------------------------------------------
> On Sun, 12/3/17, Brian Barker <[hidden email]> wrote:
>
>   Subject: Re: [libreoffice-users] sort order
>   To: [hidden email]
>   Date: Sunday, 12 March, 2017, 5:51
>  
>   At 17:58 11/03/2017 +0000, Gary
>   Collins wrote:
>   >I'd like to know if there is a character, preferably
>   some sort of
>   >discrete punctuation mark, that will come *after* z in
>   the sort
>   >order when using natural sort. My problem is that i have
>   some codes
>   >beginning Aa which really speaking should come after Z.
>   As a number
>   >of up to 3 digits follows the letter(s) in each case, im
>   getting A#
>   >followed by Aa# then B# which really wont do. I have to
>   use natural
>   >sort as i need eg A12 to come after A3. Ive tried a few
>   punctuation
>   >characters and some special characters but i cant find
>   one that
>   >works. Any light that can be shed on this would be very
>   welcome
>   >indeed. I really dont want to have to precede Aa with a
>   z if that
>   >can possibly be avoided.
>  
>   These are not punctuation marks, but a bit of
>   experimentation
>   suggests that any Greek character, upper or lower case, will
>   serve.
>  
>   I trust this helps.
>  
>   Brian Barker
>  
>  
>   --
>   To unsubscribe e-mail to: [hidden email]
>   Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>   Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>   List archive: http://listarchives.libreoffice.org/global/users/
>   All messages sent to this list will be publicly archived and
>   cannot be deleted
>  
>  
>

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Gary Collins Gary Collins
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sort order

In reply to this post by Gary Collins
Got it! I can replace the ''A" in my "Aa" with Greek alpha (or with Russian 'A') and it works perfectly, with the minor exception that the non English characters look as if they have come from a different font. But I can live with that, I think it's the best solution possible.

Thanks
Gary
--------------------------------------------
On Sun, 12/3/17, Brian Barker <[hidden email]> wrote:

 Subject: Re: [libreoffice-users] sort order
 To: [hidden email]
 Date: Sunday, 12 March, 2017, 5:51
 
 At 17:58 11/03/2017 +0000, Gary
 Collins wrote:
 >I'd like to know if there is a character, preferably
 some sort of
 >discrete punctuation mark, that will come *after* z in
 the sort
 >order when using natural sort. My problem is that i have
 some codes
 >beginning Aa which really speaking should come after Z.
 As a number
 >of up to 3 digits follows the letter(s) in each case, im
 getting A#
 >followed by Aa# then B# which really wont do. I have to
 use natural
 >sort as i need eg A12 to come after A3. Ive tried a few
 punctuation
 >characters and some special characters but i cant find
 one that
 >works. Any light that can be shed on this would be very
 welcome
 >indeed. I really dont want to have to precede Aa with a
 z if that
 >can possibly be avoided.
 
 These are not punctuation marks, but a bit of
 experimentation
 suggests that any Greek character, upper or lower case, will
 serve.
 
 I trust this helps.
 
 Brian Barker
 
 
 --
 To unsubscribe e-mail to: [hidden email]
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and
 cannot be deleted
 
 

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
robert leleu robert leleu
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sort order

In reply to this post by robert leleu
for instance, see
http://collation-charts.org/mysql60/mysql604.utf8_unicode_ci.european.html
Je la 12/03/2017 19:07, leleu skribis :

> see
> https://en.wikipedia.org/wiki/Unicode_collation_algorithm
> now the problem is "where is the "collation algorithm" of calc ? An
> algorithm which obviously has to change according to the language.....
>
> Je la 12/03/2017 18:50, Gary Collins skribis :
>> Thank you, yes it does. I got it to work with Greek iota which is
>> about the least obtrusive. Strangely (to my mind) some less obtrusive
>> characters with higher unicode *dont* work. Its a bit of a mystery
>> whats going on, i can only surmise that there is somewhere a table of
>> 'blacklisted' characters which are not taken into account for sorting
>> purposes. This new (ish) sort order lark has been a right pain in the
>> proverbials for me, generally speaking. I'll now just scour the table
>> in the hope of finding something even better but at least there is
>> *something* that'll work
>>
>> Thanks,
>> G.
>> --------------------------------------------
>> On Sun, 12/3/17, Brian Barker <[hidden email]> wrote:
>>
>>   Subject: Re: [libreoffice-users] sort order
>>   To: [hidden email]
>>   Date: Sunday, 12 March, 2017, 5:51
>>     At 17:58 11/03/2017 +0000, Gary
>>   Collins wrote:
>>   >I'd like to know if there is a character, preferably
>>   some sort of
>>   >discrete punctuation mark, that will come *after* z in
>>   the sort
>>   >order when using natural sort. My problem is that i have
>>   some codes
>>   >beginning Aa which really speaking should come after Z.
>>   As a number
>>   >of up to 3 digits follows the letter(s) in each case, im
>>   getting A#
>>   >followed by Aa# then B# which really wont do. I have to
>>   use natural
>>   >sort as i need eg A12 to come after A3. Ive tried a few
>>   punctuation
>>   >characters and some special characters but i cant find
>>   one that
>>   >works. Any light that can be shed on this would be very
>>   welcome
>>   >indeed. I really dont want to have to precede Aa with a
>>   z if that
>>   >can possibly be avoided.
>>     These are not punctuation marks, but a bit of
>>   experimentation
>>   suggests that any Greek character, upper or lower case, will
>>   serve.
>>     I trust this helps.
>>     Brian Barker
>>       --
>>   To unsubscribe e-mail to: [hidden email]
>>   Problems?
>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>   Posting guidelines + more:
>> http://wiki.documentfoundation.org/Netiquette
>>   List archive: http://listarchives.libreoffice.org/global/users/
>>   All messages sent to this list will be publicly archived and
>>   cannot be deleted
>>
>

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Gary Collins Gary Collins
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sort order

In reply to this post by Gary Collins
Wow, yes, that sounds the sort of thing. It would need to be customisable, I'm not sure that the sequence used for the transliteration of hieroglyphs would necesarily be catered for.... ūüėä
Gary
--------------------------------------------
On Sun, 12/3/17, leleu <[hidden email]> wrote:

 Subject: Re: [libreoffice-users] sort order
 To: [hidden email]
 Date: Sunday, 12 March, 2017, 18:07
 
 see
 https://en.wikipedia.org/wiki/Unicode_collation_algorithm
 now the problem is "where is the
 "collation algorithm" of calc ? An
 algorithm which obviously has to change
 according to the language.....
 
 Je la 12/03/2017 18:50, Gary Collins skribis
 :
 > Thank you, yes it does. I got it to
 work with Greek iota which is about the least obtrusive.
 Strangely (to my mind) some less obtrusive characters with
 higher unicode *dont* work. Its a bit of a mystery whats
 going on, i can only surmise that there is somewhere a table
 of 'blacklisted' characters which are not taken into
 account for sorting purposes. This new (ish) sort order lark
 has been a right pain in the proverbials for me, generally
 speaking. I'll now just scour the table in the hope of
 finding something even better but at least there is
 *something* that'll work
 >
 > Thanks,
 > G.
 >
 --------------------------------------------
 > On Sun, 12/3/17, Brian Barker <[hidden email]>
 wrote:
 >
 >¬†¬†¬†Subject: Re:
 [libreoffice-users] sort order
 >¬†¬†¬†To: [hidden email]
 >¬†¬†¬†Date: Sunday, 12 March, 2017,
 5:51
 >¬†¬†¬†
 >¬†¬†¬†At 17:58 11/03/2017 +0000,
 Gary
 >¬†¬†¬†Collins wrote:
 >¬†¬†¬†>I'd like to know if
 there is a character, preferably
 >¬†¬†¬†some sort of
 >¬†¬†¬†>discrete punctuation
 mark, that will come *after* z in
 >¬†¬†¬†the sort
 >¬†¬†¬†>order when using natural
 sort. My problem is that i have
 >¬†¬†¬†some codes
 >¬†¬†¬†>beginning Aa which really
 speaking should come after Z.
 >¬†¬†¬†As a number
 >¬†¬†¬†>of up to 3 digits follows
 the letter(s) in each case, im
 >¬†¬†¬†getting A#
 >¬†¬†¬†>followed by Aa# then B#
 which really wont do. I have to
 >¬†¬†¬†use natural
 >¬†¬†¬†>sort as i need eg A12 to
 come after A3. Ive tried a few
 >¬†¬†¬†punctuation
 >¬†¬†¬†>characters and some
 special characters but i cant find
 >¬†¬†¬†one that
 >¬†¬†¬†>works. Any light that can
 be shed on this would be very
 >¬†¬†¬†welcome
 >¬†¬†¬†>indeed. I really dont
 want to have to precede Aa with a
 >¬†¬†¬†z if that
 >¬†¬†¬†>can possibly be
 avoided.
 >¬†¬†¬†
 >¬†¬†¬†These are not punctuation
 marks, but a bit of
 >¬†¬†¬†experimentation
 >¬†¬†¬†suggests that any Greek
 character, upper or lower case, will
 >¬†¬†¬†serve.
 >¬†¬†¬†
 >¬†¬†¬†I trust this helps.
 >¬†¬†¬†
 >¬†¬†¬†Brian Barker
 >¬†¬†¬†
 >¬†¬†¬†
 >¬†¬†¬†--
 >¬†¬†¬†To unsubscribe e-mail to:
 [hidden email]
 >¬†¬†¬†Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 >¬†¬†¬†Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 >¬†¬†¬†List archive: http://listarchives.libreoffice.org/global/users/
 >¬†¬†¬†All messages sent to this
 list will be publicly archived and
 >¬†¬†¬†cannot be deleted
 >¬†¬†¬†
 >¬†¬†¬†
 >
 
 --
 To
 unsubscribe e-mail to: [hidden email]
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly
 archived and cannot be deleted
 

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
msetzerii msetzerii
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sort order

ftp://fedora9gcc.dyndns.org/gary.zip

Has 3 little spreadsheets.
   8969  03-12-2017 03:27   FINDCODE.ods
    14959  03-12-2017 05:04   casematch.ods
    12025  03-13-2017 03:38   sortissue.ods

That address some solutions I came up with playing with how I understood
the issues, which might be wrong, but these seem to work as I see it.

Tried pasting the cells, and they look fine in the email I sent, but were totally
screwed up by the list? Then tried taken a screen shot, but those emails
never seemed to show up, and no message that they were rejected?

Put this file on one of my college ftp servers, so if someone takes a look and
sees if it works or not, otherwise. I'll just stop messing with it.



On 12 Mar 2017 at 18:20, Gary Collins wrote:

Date sent:       Sun, 12 Mar 2017 18:20:29 +0000 (UTC)
From:           Gary Collins <[hidden email]>
Send reply to:   Gary Collins <[hidden email]>
To:             <[hidden email]>, leleu
<[hidden email]>
Subject:         Re: [libreoffice-users] sort order

> Wow, yes, that sounds the sort of thing. It would need to be customisable, I'm not sure that the sequence used for the transliteration of hieroglyphs would necesarily be catered for....
> Gary
> --------------------------------------------
> On Sun, 12/3/17, leleu <[hidden email]> wrote:
>
>  Subject: Re: [libreoffice-users] sort order
>  To: [hidden email]
>  Date: Sunday, 12 March, 2017, 18:07
>  
>  see
>  https://en.wikipedia.org/wiki/Unicode_collation_algorithm
>  now the problem is "where is the
>  "collation algorithm" of calc ? An
>  algorithm which obviously has to change
>  according to the language.....
>  
>  Je la 12/03/2017 18:50, Gary Collins skribis
>  :
>  > Thank you, yes it does. I got it to
>  work with Greek iota which is about the least obtrusive.
>  Strangely (to my mind) some less obtrusive characters with
>  higher unicode *dont* work. Its a bit of a mystery whats
>  going on, i can only surmise that there is somewhere a table
>  of 'blacklisted' characters which are not taken into
>  account for sorting purposes. This new (ish) sort order lark
>  has been a right pain in the proverbials for me, generally
>  speaking. I'll now just scour the table in the hope of
>  finding something even better but at least there is
>  *something* that'll work
>  >
>  > Thanks,
>  > G.
>  >
>  --------------------------------------------
>  > On Sun, 12/3/17, Brian Barker <[hidden email]>
>  wrote:
>  >
>  >¬†¬†¬†Subject: Re:
>  [libreoffice-users] sort order
>  >¬†¬†¬†To: [hidden email]
>  >¬†¬†¬†Date: Sunday, 12 March, 2017,
>  5:51
>  >¬†¬†¬†
>  >¬†¬†¬†At 17:58 11/03/2017 +0000,
>  Gary
>  >¬†¬†¬†Collins wrote:
>  >¬†¬†¬†>I'd like to know if
>  there is a character, preferably
>  >¬†¬†¬†some sort of
>  >¬†¬†¬†>discrete punctuation
>  mark, that will come *after* z in
>  >¬†¬†¬†the sort
>  >¬†¬†¬†>order when using natural
>  sort. My problem is that i have
>  >¬†¬†¬†some codes
>  >¬†¬†¬†>beginning Aa which really
>  speaking should come after Z.
>  >¬†¬†¬†As a number
>  >¬†¬†¬†>of up to 3 digits follows
>  the letter(s) in each case, im
>  >¬†¬†¬†getting A#
>  >¬†¬†¬†>followed by Aa# then B#
>  which really wont do. I have to
>  >¬†¬†¬†use natural
>  >¬†¬†¬†>sort as i need eg A12 to
>  come after A3. Ive tried a few
>  >¬†¬†¬†punctuation
>  >¬†¬†¬†>characters and some
>  special characters but i cant find
>  >¬†¬†¬†one that
>  >¬†¬†¬†>works. Any light that can
>  be shed on this would be very
>  >¬†¬†¬†welcome
>  >¬†¬†¬†>indeed. I really dont
>  want to have to precede Aa with a
>  >¬†¬†¬†z if that
>  >¬†¬†¬†>can possibly be
>  avoided.
>  >¬†¬†¬†
>  >¬†¬†¬†These are not punctuation
>  marks, but a bit of
>  >¬†¬†¬†experimentation
>  >¬†¬†¬†suggests that any Greek
>  character, upper or lower case, will
>  >¬†¬†¬†serve.
>  >¬†¬†¬†
>  >¬†¬†¬†I trust this helps.
>  >¬†¬†¬†
>  >¬†¬†¬†Brian Barker
>  >¬†¬†¬†
>  >¬†¬†¬†
>  >¬†¬†¬†--
>  >¬†¬†¬†To unsubscribe e-mail to:
>  [hidden email]
>  >¬†¬†¬†Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>  >¬†¬†¬†Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>  >¬†¬†¬†List archive: http://listarchives.libreoffice.org/global/users/
>  >¬†¬†¬†All messages sent to this
>  list will be publicly archived and
>  >¬†¬†¬†cannot be deleted
>  >¬†¬†¬†
>  >¬†¬†¬†
>  >
>  
>  --
>  To
>  unsubscribe e-mail to: [hidden email]
>  Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>  Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>  List archive: http://listarchives.libreoffice.org/global/users/
>  All messages sent to this list will be publicly
>  archived and cannot be deleted
>  
>
> --
> To unsubscribe e-mail to: [hidden email]
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted


+----------------------------------------------------------+
  Michael D. Setzer II -  Computer Science Instructor      
  Guam Community College  Computer Center                  
  mailto:[hidden email]                            
  mailto:[hidden email]
  Guam - Where America's Day Begins                        
  G4L Disk Imaging Project maintainer
  http://sourceforge.net/projects/g4l/
+----------------------------------------------------------+

http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

BOINC@HOME CREDITS
ABC         16613838.513356 | EINSTEIN   130635614.788695
ROSETTA     58512663.303027 | SETI       101945876.738920


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Gary Collins Gary Collins
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sort order

In reply to this post by Gary Collins
Wow, yes, that sounds the sort of thing. It would need to be customisable, I'm not sure that the sequence used for the transliteration of hieroglyphs would necesarily be catered for.... ūüėä
Gary
--------------------------------------------
On Sun, 12/3/17, leleu <[hidden email]> wrote:

 Subject: Re: [libreoffice-users] sort order
 To: [hidden email]
 Date: Sunday, 12 March, 2017, 18:07
 
 see
 https://en.wikipedia.org/wiki/Unicode_collation_algorithm
 now the problem is "where is the
 "collation algorithm" of calc ? An
 algorithm which obviously has to change
 according to the language.....
 
 Je la 12/03/2017 18:50, Gary Collins skribis
 :
 > Thank you, yes it does. I got it to
 work with Greek iota which is about the least obtrusive.
 Strangely (to my mind) some less obtrusive characters with
 higher unicode *dont* work. Its a bit of a mystery whats
 going on, i can only surmise that there is somewhere a table
 of 'blacklisted' characters which are not taken into
 account for sorting purposes. This new (ish) sort order lark
 has been a right pain in the proverbials for me, generally
 speaking. I'll now just scour the table in the hope of
 finding something even better but at least there is
 *something* that'll work
 >
 > Thanks,
 > G.
 >
 --------------------------------------------
 > On Sun, 12/3/17, Brian Barker <[hidden email]>
 wrote:
 >
 >¬†¬†¬†Subject: Re:
 [libreoffice-users] sort order
 >¬†¬†¬†To: [hidden email]
 >¬†¬†¬†Date: Sunday, 12 March, 2017,
 5:51
 >¬†¬†¬†
 >¬†¬†¬†At 17:58 11/03/2017 +0000,
 Gary
 >¬†¬†¬†Collins wrote:
 >¬†¬†¬†>I'd like to know if
 there is a character, preferably
 >¬†¬†¬†some sort of
 >¬†¬†¬†>discrete punctuation
 mark, that will come *after* z in
 >¬†¬†¬†the sort
 >¬†¬†¬†>order when using natural
 sort. My problem is that i have
 >¬†¬†¬†some codes
 >¬†¬†¬†>beginning Aa which really
 speaking should come after Z.
 >¬†¬†¬†As a number
 >¬†¬†¬†>of up to 3 digits follows
 the letter(s) in each case, im
 >¬†¬†¬†getting A#
 >¬†¬†¬†>followed by Aa# then B#
 which really wont do. I have to
 >¬†¬†¬†use natural
 >¬†¬†¬†>sort as i need eg A12 to
 come after A3. Ive tried a few
 >¬†¬†¬†punctuation
 >¬†¬†¬†>characters and some
 special characters but i cant find
 >¬†¬†¬†one that
 >¬†¬†¬†>works. Any light that can
 be shed on this would be very
 >¬†¬†¬†welcome
 >¬†¬†¬†>indeed. I really dont
 want to have to precede Aa with a
 >¬†¬†¬†z if that
 >¬†¬†¬†>can possibly be
 avoided.
 >¬†¬†¬†
 >¬†¬†¬†These are not punctuation
 marks, but a bit of
 >¬†¬†¬†experimentation
 >¬†¬†¬†suggests that any Greek
 character, upper or lower case, will
 >¬†¬†¬†serve.
 >¬†¬†¬†
 >¬†¬†¬†I trust this helps.
 >¬†¬†¬†
 >¬†¬†¬†Brian Barker
 >¬†¬†¬†
 >¬†¬†¬†
 >¬†¬†¬†--
 >¬†¬†¬†To unsubscribe e-mail to:
 [hidden email]
 >¬†¬†¬†Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 >¬†¬†¬†Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 >¬†¬†¬†List archive: http://listarchives.libreoffice.org/global/users/
 >¬†¬†¬†All messages sent to this
 list will be publicly archived and
 >¬†¬†¬†cannot be deleted
 >¬†¬†¬†
 >¬†¬†¬†
 >
 
 --
 To
 unsubscribe e-mail to: [hidden email]
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly
 archived and cannot be deleted
 

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Gary Collins Gary Collins
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sort order

In reply to this post by Gary Collins
Got them! Thank you so much for these, will take me a bit of time to absorb but i'm sure they'll be useful.

/Gary

--------------------------------------------
On Mon, 13/3/17, Michael D. Setzer II <[hidden email]> wrote:

 Subject: Re: [libreoffice-users] sort order
 To: [hidden email], "leleu" <[hidden email]>, "Gary Collins" <[hidden email]>
 Date: Monday, 13 March, 2017, 5:00
 
 ftp://fedora9gcc.dyndns.org/gary.zip
 
 Has 3 little spreadsheets.
 ¬†¬†¬†8969¬† 03-12-2017
 03:27¬†¬†¬†FINDCODE.ods
 ¬† ¬†
 14959¬† 03-12-2017 05:04¬†¬†¬†casematch.ods
 ¬† ¬† 12025¬† 03-13-2017
 03:38¬†¬†¬†sortissue.ods
 
 That address some solutions I came up with
 playing with how I understood
 the issues,
 which might be wrong, but these seem to work as I see it.
 
 Tried pasting the cells, and
 they look fine in the email I sent, but were totally
 screwed up by the list? Then tried taken a
 screen shot, but those emails
 never seemed
 to show up, and no message that they were rejected?
 
 Put this file on one of my
 college ftp servers, so if someone takes a look and
 sees if it works or not, otherwise. I'll
 just stop messing with it.
 
 
 
 On 12 Mar
 2017 at 18:20, Gary Collins wrote:
 
 Date sent:¬† ¬† ¬† ¬†¬†¬† Sun, 12 Mar 2017
 18:20:29 +0000 (UTC)
 From:¬† ¬† ¬† ¬†
 ¬†¬†¬†¬†¬†¬† Gary Collins <[hidden email]>
 Send reply to:¬† ¬†¬†¬† Gary Collins <[hidden email]>
 To:¬† ¬† ¬† ¬† ¬† ¬†¬†¬†¬†¬†¬† <[hidden email]>,
 leleu
 <[hidden email]>
 Subject:¬† ¬† ¬† ¬† ¬†¬†¬† Re:
 [libreoffice-users] sort order
 
 > Wow, yes, that sounds the sort of thing.
 It would need to be customisable, I'm not sure that the
 sequence used for the transliteration of hieroglyphs would
 necesarily be catered for....
 > Gary
 >
 --------------------------------------------
 > On Sun, 12/3/17, leleu <[hidden email]>
 wrote:
 >
 >¬† Subject:
 Re: [libreoffice-users] sort order
 >¬†
 To: [hidden email]
 >¬† Date: Sunday, 12 March, 2017, 18:07
 >¬†
 >¬† see
 >¬† https://en.wikipedia.org/wiki/Unicode_collation_algorithm
 >¬† now the problem is "where is the
 >¬† "collation algorithm" of calc
 ? An
 >¬† algorithm which obviously has
 to change
 >¬† according to the
 language.....
 >¬†
 >¬†
 Je la 12/03/2017 18:50, Gary Collins skribis
 >¬† :
 >¬† > Thank you,
 yes it does. I got it to
 >¬† work with
 Greek iota which is about the least obtrusive.
 >¬† Strangely (to my mind) some less
 obtrusive characters with
 >¬† higher
 unicode *dont* work. Its a bit of a mystery whats
 >¬† going on, i can only surmise that there
 is somewhere a table
 >¬† of
 'blacklisted' characters which are not taken into
 >¬† account for sorting purposes. This new
 (ish) sort order lark
 >¬† has been a
 right pain in the proverbials for me, generally
 >¬† speaking. I'll now just scour the
 table in the hope of
 >¬† finding
 something even better but at least there is
 >¬† *something* that'll work
 >¬† >
 >¬† >
 Thanks,
 >¬† > G.
 >¬† >
 >¬†
 --------------------------------------------
 >¬† > On Sun, 12/3/17, Brian Barker
 <[hidden email]>
 >¬† wrote:
 >¬† >
 >¬† >¬†¬†¬†Subject: Re:
 >¬† [libreoffice-users] sort order
 >¬† >¬†¬†¬†To: [hidden email]
 >¬† >¬†¬†¬†Date: Sunday, 12 March,
 2017,
 >¬† 5:51
 >¬†
 >¬†¬†¬†
 >¬† >¬†¬†¬†At 17:58
 11/03/2017 +0000,
 >¬† Gary
 >¬† >¬†¬†¬†Collins wrote:
 >¬† >¬†¬†¬†>I'd like to know if
 >¬† there is a character, preferably
 >¬† >¬†¬†¬†some sort of
 >¬† >¬†¬†¬†>discrete punctuation
 >¬† mark, that will come *after* z in
 >¬† >¬†¬†¬†the sort
 >¬† >¬†¬†¬†>order when using
 natural
 >¬† sort. My problem is that i
 have
 >¬† >¬†¬†¬†some codes
 >¬† >¬†¬†¬†>beginning Aa which
 really
 >¬† speaking should come after
 Z.
 >¬† >¬†¬†¬†As a number
 >¬† >¬†¬†¬†>of up to 3 digits
 follows
 >¬† the letter(s) in each case,
 im
 >¬† >¬†¬†¬†getting A#
 >¬† >¬†¬†¬†>followed by Aa# then B#
 >¬† which really wont do. I have to
 >¬† >¬†¬†¬†use natural
 >¬† >¬†¬†¬†>sort as i need eg A12
 to
 >¬† come after A3. Ive tried a few
 >¬† >¬†¬†¬†punctuation
 >¬† >¬†¬†¬†>characters and some
 >¬† special characters but i cant find
 >¬† >¬†¬†¬†one that
 >¬† >¬†¬†¬†>works. Any light that
 can
 >¬† be shed on this would be very
 >¬† >¬†¬†¬†welcome
 >¬†
 >¬†¬†¬†>indeed. I really dont
 >¬†
 want to have to precede Aa with a
 >¬†
 >¬†¬†¬†z if that
 >¬† >¬†¬†¬†>can
 possibly be
 >¬† avoided.
 >¬† >¬†¬†¬†
 >¬†
 >¬†¬†¬†These are not punctuation
 >¬†
 marks, but a bit of
 >¬†
 >¬†¬†¬†experimentation
 >¬†
 >¬†¬†¬†suggests that any Greek
 >¬†
 character, upper or lower case, will
 >¬†
 >¬†¬†¬†serve.
 >¬† >¬†¬†¬†
 >¬† >¬†¬†¬†I trust this helps.
 >¬† >¬†¬†¬†
 >¬†
 >¬†¬†¬†Brian Barker
 >¬† >¬†¬†¬†
 >¬† >¬†¬†¬†
 >¬†
 >¬†¬†¬†--
 >¬† >¬†¬†¬†To unsubscribe
 e-mail to:
 >¬† [hidden email]
 >¬† >¬†¬†¬†Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 >¬† >¬†¬†¬†Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 >¬† >¬†¬†¬†List archive: http://listarchives.libreoffice.org/global/users/
 >¬† >¬†¬†¬†All messages sent to this
 >¬† list will be publicly archived and
 >¬† >¬†¬†¬†cannot be deleted
 >¬† >¬†¬†¬†
 >¬†
 >¬†¬†¬†
 >¬† >
 >¬†
 >¬† --
 >¬† To
 >¬† unsubscribe
 e-mail to: [hidden email]
 >¬† Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 >¬† Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 >¬† List archive: http://listarchives.libreoffice.org/global/users/
 >¬† All messages sent to this list will be
 publicly
 >¬† archived and cannot be
 deleted
 >¬†
 >
 > --
 > To unsubscribe
 e-mail to: [hidden email]
 > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 > List archive: http://listarchives.libreoffice.org/global/users/
 > All messages sent to this list will be
 publicly archived and cannot be deleted
 
 
 +----------------------------------------------------------+
 ¬† Michael D. Setzer II -¬† Computer Science
 Instructor¬† ¬† ¬†
 ¬† Guam Community
 College¬† Computer Center¬† ¬† ¬† ¬† ¬† ¬† ¬† ¬† ¬†
 ¬† mailto:[hidden email]¬†
 ¬† ¬† ¬† ¬† ¬† ¬† ¬† ¬† ¬† ¬† ¬† ¬† ¬†
 ¬†
 mailto:[hidden email]
 ¬† Guam - Where America's Day Begins¬† ¬†
 ¬† ¬† ¬† ¬† ¬† ¬† ¬† ¬† ¬† ¬†
 ¬† G4L Disk
 Imaging Project maintainer
 ¬† http://sourceforge.net/projects/g4l/
 +----------------------------------------------------------+
 
 http://setiathome.berkeley.edu
 (Original)
 Number of Seti Units
 Returned:¬† 19,471
 Processing time:¬† 32
 years, 290 days, 12 hours, 58 minutes
 (Total
 Hours: 287,489)
 
 BOINC@HOME
 CREDITS
 ABC¬† ¬† ¬†
 ¬†¬†¬†16613838.513356 |
 EINSTEIN¬†¬†¬†130635614.788695
 ROSETTA¬† ¬†¬†¬†58512663.303027 |
 SETI¬† ¬† ¬†¬†¬†101945876.738920
 
 
 --
 To
 unsubscribe e-mail to: [hidden email]
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly
 archived and cannot be deleted
 

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Loading...