To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=72640
------- Additional comments from [EMAIL PROTECTED] Fri Mar 30 18:06:35 +0000
2007 -------
>From the user's point of view this is what the program does currently. Each
>cell
may have a different decimal separator. It uses the decimal separator according
to it's current number format rather than the specified one. So "1.99" is valid
in an english cell but it is invalid in a german cell where you have to type
"1,99".
What I'd like to see: Just treat all input according to the locale (second
option in Tools>Options>Lang where you specify the decimal separator). The
formatting ("output") of a cell should be independant. This is exactly how
constants in formulae are handled already. "=1,99" is accepted as a number if
the locale uses comma as decimal separator. If the cell has some english style
("output") then "=1,99" yields "1.99".
If constant values "1,99" where treated in the same consistant manner as
constants within formulae, then you could edit all numbers in a spreadsheet
through the Num-Pad. Currently this is impossible unless you format all cells
according to your locale.
---------------------------------------------------------------------
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]
