Bug 147160

Summary:	After editing a formula cell clicking away should not necessarily be created a cell reference
Product:	LibreOffice	Reporter:	Heinz <heinz.kuntze>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	sokol
Priority:	medium
Version:	7.3.0.3 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

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.