Apache OpenOffice (AOO) Bugzilla – Issue 58734
Inconsistent treatment of +, -, /, and * following a number in a cell
Last modified: 2017-05-20 11:11:32 UTC
OOo Calc has an inconsistent treatment of signs following a number entered into a cell in Calc. In Calc, enter the following four lines into four seperate cells: 65+ 65- 65* 65/ The results are: 65 (treated as number) -65 (treated as number) 65* (treated as text) 65/ (treated as text) 65- is a shortcut for entering -65, which makes sense. However, 65+ is treated as a number, but should be text to be consistent with the behavior of 65* and 65/. Entering 65+ can't be a "shortcut" for entering +65, because just entering 65 itself would do that. Instead, 65+ should be treated as text. (This is expecially true because often a plus sign following a number is used as a heading to indicate values in the range over a certain number - such as ages 1-17,18-25,26-65,65+. It is much less common to intend to enter a + sign after a number and expect it to turn into the number 65.) This issue was inspired by issue 56568, which delt with both CSV imports and formatting.
Hi Niklas, please have a look at this one. Frank
changing target
Reset assigne to the default "issues@openoffice.apache.org".