To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93881
------- Additional comments from conte4...@openoffice.org Fri Mar 27 04:01:57 +0000 2009 ------- I have attempted to enter both 1.8e6 and 1,8e6 under both Finnish and Default(English) settings under Tools->Language under Windows Vista basic x64 and XP SP2, (both with Open Office v 3.0) and Ubuntu Linux 8.10 (Open Office v 2.0) and I get the same results for all of them as follows: Locale Setting = Default(English) -> 1,8e6 = #NAME? & 1.8e6 = 1800000 Locale Setting = Finnish -> 1.8e6 = #NAME? & 1,8e6 = 1800000 (except for Vista, it displays the result as 1,80E+006 in the grid, but it's shown as 1800000 in the formula bar, weird...) These were both tried with and without the delimiter option being checked, and with and without the exponent (e6) part. Based on the appropriate delimiter stated for these locales, should these not be correct? Also, was the result you saw actually shown as "1.8 million" and not 1800000? The delimiter was indeed set for "," for Finnish along with other European Language Locale settings I've tried and they all displayed the same way. The same goes for the Default (English) and other (Asian) countries with their delimiter set to "." (i.e. Chinese, Japanese) As far as I'm concerned this is acting accordingly, whereas you seem to claim Finish locale has "." as their delimiter but you get two different responses from different operating systems. Could you provide more specific steps on how I could reproduce this bug? Some further testing ideas could involve seeing the effect of proper number formatting for currency values instead of normal numbers. --------------------------------------------------------------------- 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