Issue 58734

Summary: Inconsistent treatment of +, -, /, and * following a number in a cell
Product: Calc Reporter: atdsm <steve.m.frank>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description atdsm 2005-12-01 14:45:38 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.
Comment 1 frank 2005-12-15 12:13:45 UTC
Hi Niklas,

please have a look at this one.

Frank
Comment 2 niklas.nebel 2006-07-14 18:13:17 UTC
changing target
Comment 3 Marcus 2017-05-20 11:11:32 UTC
Reset assigne to the default "issues@openoffice.apache.org".