Date 27 Mar 2011 in LibreOffice Calc automatically convert (while click Enter) in date 26 Mar 2011.
Hi, please don't set your own bug on New, it needs to be confirmed by a QA team member.
What is your operating system, what is the version of LibreOffice you used? and provide a clear step to reproduce. Thanks - Set as needinfo - Sophie
The dates before 27.03.11 0:00 and 1:00 are displayed as "26". Also found in master.
Maybe this is a duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=74869,
The issue seems to be in relation with some time zones for the OS.
Eike: Calc + date related bug, thought you might be interested in this one.
(I don't reproduce this with 22.214.171.124 LO Debian package but probably missed some points)
Which timezone are you in, and was there some change in timezone offset or daylight saving time on that date?
It is DST +1 staring date in Europe, at 2:00.
That's CEST, no problem with that here. So what's the exact timezone? e.g. Europe/Berlin or...?
I can reproduce it with 'UTC+07 Omsk, Novosibirsk' Windows timezone.
Reproduced with a TZ=Asia/Novosibirsk environment.
Technically times between 2011-03-27T00:00 and 01:00 do not exist, which (again) is the problem here.
See also https://en.wikipedia.org/wiki/Time_zones_in_Russia#Daylight_saving_time
*** This bug has been marked as a duplicate of bug 63230 ***