126015
2015-01-10 09:18:31 +0000
changing a formula reference to A$2 and then pressing enter automatically adds "AND()"
2015-01-22 02:31:24 +0000
1
1
2
Application
Calc
editing
4.1.0
All
All
UNCONFIRMED
P3
Normal
---
0
richardbrucebaxter
issues
oooforum
DEFECT
---
---
0
oldest_to_newest
1877976
0
richardbrucebaxter
2015-01-10 09:18:31 +0000
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.
1878043
1
oooforum
2015-01-12 13:56:03 +0000
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.
1878262
2
richardbrucebaxter
2015-01-22 02:31:24 +0000
Why would anyone wish to enter a formula =AND(..)$2?