Apache OpenOffice (AOO) Bugzilla – Issue 25576
Date pasting fails
Last modified: 2013-08-07 15:15:02 UTC
I have a document that when dates are pasted from it, they paste incorrectly. In the document the date could read 2/16/04, but when it's pasted it comes out as 2/16/00. Likewise, 2/16/03 comes out as 2/16/99, etc. Quite annoying. A sample document that does this is available from: http://www.tired.com/oootest.sxc Oh, FWIW, the original document that this sheet came from was imported from Star Office.
Created attachment 13211 [details] date error spreadsheet
Hi Niklas, set the language under Tols Options to English US and try it. Frank
The document has null date 1/1/1904. When cells are copied to a document with the default null date, the values are copied unchanged, but interpreted as different dates. This won't be changed.
closing.