To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723
------- Additional comments from mfra...@openoffice.org Mon Jan 19 08:31:46 +0000 2009 ------- I tried the same file and the behaviour of my version of open office (OOO 300m9 build 9358) is still very surprising! I have a Dutch localized system, have unchecked the "same as local settings (,)" check box for the decimal separator key (tried also with checking this box, but it makes no difference whatsoever), have no intention to inform the system that I am using anything else than the Default Locale (this is something I can't expect my colleagues to buy!) and my locale dictates this: number: 123 456 789.00 (space separates thousands, dot is decimal separator key) short date notation: 2009-01-19 (dash as date separator key) all right then, the line to be imported is ACCOUNTS CHEM RES;0001-4842;24129;16.214;1.736;148;7.3; in the text import preview this shows as ACCOUNTS CHEM RES | 0001-4842 | 24.129 | 16.214 | 1.736 | 148 | 7.3 when imported it actually gives ACCOUNTS CHEM RES | 0001-4842 | 24129 | 16214 | 1736 | 148 | 2009-03-07 why does that dot in '7.3' get interpreted as a date separator? why does that dot in 24.129 show in the import preview? is the import preview using '.' as thousands separator? how's that? why do the decimal dots in 16.214 and 1.736 disappear in the imported data? please note again that in my system locale I have a space for thousands separator, a dot for decimal separator and a dash for date separator! --------------------------------------------------------------------- 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