[Libreoffice-bugs] [Bug 114551] Date format not stored properly in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=114551

--- Comment #3 from mitja <mitja.masten at gmail.com> ---
The problem is that Libre Office version 5.4+ treats date format somehow
differently.
According to my locale the date format is DD.MM.YYYY.
If I enter the date in spreadsheet in LO ver. 5.4+ it looks ok. And also
recognized date format is ok.
But, if i open the same file on the same computer (with the same locale) with
LO ver. 5.3 or lover (or with Open Office or with Neo Office or With Excel),
then the date format should be the same! But it isn't. Date is shown as
MM.DD.YYYY.

In other words date eg. 21.12.2017 (21st December 2017) is shown as 12.21.2017.
And this is incorrect!

Obviously, I assume, LO 5.4 stores something in the file regarding dates, that
all other spreadsheet programs (including LO ver. <= 5.3) understands
differently. And in incorrect way.

Aron, must admit that I don't quite understand your point, actually!?
Namely, if I set the date format as DD.MM.YYYY (especially explicitly) it
should stay that way, and not show as MM.DD.YYYY if the file is opened in
another program or another LO version except 5.4.
This is the same as eg. I format the text in LO Writer as bold, but in Word (or
other LO version) the text is shown as italic!

So, to me it looks like it is a bug that appeared in LO ver. 5.4.0. I checked
all versions from 5.3.7 till 5.4.3. And all versions from 5.4.0 till 5.4.3 have
this bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171221/0a838922/attachment.html>