Re: [libreoffice-users] Writer: Sorting in a Table

Your suggestions have solved my problem.
________________________________
From: Brian Barker <b.m.barker@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+unsubscribe@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+unsubscribe@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