edit directly in cell

English
, , ,
#1

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?

Calc : How to edit formulae in formula bar directly
#2

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?

#3

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?

#4

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.

#10

Has this option been updated?
I would really like this EDIT IN CELL in the Calc Program, not just in cell only, to minimize keystrokes.
More keystrokes begets errors.

THANKS

#5

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.

screenshot
screenshot1174×593 26 KB

Regards

#6

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

#7

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.

#8

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

#9

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

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.