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: [email protected]
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
