To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=88271 Issue #|88271 Summary|Calc Mangles Date Fields, results in data corruption/l |oss Component|Spreadsheet Version|OOo 2.3 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|open-import Assigned to|spreadsheet Reported by|bpeters
------- Additional comments from [EMAIL PROTECTED] Mon Apr 14 17:58:34 +0000 2008 ------- Some sytem stats: Operating system: Ubuntu 7.04 Kernel: #uname -r 2.6.22-14-generic Summary: When imported from a csv, Calc seems to randomly assign a type to what was originally a date field (quoted text). The assigned type is sometimes a number and sometimes a date, which becomes a problem if you attempt to format the cells all as dates. The cells which were interpreted as numbers do not maintain the DD/MM/YY mapping that the cells which were interpreted as dates have, and thus the two cannot be compared, sorted, etc. Reproduce: The problem can be witnessed by simply copying the following data into a spreadsheet, and selecting ',' as the delimiter: 7/12/2006,6/28/2007, 10/27/2006,2/9/2007, 2/12/2007,2/22/2007, 4/19/2007,4/24/2007, 4/25/2007,12/26/2007, 11/1/2006,2/1/2007, 11/9/2006,1/18/2007, 12/8/2006,2/9/2007, 1/18/2007,3/5/2007, 4/12/2007,6/29/2007, 4/17/2007,7/10/2007, 6/28/2007,7/11/2007, 6/29/2007,7/10/2007, 7/11/2007,7/13/2007, 7/18/2007,11/1/2007, 7/12/2007,10/29/2007, You will see some cells are numbers, others are dates. Try converting all cells to Dates, and sorting. You end up with two sets of dates, which are not compared and are not ordered. --------------------------------------------------------------------- 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]
