[libreoffice-users] Calc formula cursor focus behaviour - in plain text

And this one should be sent in plain text:   This could be a Calc quirk 
or the correct expected behaviour, I'm not a power user, and this is not 
drama for me either.

With a spreadsheet A1=1, B1=2, C1="=A1+B1"
_
_Example 1) In Excel 2003, where "|" is the cursor position in the 
formula "=A1+B|1", click on any other other cell and the cursor focus 
moves away leaving the formula unchanged.  I like this behaviour.
Example 2) If you position the cursor as follows: "=A1+|B1", then click 
on any other cell (e.g. C6) Excel inserts that cell reference 
"=A1+C6|B1", this allows you to enter logic etc,  but just pressing 
Enter breaks the formula, a bit yucky.

Behaviour in LibreOffice 4.4-8 from Collabora is the same as the 2nd 
example above irrespective of where the cursor is positioned._
_
Qu) Is there any chance of adopting the behaviour of Example 1?
I think adopting the resulting behaviour of example 1 for example 2 
would be wrong as there would be loss of work if you're experimenting 
trying to do a formula but are getting the syntax wrong.  Unless it is 
clever enough to detect that someone simply clicked on another cell by 
mistake.
The Escape key is of course a good backout.  But right click does 
nothing in either program, perhaps a right click could do Esc+change focus.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted