[Issue 126015] New: changing a formula reference to A$2 and then pressing enter automatically adds "AND()"

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=126015

          Issue ID: 126015
        Issue Type: DEFECT
           Summary: changing a formula reference to A$2 and then pressing
                    enter automatically adds "AND()"
           Product: Calc
           Version: 4.1.0
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: richardbrucebaxter@hotmail.com

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.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 126015] changing a formula reference to A$2 and then pressing enter automatically adds "AND()"

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=126015

richardbaxter <ri...@hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |UNCONFIRMED
         Resolution|NOT_AN_ISSUE                |---

--- Comment #2 from richardbaxter <ri...@hotmail.com> ---
Why would anyone wish to enter a formula =AND(..)$2?

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 126015] changing a formula reference to A$2 and then pressing enter automatically adds "AND()"

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=126015

oooforum <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |oooforum@free.fr
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #1 from oooforum <oo...@free.fr> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.