To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=45312
------- Additional comments from [EMAIL PROTECTED] Thu May 5 05:50:45 -0700 2005 ------- This is probably a wontfiy. The solution is the following: Don't reconfigure your keyboard. It is exaclty the setting in the options that takes care of what OOo will make of the /input/ from the keyboard. If you want another /display/ of your input, you have to set a corresponding cell-format. So if you type "0.765765765" (the "." being the one on the numpad) OOo will recognize it as a decimal number when you did check the option [x] same as locale setting - no matter what locale you did set up) If you did not check the option, OOo will use whatever character your keyboard is configured to. If the character matches the decimal-seperator, OOo will recognize it as a decimal number, if it doesn't match, the input will be treated as text. To sum-it up: You have to differntiate between input of the characters and display of the result. If you want your decimal numbers to be displayed with a dot as decimal seperator, format them with a format that uses the dot as decimal seperator. If you want to enter your numbers with a dot as seperator there are two possibilities: * use the numpad - then it doesn't matter what it is configured to - when you have the option checked, it will always be recognized as decimal number. Format your cells with an appropriate format that used dot as decimal seperator * you want to enter a "real" dot (like the one on the regular keyboard-area). Then you have to switch to a reginal setting that uses the dot as seperator to input your characters. When you switch back to the original reginal settings, all the cells with standard formatting will use the seperator defined in the regional settings. So you'll still have to format your cells with the desired display format for those who differ from the defaults. It depends on your habits whether you only switch to the other regional settings to input your data and then switch back, or to keep the other reginal setting. --------------------------------------------------------------------- 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]
