https://bugs.documentfoundation.org/show_bug.cgi?id=152967
--- Comment #2 from Eike Rathke <[email protected]> --- Format code D is *day of month* of a serial date number, not duration in days.. If 12.5 is formatted as date+time then it is null-date 1899-12-30 plus 12.5 days => 1900-01-11 12:00:00 For that, format code D would display 11 though; if it displays 13 for you then you have set the null-date to either "1900-01-01 (StarCalc 1.0)" (where resulting date+time would be 1900-01-13 12:00:00) (unlikely) or "1904-01-01" (where resulting date+time would be 1904-01-13 12:00:00). The latter is likely the case if you loaded an Excel document created on Mac, as 1904-01-01 was the null-date for MS-Excel on Mac, not 1899-12-31 as for Excel on Windows Btw, -1.5 then is 1903-12-30 12:00:00 - so there.. Btw2, LibreOffice's standard null-date is 1899-12-30 instead of 1899-12-31 because Excel kept its bug to regard 1900 as a leap year pretending there was 1900-02-29; LO starting 1 day earlier at least uses the same serial date number for all dates on or after 1900-03-01. -- You are receiving this mail because: You are the assignee for the bug.
