Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

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 
    nothing in either program, perhaps a right click could do Esc+change
To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.