Apache OpenOffice (AOO) Bugzilla – Issue 46523
trailing minus sign sometimes ignored
Last modified: 2017-05-20 11:13:26 UTC
If a field is formatted with Category=Number, Format=General, Language=Default I can enter a negative number as: 300- and it becomes -300 in the cell. Jolly good. But, if a field is formatted as #,##0.00;[RED]-#,##0.00 and I enter 300- the cell becomes 300.00 instead of -300.00
This problem does not happen if I enter something like 1,000-
what's the locale used on your system ? Frank
locale is English (USA)
Hi Eike, if it works for default nuimberformat, we should do so for userdefined and other formats too. Frank
It's more an error that it works for the General format and that for formats that include a negative part the absolute value is taken. The result should be of type string instead.
Reset assigne to the default "issues@openoffice.apache.org".