Your suggestions have solved my problem. ________________________________ From: Brian Barker <b.m.bar...@btinternet.com> Sent: Saturday, July 7, 2018 3:50 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer: Sorting in a Table
At 19:42 07/07/2018 +0000, Ted Zimmer wrote: >Microsoft Word allows sorting in a table by date, ... Microsoft Word is apparently readily available. If you prefer it, why not use it? >... but apparently LO Writer does not. This is not apparent to me. >Am I correct? I think not. >Is there a way to do it? Yup - but there are so many unknowns you will have to suck it and see. o Do you have Tools | Options... | LibreOffice Writer | Table | Input in tables | Number recognition ticked? This will affect whether data entered is interpreted as genuine dates and not just as text. Try this option if others fail for you. o Have you given relevant table cells Date number formats? o Do you have dates expressed in logical formats, such as day - month - year or year - month - day, or the (illogical) USian standard month - day - year? This may affect your ability to sort dates expressed as text, but probably not if they have been properly formatted. o What separators are you using: spaces, hyphens, dots, virgules (slashes), ...? o Is your locale set appropriately for the date format you are using? o Go to Table | Sort... . Experiment with Alphanumeric or Numeric according to what data your table cells contain. Something should work. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy