Issue 25576

Summary: Date pasting fails
Product: Calc Reporter: bobbv <mikek>
Component: codeAssignee: niklas.nebel
Status: CLOSED WONT_FIX QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1.1   
Target Milestone: ---   
Hardware: PC   
OS: All   
URL: http://www.tired.com/oootest.sxc
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
date error spreadsheet none

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.