To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114015 Issue #|114015 Summary|Wrong data import Component|Spreadsheet Version|OOo 3.2.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|chernish2
------- Additional comments from cherni...@openoffice.org Fri Aug 20 13:20:42 +0000 2010 ------- When opening a CSV-file with data, separated by commas, certain numbers are treated as date. For example, the number 2.1125 is treated as 01.02.1125 which is crazy. Try it yourself. Make a text file containing exactly the following: 1,2.1125,5 2,2.134,8 3,2.1256,10 Name the file "test.csv" and double-click it. In filter say "Separated by comma" and press OK. While in filter window data looks like it really is in Calc window you should see now: 1 01.02.25 5 2 01.02.34 8 3 01.02.56 10 --------------------------------------------------------------------- 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
