Ask Your Question

How to sort Writer table by date?

asked 2018-02-26 18:27:52 +0200

Majikthyse gravatar image

I have a table with the first column formatted as date. I am unable to get the table to sort rows by date. I can sort by other column values but date does not work. Why?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-02-26 21:04:34 +0200

If your dates are detected as dates (i.e., you have Table-Number Recognition enabled, and entered dates using correct locale-specific format, or explicitly set the cells format to be Date; and now you can change the dates' display modifying the cell number format - say, to display 2 or 4 digits in year as you like) - then simple numeric sort works fine.

You can also enter dates in the textual format that allows to do alphabetical sort: use YYYY-MM-DD format. It is the format defined by ISO, and its use greatly simplifies both human and machine treatment by eliminating ambiguities.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-02-26 18:27:52 +0200

Seen: 227 times

Last updated: Feb 26 '18