Created attachment 117392 [details] Video showing the bug When the following dates are used on LO 5.0.0.3, the cells keep text format: 15/10/2017 16/10/2016 18/10/2015 19/10/2014 20/10/2013 21/10/2012 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 4.4.1.2 it works ok.
The problem occurs between 2011 and 2019, on dates when the daylight savings starts in Brazil: 20/10/2019 21/10/2018 15/10/2017 16/10/2016 18/10/2015 19/10/2014 20/10/2013 21/10/2012 16/10/2011 Found the pattern here: http://www.brazil-help.com/start_stop.htm
Hi Rafael, 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 ***