edit directly in cell

Microsoft has an option, which can be disabled, called “enable edit directly in cell”.

It’s great, because when disabled, a long formula in a cell ONLY shows up in the formula bar, where it should be, and it doesn’t show the formula in the cell in the spreadsheet.

Case in point: I wish to change (type edit the formula in) say, cell D11, but in order to know what to type, I need to be able to see -with my human eyes- the value in C11. D11 has a long formula which covers up C11. It’s another simple, clunky shortcoming.

Does this option actually exist in LIbreoffice?

At the moment the full formula is displayed in the cell even if I highlight the cell and click in the formula bar. I can probably live with what the OP describes if at least I can see all my cells if click in the formula bar. Can that be done?

At the moment the full formula is displayed in the cell even if I highlight the cell and click in the formula bar. I can probably live with what the OP describes if at least I can see all my cells if click in the formula bar. Can that be done?

The keyboard combination to edit in the formula bar is Ctrl+Shift+F2. this setting can be changed via Tools/Customize/Keyboard. it is needed to select the line showing F2 Cell edit mode and enter “Input line” in the field function, confirm by selecting Modify and then Save.

Hi

To my knowledge there is no option for that. In a case such as this one I use the Function Wizard that allows to modify (each term of) the formula without masking the surrounding cells.

Regards

Just move the cursor to the cell and press F2. This feature is available in Libre 5.4.0.3

That’s what I thought the question was asking at first as well, but really, they want to know the opposite. @PYS has answered correctly.

Editing in the formula bar IS necessary for any non-trivial spreadsheet job. Both mode are needed.

Which question this answer was intended to answer? :slight_smile: