To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102810 Issue #|102810 Summary|Error importing dates in october month Component|Spreadsheet Version|OOo 3.0.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|cruzandre
------- Additional comments from [email protected] Mon Jun 15 18:31:11 +0000 2009 ------- When you import a CSV file with some dates in MM/DD/YYYY format and you chose de DD/MM/YYYY format, the Cal mistake the import in some october dates like: 10/14/2001 10/19/2003 10/16/2005 10/15/2006 10/21/2007 10/19/2008 10/18/2009 10/17/2010 10/16/2011 10/21/2012 10/20/2013 10/19/2014 10/18/2015 To reproduce the problem, create a text file with a date list in MM/DD/YYYY format, save the file with .csv extension and then open it in Calc. When text import assistent open, select the colun and set the colun type as DD/MM/YYYY date format. I tested all dates between 01/01/2000 and 12/31/2015 and I got a wrong result in the list above, when the Calc misinterpretation the dates as a text. I think that the problem occur only in october month, buy as I don't check the font code, I don't have sure about this. --------------------------------------------------------------------- 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
