In the section on F2 here: https://help.libreoffice.org/Calc/Shortcut_Keys_for_Spreadsheets#Function_Keys_Used_in_Spreadsheets "Press again to exit Edit mode." should be removed.
it does exit Edit mode, if you hit F2 for the second time in a cell where input was started by entering text/numbers, rather than by hitting F2.. So the Help should clarify this - although bug 70129 requests for change of the behavior.
(In reply to Cor Nouws from comment #1) > it does exit Edit mode, if you hit F2 for the second time in a cell where > input was started by entering text/numbers, rather than by hitting F2.. > > So the Help should clarify this - although bug 70129 requests for change of > the behavior. Let me put my user hat on. For me, Edit mode is enabled, when the cursor starts to blink. When I exit Edit mode, the cursor stops blinking. Today is the first time I have heard about a mysterious third state, where the cursor is blinking, but I am not in The Officially Approved Edit mode. It does explain the awkwardness of starting to edit by typing in Calc which I've always wondered about.. To make things even more wonderful, have a try using the menu Edit - Cell Edit Mode. It doesn't toggle anything: it just keeps re-enabling the Edit mode. I tried hunting for documentation on this quirky Cell Edit Mode. This does not even mention it: https://help.libreoffice.org/Calc/Edit I downloaded Calc 4.1 guide. It has this in the Input settings section: Press Enter to switch to edit mode Specifies that pressing Enter puts the selected cell into edit mode. To end Edit mode and move the cursor in the desired direction, press Enter again. So the Calc guide seems to agree with my simple user logic where Edit mode == blinking cursor.. There is nothing further in the guide about edit mode, besides the information copied from the help section "Function Keys Used in Spreadsheets" Thus: we need documentation which distinguishes starting to edit by typing and starting to edit by double-clicking/F2/Edit - Cell Edit Mode.
Yet another note: if you go to Tools - Options - Calc - General and set "Press Enter to switch to Edit mode", it behaves differently from F2. Pressing Enter again makes you exit the cell and drop to the lower one. The behaviour of this thing is all over the place.
(In reply to Buovjaga from comment #2) > Today is the first time I have heard about a mysterious third state, where > the cursor is blinking, but I am not in The Officially Approved Edit mode. What mysterious state do you mean? (which of the mysterious states :D ) A cell that has focus (dark border) shows no blinking cursor, but as soon as I start typing, blinking cursor is there.. > It does explain the awkwardness of starting to edit by typing in Calc which > I've always wondered about.. > Thus: we need documentation which distinguishes starting to edit by typing > and starting to edit by double-clicking/F2/Edit - Cell Edit Mode. plus Enter when Tools - Options - Calc - General and set "Press Enter to switch to Edit mode" is activated ;)
(In reply to Cor Nouws from comment #4) > (In reply to Buovjaga from comment #2) > > > Today is the first time I have heard about a mysterious third state, where > > the cursor is blinking, but I am not in The Officially Approved Edit mode. > > What mysterious state do you mean? (which of the mysterious states :D ) > A cell that has focus (dark border) shows no blinking cursor, but as soon as > I start typing, blinking cursor is there.. Exactly the state that you are talking about. If you press the arrow keys, you move away from the cell, so different from the edit mode, where cursor blinks, but you move inside the cell.
(In reply to Buovjaga from comment #5) > Exactly the state that you are talking about. If you press the arrow keys, > you move away from the cell, so different from the edit mode, where cursor > blinks, but you move inside the cell. Really handsome to enter data in various cells ;)
(In reply to Cor Nouws from comment #6) > (In reply to Buovjaga from comment #5) > > > Exactly the state that you are talking about. If you press the arrow keys, > > you move away from the cell, so different from the edit mode, where cursor > > blinks, but you move inside the cell. > > Really handsome to enter data in various cells ;) It is so handsome it should be documented!
Rafael Lima committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/6f4f219c04d4bb914cd2a44e782f14ac69d0abc8 tdf#112057 Clarify the use of F2 in Calc