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?

edit retag close merge delete

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?

( 2019-11-27 11:17:24 +0100 )edit

Sort by » oldest newest most voted

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

more

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

more

That's what I thought the question was asking at first as well, but really, they want to know the opposite. @pierre-yves samyn has answered correctly.

( 2017-10-21 17:43:56 +0100 )edit

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

more