Bug 147160 - After editing a formula cell clicking away should not necessarily be created a cell reference
Summary: After editing a formula cell clicking away should not necessarily be created ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-03 17:11 UTC by Heinz
Modified: 2022-02-04 11:47 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Heinz 2022-02-03 17:11:38 UTC 
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
Comment 1 Vladimir Sokolinskiy 2022-02-04 11:47:24 UTC 
I think that this will increase the efficiency of using Calc and make it easier for users who have experience with Excel to adapt.