https://bugs.freedesktop.org/show_bug.cgi?id=57683
Priority: medium
Bug ID: 57683
Assignee: [email protected]
Summary: Dates between 1691 and 1790 are shifted
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 3.6.4.2 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 70786
--> https://bugs.freedesktop.org/attachment.cgi?id=70786&action=edit
ENTERING a date gives not the expected date (btw 1691 and 1790)
When entering a date between 1690-04-06 and 1791-07-27 the indicated value is
shifted by one day. This is independent of the calculation mode: 1900-01-01 and
1899-12-30 both show the same behaviour.
Since it's at the same date (not number) this might be intentional?
I've found nothing in the docs.
I cannot see any situation where this is of positive value. At least: it is
absolutely undesirable in Germany (and probably most other countries). So if
you not simply correct that behaviour there must be a place where a user can
change it.
[Explanation to the snippet:
within s row the values entered are identical, the first column formatted as
"Text", the second as "Date", the third as "Number"]
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
