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: [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
