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