https://bugs.documentfoundation.org/show_bug.cgi?id=147160
Bug ID: 147160
Summary: After editing a formula cell clicking away should not
necessarily be created a cell reference
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: heinz.kun...@gmail.com
Description:
After editing a formula cell and clicking away to another cell there should be
created a cell reference only after an operator or opening parenthesis or
function parameter separator. (This is analogue to Excel behaviour)
For example:
Formula =A3+A5 is edited to =A3+A6. When clicking away for example to B6 CALC
creates a cell reference and the formula is: =A3+A6B6. Hitting enter creates
error.
Steps to Reproduce:
1.Edit a formula, for example =A3+A5. Edit to =A3+A6
2.Then click away to (for example) B7
3.Then the formula shows =A3+A6B7
4.Hitting ENTER creates an error #NAME?
5. Remark: In Excel this procedure does not create an error
Actual Results:
The procedure described abovecreates an Error #NAME?
Expected Results:
The behaviour should be analogue to EXCEL
Reproducible: Always
User Profile Reset: No
Additional Info:
https://git.libreoffice.org/core/+log/0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
--
You are receiving this mail because:
You are the assignee for the bug.
