Hi :) I just tend to add an extra 2 spaces in front of single-digit numbers. If/when that doesn't work i use a leading 0.
Like so ... TheSameStreetName 7/3 TheSameStreetName 12/1 TheSameStreetName 15/1 TheSameStreetName 19A m21 TheSameStreetName 25A/2 or TheSameStreetName 07/3 TheSameStreetName 12/1 TheSameStreetName 15/1 TheSameStreetName 19A m21 TheSameStreetName 25A/2 The leading zero looks dumb but it solves the problem. Regards from Tom :) >________________________________ > From: Brian Barker <[email protected]> >To: [email protected] >Sent: Thursday, 20 December 2012, 21:52 >Subject: Re: [libreoffice-users] [Calc] Data sorting > >At 21:57 20/12/2012 +0100, Gordom Noname wrote: >>Let say I have a list of my customers. Each raw consist of his/her >>name and the postal address (separate columns). The address is a >>mixture of letters and numbers. Now I would like to sort this list >>according to customers [location]. >> >>As the result I get something like this (1): >> >>TheSameStreetName 12/1 >>TheSameStreetName 15/1 >>TheSameStreetName 19A m21 >>TheSameStreetName 25A/2 >>TheSameStreetName 7/3 > >Do I make something wrong? Why the list is sorted in that way (odd to me :-)? > >The cell contents are text, so they are sorted alphabetically, >character by character. 1 comes before 2, which comes before 7, so >the three numbers starting with "1" come first. These are then >sorted by the next character: 2 comes before 5, which comes before 9. > >>But I would rather expect to get this kind of list (2): >> >>TheSameStreetName 7/3 >>TheSameStreetName 12/1 >>TheSameStreetName 15/1 >>TheSameStreetName 19A m21 >>TheSameStreetName 25A/2 >> >>Is it possible to get the result according to list number 2? > >Probably. But you have to sort numerically, so you will either have >to separate the numbers from the street names (into separate cells: >you can then sort by those cells after sorting by street name) or >else keep the cells as they are but extract the number part into a >separate cell (which you can hide if you prefer) and then sort by those cells. > >I trust this helps. > >Brian Barker > > > >-- >For unsubscribe instructions e-mail to: [email protected] >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 > > > > -- For unsubscribe instructions e-mail to: [email protected] 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
