Issue 25576 - Date pasting fails
Summary: Date pasting fails
Status: CLOSED WONT_FIX
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
URL: http://www.tired.com/oootest.sxc
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
date error spreadsheet (7.44 KB, application/vnd.sun.xml.calc)
2004-02-16 20:13 UTC, bobbv 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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:

 http://www.tired.com/oootest.sxc

Oh, FWIW, the original document that this sheet came from was imported from Star
Office.
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.

Frank
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 
closing.