[Libreoffice-bugs] [Bug 137448] Calc formatting numbers to date day causes wrong numbers

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #1 from Uwe Auer <uwe at franke-auer.de> ---
If you add 1 through 31 into a column and format using a date format, then you
tell LibreOffice to interpret these numbers as date, but to show only the day
of the date. And according standard setting of LibreOffice setting day 0 is
1899-30-12, 1=1899-31-12 (DD-formatted=31) , 2=1900-01-01 (DD-formatted=01),
3=1900-01-02(DD-formatted=02) and so on until TODAY()=44117 (DD-formatted=01).

See also
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1017888_715980110

This is not a 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/20201013/d9c7abdd/attachment.htm>