[Libreoffice-bugs] [Bug 118654] New: strange behaviour when typing formula containing named cell '_C'

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118654

            Bug ID: 118654
           Summary: strange behaviour when typing formula containing named
                    cell '_C'
           Product: LibreOffice
           Version: 5.4.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: john at curioussymbols.com

Description:
LO misbehaves when user attempts to use a cell name 'C' (which is automatically
converted to '_C' to avoid clash with C1R1 naming).

When the user attempts to type the name _C at the end of a formula, input text
is mysteriously disappeared, as if autocorrect is acting on the text, even
though it is unclear why.




Steps to Reproduce:
1. Create new sheet
2. In A1, enter 'C'
3. In B1, enter '800'
4. In A2, enter 'alpha'
5. In B2, enter '0.8'
6. Select cells A1:B2, then click menu Sheets->Names->Create and press enter
(just 'left column' selected in dialog)
7. Move to cell B1 and notice that the cell has become named '_C' as expected
8. In A3, enter, '=1 - alpha/C' and press ENTER



Actual Results:

After typing ENTER at step 8, the contents of the cell have become

= 1 - _C

and the editing is still active, ie the input has not been completed.

If I press ENTER one more time, I get the WRONG cell value -799.

Expected Results:
I would have expected the input to have been completed, and the cell should
show a value of 0.999.



Reproducible: Always


User Profile Reset: No



Additional Info:
Note: I checked my AutoCorrect options; there is no entry there for '_C'. This
is not an autocorrect action.

Note: I can obtain the correct input by pressing SPACE at step 8, BEFORE
pressing ENTER.

Version: 5.4.6.2
Build ID: 1:5.4.6-0ubuntu0.17.10.1
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); Calc: group

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180710/18ab64cc/attachment.html>