[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 #3 from Uwe Auer <uwe at franke-auer.de> ---
(In reply to Uwe Auer from comment #1)

Correction:

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: 1899-12-30 (DD-formatted=30)
Day=1: 1899-12-31 (DD-formatted=31)
Day=2: 1900-01-01 (DD-formatted=01)
Day=3: 1900-01-02 (DD-formatted=02) and so on until 
TODAY()=44117: 2020-10-13 (DD-formatted=13)

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

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/5586fdc0/attachment.htm>