Re: [libreoffice-users] Sorting table (Writer) with months or days

Thanks Brian - very helpful!

Dave,

On Mon, Dec 28, 2015, at 10:23 AM, Brian Barker wrote:
> At 00:35 28/12/2015 -0500, Dave Boland wrote:
> > How do I get Writer to sort a table using a column with months 
> > (January, February, March, etc).) or days (Monday, Tuesday, 
> > Wednesday, etc.)?  I know that if I change them to a numeric 
> > representation it will work, but that is not what I want to do.
>
> Sorry, but we don't know that you don't want to do this unless you 
> tell us exactly why - so I'm permitted to ignore that.
>
> There lots of ways to do this:
>
> o Go to Tools | Options... | LibreOffice Writer | Table | Input in 
> tables, and ensure "Number recognition" is ticked.
> o Enter your data as genuine dates.
> o Format your data using Table | Number Format...; choose Date under 
> Category and December under Format (or Format code NNNN for days). 
> Note that the appearance of your table is now exactly as you wanted it.
> o Sort your values normally, using Numeric for "Key type".
>
> o Copy your table (text) data (or parts of it) to a spreadsheet.
> o Sort the material in the spreadsheet. On the Options tab of the 
> Sort dialogue, tick "Custom sort order" and select 
> "January,February,March...". (Days are also available.)
> o Copy the sorted material back to your table in Writer.
>
> o Copy your table (text) data (or parts of it) to a spreadsheet.
> o Convert values there to genuine dates, using available functions.
> o Sort the material in the spreadsheet (using normal numeric sort).
> o Either freeze the date values back to text, using TEXT(), and copy 
> the results back into your Writer table,
> o Or copy the date values back and format them appropriately there.
>
> There are probably more ...
>
> 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
-- 
  dave boland
  dboland9@fastmail.fm

-- 
http://www.fastmail.com - Same, same, but different...


-- 
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