Issue 116247 - Date error while processing a special past
Summary: Date error while processing a special past
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2.1
Hardware: Mac Mac OS X 10
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-12-28 16:40 UTC by xavxav
Modified: 2013-04-02 19:04 UTC (History)
1 user (show)

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

Source file to import to Open Office and convert with ; as separator (211 bytes, text/plain)
2010-12-28 22:05 UTC, xavxav
no flags Details
Target Excel file where the date have to be passed (10.00 KB, application/
2010-12-28 22:07 UTC, xavxav
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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

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