Ask Your Question

LibreOffice Calc - Edit Cell Mode - Enter Key bug

asked 2019-12-02 03:27:30 +0100

GaXve gravatar image

I've assigned the Enter key for "Edit Cell Mode". By doing this, when pressing the Enter key to complete filling a cell, it now takes 2 Enter key presses, when editing a blank new cell, rather than only 1 Enter key press.

Is there an option for this, or is this a LibreOffice bug?


edit retag flag offensive close merge delete


And why do you assume a correct behavior a bug? You assigned a key to a function and this is working - you enter "Edit Cell Mode" by pressing ENTER (and you leave it by pressing ENTER again - as with every edit). In fact I don't understand the idea behind that at all: If you want to edit a blank new cell, just starting to type your data should do the job.

Opaque gravatar imageOpaque ( 2019-12-02 10:44:27 +0100 )edit

I apologize, I did not mean to offend. However, this behavior happens even when I just start typing data in a cell (without previously pressing Enter). I still have to press Enter twice (2) to "finish editing". When I edit a cell that already has content, only one (1) Enter key press is necessary.

Still, while having Enter customized for "Cell Edit Mode", if I press F2 to edit a cell (empty, or with content), only one (1) Enter key press is necessary. I may be missing something, but this behavior does not seem consistent.

GaXve gravatar imageGaXve ( 2019-12-02 14:11:57 +0100 )edit

No reason to apologize - my bad, I just could not understand, since I'm used to just starting to type

Opaque gravatar imageOpaque ( 2019-12-02 16:23:17 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-12-02 15:17:40 +0100

erAck gravatar image

updated 2019-12-02 15:19:44 +0100

Instead of assigning the Enter key to Edit Cell Mode, enable Tools -> Options -> Calc -> General, Input Settings, Press Enter to switch to edit mode.

edit flag offensive delete link more


BOOM!!! Thank you!

GaXve gravatar imageGaXve ( 2019-12-02 15:24:36 +0100 )edit

Please, if the answer solves the question click ✔.

m.a.riosv gravatar imagem.a.riosv ( 2019-12-02 22:52:13 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-12-02 03:27:30 +0100

Seen: 32 times

Last updated: Dec 02