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 <mikes@kuentos.guam.net> wrote:

 Subject: Re: [libreoffice-users] sort order
 To: users@global.libreoffice.org, "leleu" <robert.leleu@ovh.fr>, "Gary Collins" 
<gcatlast@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 +0000 (UTC)
 From:       
        Gary Collins <gcatlast@yahoo.co.uk>
 Send reply to:      Gary Collins <gcatlast@yahoo.co.uk>
 To:                 <users@global.libreoffice.org>,
 leleu 
 <robert.leleu@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.leleu@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.barker@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 +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:
>   users+unsubscribe@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+unsubscribe@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+unsubscribe@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
 
 
 +----------------------------------------------------------+
   Michael D. Setzer II -  Computer Science
 Instructor      
   Guam Community
 College  Computer Center                  
   mailto:mikes@kuentos.guam.net 
                           
  
 mailto:msetzerii@gmail.com
   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: users+unsubscribe@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+unsubscribe@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