Issue 25576 - Date pasting fails
Summary: Date pasting fails
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: niklas.nebel
QA Contact: issues@sc
Depends on:
Reported: 2004-02-16 20:12 UTC by bobbv
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

date error spreadsheet (7.44 KB, application/vnd.sun.xml.calc)
2004-02-16 20:13 UTC, bobbv
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bobbv 2004-02-16 20:12:16 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:

Oh, FWIW, the original document that this sheet came from was imported from Star
Comment 1 bobbv 2004-02-16 20:13:41 UTC
Created attachment 13211 [details]
date error spreadsheet
Comment 2 frank 2004-02-17 09:18:11 UTC
Hi Niklas,

set the language under Tols Options to English US and try it.

Comment 3 niklas.nebel 2004-02-17 09:36:20 UTC
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.
Comment 4 niklas.nebel 2004-02-17 09:36:57 UTC