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
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@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy