Issue 116247

Summary: Date error while processing a special past
Product: Calc Reporter: xavxav <xavophonic>
Component: editingAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 3.2.1   
Target Milestone: ---   
Hardware: Mac   
OS: Mac OS X 10   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Source file to import to Open Office and convert with ; as separator
none
Target Excel file where the date have to be passed none

Description xavxav 2010-12-28 16:40:46 UTC
I noticed an error when I try a special past on a date on a Excel File.  In the Excel File, the format of the 
date is (DD/MM/YY).
1) I open in Calc a Excel File created with MS Excel for Mac
2) I import in Calc a CSV file with date in the European continental format (DD/MM/YYYY).
3) In the CSV file, I create a formula in a new Column (C) to get a pointer to the column (=B1) where B is 
the column with the dates. The value of the date is any date in 2010.
4) I copy the column C from the CSV file
5) I do a special past to the Excel File with the following  parameters checked : caracter strings + 
number + dates and hours.
6) The copied date in in 2014 and not in 2010.

I noticed that the problem does not occurs if I copy form a CSV file to a Open Office Classeur SXC file.
Comment 1 xavxav 2010-12-28 16:42:47 UTC
The Open Office version is 3.2.1 OOO321M18 (build 9502)
Comment 2 Marcus 2010-12-28 20:58:23 UTC
please attach the MS Excel and CSV file, so that the issue can be reproduced
Comment 3 xavxav 2010-12-28 22:05:21 UTC
Created attachment 75435 [details]
Source file to import to Open Office and convert with ; as separator
Comment 4 xavxav 2010-12-28 22:07:11 UTC
Created attachment 75436 [details]
Target Excel file where the date have to be passed
Comment 5 Rob Weir 2013-02-02 03:00:52 UTC
This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. 

You can download Apache OpenOffice 3.4.1 from http://www.openoffice.org/download

Please report back the outcome of your testing, so this Issue may be closed or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the
future.