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

--- Comment #1 from Uwe Auer <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to