Created attachment 117392 [details]
Video showing the bug
When the following dates are used on LO 184.108.40.206, the cells keep text format:
It should happen with 2011, but it doesn't.
To use as date, it's you need to follow these steps:
_clear the direct format
_it will include an ' in front of the value
_delete the ' in front of value
_now it's formatted as date
Please see attached video
On LO 220.127.116.11 it works ok.
The problem occurs between 2011 and 2019, on dates when the daylight savings starts in Brazil:
Found the pattern here:
In your video, you are using a scv file. If you select "detect special numbers", LO will format dates as you expect it. This works too for hours or scientific notation.
You are right Jacques! But why this happens with these dates? :)
I think this is a duplicate, please if you are not agree, reopen it.
*** This bug has been marked as a duplicate of bug 92503 ***