To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87999 Issue #|87999 Summary|OOo calc interprets numers as dates Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|mfrasca
------- Additional comments from [EMAIL PROTECTED] Mon Apr 7 09:47:33 +0000 2008 ------- I have a CSV file holding this line: 20-12-2007,22:44:00,007,24.08,0.0,24.85 the types are, respectively: date, time, string, float, float, float I cannot tell the csv importer that the last three columns are floats, so I leave that as 'standard'. the importer produces these types: date, time, string, date, float, float I am aware that this issue is a duplicate of 23024, but I really have a problem accepting this as a "works for us!"... it's true that the locale of most European languages dictate that ',' is the separator for decimal, but it's only in Germany where the locale dictates that the '.' separates dates! when scalc parses a '24.08' and sees it does not conform to 'decimal' (expecting comma) nor to 'date' (unless in Germany, but then they would write '24.8.', with TWO points, not just one), why don't you just make it choose for decimal? I can assure you that this is the least surprising behaviour for most Europeans!!! thanks a lot for this otherwise beautiful piece of software, running also on my linux-powerpc! --------------------------------------------------------------------- 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]
