Ask Your Question

Use ISO dates all over [closed]

asked 2016-12-07 02:56:12 +0100

Ole Tange gravatar image

I try to avoid using localized date formats to avoid misunderstanding, so I would like Libreoffice to use ISO format for dates where ever possible.

Most crucial to me is the value field in LibreCalc. In the cells, I can adjust with Format Cells, but how do I tell LibreCalc that I also want the value in the field to be in ISO-format (e.g. so I can press F2 and edit an ISO formatted date)?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-16 13:21:00.216402

2 Answers

Sort by » oldest newest most voted

answered 2016-12-07 18:22:00 +0100

m.a.riosv gravatar image

Sure I'm missing something, but with version, if a cell format is AAAA-MM-DD, with F2 edits with that format, and entering a value like 2016-12-20 in any cell is accepted and the cell is formatted AAAA-MM-DD.
(My locale is Spanish and my date acceptance pattern 'D/M/Y;D/M'

edit flag offensive delete link more

answered 2016-12-07 11:16:17 +0100

Lupp gravatar image

updated 2016-12-07 18:37:51 +0100

(Sorry. I had screwed up different things. Used day?)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-12-07 02:56:12 +0100

Seen: 162 times

Last updated: Dec 07 '16