Apache OpenOffice (AOO) Bugzilla – Issue 116247
Date error while processing a special past
Last modified: 2013-04-02 19:04:01 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.
The Open Office version is 3.2.1 OOO321M18 (build 9502)
please attach the MS Excel and CSV file, so that the issue can be reproduced
Created attachment 75435 [details] Source file to import to Open Office and convert with ; as separator
Created attachment 75436 [details] Target Excel file where the date have to be passed
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.