Issue 58734 - Inconsistent treatment of +, -, /, and * following a number in a cell
Summary: Inconsistent treatment of +, -, /, and * following a number in a cell
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-12-01 14:45 UTC by atdsm
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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".