Issue 126015 - changing a formula reference to A$2 and then pressing enter automatically adds "AND()"
Summary: changing a formula reference to A$2 and then pressing enter automatically add...
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-10 09:18 UTC by richardbaxter
Modified: 2015-01-22 02:31 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
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 richardbaxter 2015-01-10 09:18:31 UTC 
Changing a formula reference to A$2, S$2 or T$2 and then pressing enter automatically adds "AND()", "SUM()" or "TEXT()" instead of exiting the formula.

To replicate;
1. create a new formula = A$2 (the number can be anything, 2 is just an example)
2. press enter
3. edit the formula (double click on it)
4. change the character "A" to "S" (S$2) or "T" (T$2)
Current behaviour: Calc automatically adds "SUM()" or "TEXT()" text 
Expected behaviour: Calc exits formula

Note it doesn't matter if the formula text is edited inline (within the cell) or in the formula bar.
Comment 1 oooforum (fr) 2015-01-12 13:56:03 UTC 
This is not a bug.
Calc suggests through tooltip to autocomplete a formula with a function.
If you don't want it, press ESC key.
Comment 2 richardbaxter 2015-01-22 02:31:24 UTC 
Why would anyone wish to enter a formula =AND(..)$2?