To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116247 Issue #|116247 Summary|Date error while processing a special past Component|Spreadsheet Version|1.0.0 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|editing Assigned to|spreadsheet Reported by|xavxav
------- Additional comments from xav...@openoffice.org Tue Dec 28 16:40:46 +0000 2010 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org