[libreoffice-users] Calc - sort in to columns

2014-02-19 Thread IGraham
Hi Calc I've been scratching my head, racking my brain and grinding my teeth - non of which worked How do I sort out from a mixed list of membership types the email addressers into separate columns without gaps or 'false' or '0' appearing I've attached a simple mock up to make sense of my

Re: [libreoffice-users] Calc - sort in to columns

2014-02-19 Thread Alan B
On Wed, Feb 19, 2014 at 7:04 PM, IGraham gra...@lovatt.co.uk wrote: How do I sort out from a mixed list of membership types the email addressers into separate columns without gaps or 'false' or '0' appearing http://nabble.documentfoundation.org/file/n4098035/test2.ods I'm guessing from your

Re: [libreoffice-users] calc sort

2012-01-08 Thread Johnny Rosenberg
2012/1/7 Jay Lozier jsloz...@gmail.com: On 01/07/2012 12:32 PM, James wrote: On 01/07/12 03:48, Johnny Rosenberg wrote: 2012/1/7 Jamesbjloc...@lockie.ca: I made a simple sheet in calc that just contained 'Tue' and 'Wed'. Both cells are a date format but I tried to sort them and they won't

Re: [libreoffice-users] calc sort

2012-01-07 Thread Johnny Rosenberg
2012/1/7 James bjloc...@lockie.ca: I made a simple sheet in calc that just contained 'Tue' and 'Wed'. Both cells are a date format but I tried to sort them and they won't change order. 3.5 I don't know about other people on this list, but I certainly need a some more information about this.

Re: [libreoffice-users] calc sort

2012-01-07 Thread James
On 01/07/12 03:48, Johnny Rosenberg wrote: 2012/1/7 James bjloc...@lockie.ca: I made a simple sheet in calc that just contained 'Tue' and 'Wed'. Both cells are a date format but I tried to sort them and they won't change order. 3.5 I don't know about other people on this list, but I

Re: [libreoffice-users] calc sort

2012-01-07 Thread Jay Lozier
On 01/07/2012 12:32 PM, James wrote: On 01/07/12 03:48, Johnny Rosenberg wrote: 2012/1/7 Jamesbjloc...@lockie.ca: I made a simple sheet in calc that just contained 'Tue' and 'Wed'. Both cells are a date format but I tried to sort them and they won't change order. 3.5 I don't know about other

[libreoffice-users] calc sort

2012-01-06 Thread James
I made a simple sheet in calc that just contained 'Tue' and 'Wed'. Both cells are a date format but I tried to sort them and they won't change order. 3.5 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Calc: Sort By Column Names?

2011-11-09 Thread Rich Shepard
I have a large spreadsheet with column titles in row 1, and I need to sort the columns alphabetically by their titles. It appears that the sort function (as in all the spreadsheets I've used in the past) will sort by rows in a specified column, but I need to sort columns by a specified row.