Issue 126015

Summary: changing a formula reference to A$2 and then pressing enter automatically adds "AND()"
Product: Calc Reporter: richardbaxter <richardbrucebaxter>
Component: editingAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: oooforum
Version: 4.1.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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?