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
I think that this will increase the efficiency of using Calc and make it easier for users who have experience with Excel to adapt.