Issue 87587 - Cell incorrectly assumes formula when prefixing with dash
Summary: Cell incorrectly assumes formula when prefixing with dash
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: DEV300m5
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Rob Weir
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-03-29 13:49 UTC by rolmol
Modified: 2013-02-09 22:56 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description rolmol 2008-03-29 13:49:47 UTC 
When prefixing some symbols or text Calc incorrectly assumes it to be a 
formula, and proposes a correction.

Tested:
-"-	Fails. Suggests =-""	Works in 2.3
-sldf	Fails. Prefixes with =	Works in 2.3
-text text	Works.
-$$$$	Fails. Prefixes with =	Works in 2.3
-££££	Works.

Reproducible: Always
Expected behaviour: Same as 2.3 - assumed to be a string
Comment 1 amy2008 2008-08-29 09:34:40 UTC 
Checked in OOo300_m3_EN on WinXP.

Tested: 
" - " is the prefix.
e.g.   -!
       -^
       -&
       -*
       -/
       -+ is followed by a space
       -- is followed by a space
There will be a suggestion dialog showing 
" OOo Calc found an error in the formula entered. Do you want to accept the 
correction proposed below?
=-
"
Comment 2 Rob Weir 2013-02-09 22:56:20 UTC 
Confirmed in 3.4.1.  Workaround is to start the input with a single quote, e.g.:

'-!