Re: [libreoffice-users] sort order
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 <mi...@kuentos.guam.net> wrote: Subject: Re: [libreoffice-users] sort order To: users@global.libreoffice.org, "leleu" <robert.le...@ovh.fr>, "Gary Collins" <gcatl...@yahoo.co.uk> 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 + (UTC) From: Gary Collins <gcatl...@yahoo.co.uk> Send reply to: Gary Collins <gcatl...@yahoo.co.uk> To: <users@global.libreoffice.org>, leleu <robert.le...@ovh.fr> 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 <robert.le...@ovh.fr> wrote: > > Subject: Re: [libreoffice-users] sort order > To: users@global.libreoffice.org > 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 <b.m.bar...@btinternet.com> > wrote: > > > > Subject: Re: > [libreoffice-users] sort order > > To: users@global.libreoffice.org > > Date: Sunday, 12 March, 2017, > 5:51 > > > > At 17:58 11/03/2017 +, > 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 > >
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 <robert.le...@ovh.fr> wrote: Subject: Re: [libreoffice-users] sort order To: users@global.libreoffice.org 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 <b.m.bar...@btinternet.com> wrote: > > Subject: Re: [libreoffice-users] sort order > To: users@global.libreoffice.org > Date: Sunday, 12 March, 2017, 5:51 > > At 17:58 11/03/2017 +, 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: users+unsubscr...@global.libreoffice.org > 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: users+unsubscr...@global.libreoffice.org 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] 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 + (UTC) From: Gary Collins <gcatl...@yahoo.co.uk> Send reply to: Gary Collins <gcatl...@yahoo.co.uk> To: <users@global.libreoffice.org>, leleu <robert.le...@ovh.fr> 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 <robert.le...@ovh.fr> wrote: > > Subject: Re: [libreoffice-users] sort order > To: users@global.libreoffice.org > 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 <b.m.bar...@btinternet.com> > wrote: > > > > Subject: Re: > [libreoffice-users] sort order > > To: users@global.libreoffice.org > > Date: Sunday, 12 March, 2017, > 5:51 > > > > At 17:58 11/03/2017 +, > 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: > users+unsubscr...@global.libreoffice.org > > 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: users+unsubscr...@global
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 <robert.le...@ovh.fr> wrote: Subject: Re: [libreoffice-users] sort order To: users@global.libreoffice.org 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 <b.m.bar...@btinternet.com> wrote: > > Subject: Re: [libreoffice-users] sort order > To: users@global.libreoffice.org > Date: Sunday, 12 March, 2017, 5:51 > > At 17:58 11/03/2017 +, 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: users+unsubscr...@global.libreoffice.org > 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: users+unsubscr...@global.libreoffice.org 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] sort order
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 <b.m.bar...@btinternet.com> wrote: Subject: Re: [libreoffice-users] sort order To: users@global.libreoffice.org Date: Sunday, 12 March, 2017, 5:51 At 17:58 11/03/2017 +, 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: users+unsubscr...@global.libreoffice.org 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] sort order
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 <b.m.bar...@btinternet.com> wrote: Subject: Re: [libreoffice-users] sort order To: users@global.libreoffice.org Date: Sunday, 12 March, 2017, 5:51 At 17:58 11/03/2017 +, 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: users+unsubscr...@global.libreoffice.org 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] 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 <b.m.bar...@btinternet.com> wrote: Subject: Re: [libreoffice-users] sort order To: users@global.libreoffice.org Date: Sunday, 12 March, 2017, 5:51 At 17:58 11/03/2017 +, 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: users+unsubscr...@global.libreoffice.org 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] sort order
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 <b.m.bar...@btinternet.com> wrote: Subject: Re: [libreoffice-users] sort order To: users@global.libreoffice.org Date: Sunday, 12 March, 2017, 5:51 At 17:58 11/03/2017 +, 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: users+unsubscr...@global.libreoffice.org 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] sort order
At 17:58 11/03/2017 +, 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] 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: users+unsubscr...@global.libreoffice.org 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
[libreoffice-users] 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: users+unsubscr...@global.libreoffice.org 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