Apache OpenOffice (AOO) Bugzilla – Issue 24077
Entry like "4.95" in a spreadsheet is interpreted as a date
Last modified: 2012-02-05 20:17:58 UTC
When the locale is set to Dutch, entering 4.95 (or similar) in a cell in a spreadsheet is interpreted as april 1995. For the German locale that would be logical, but not for Dutch: we do not have a date format with dot.
Maybe a duplicate of issue 7467. Please, see issue 7467. If you think it's a duplicate, close issue 24077 as duplicate, and vote for issue 7467.
You should also see issue 1820 and issue Issue 20181 and vote for them.
It's a duplicate of issue 7467. Issue 1820 and issue 20181 are related, they are specific to using the numeric keypad but do not mention the conversion to date as a big problem. *** This issue has been marked as a duplicate of 7467 ***
Resolve duplicate of issue 7467. Close.