https://bugs.documentfoundation.org/show_bug.cgi?id=100452
--- Comment #6 from Eike Rathke <er...@redhat.com> ---
Not related to Excel. If you enter -0001-01-01 it results in a formula =-1-1-1
which is -3 which is the date serial number of 1899-12-27 (with the common null
date 1899-12-30).
Though dates BCE can't be entered they can be calculated, for example in A1
enter 0001-01-01 and in A2 =A1-1 formatted as YYYY-MM-DD G
The date calculation somehow is messed up though, the result for this example
is
0002-12-31 BC, which at least is "unexpected" ... even with year 0 not being
allowed.
As for what exactly is stored in the file (down to 0001-01-03 for which it
starts to break) I didn't finally investigate yet.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
