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@lists.freedesktop.org
Reporter: j...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
