Ask Your Question
0

edit directly in cell

asked 2017-02-02 02:39:05 +0100

Exceluser gravatar image

updated 2020-08-31 19:14:28 +0100

Alex Kemp gravatar image

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 flag offensive close merge delete

Comments

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?

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

3 Answers

Sort by » oldest newest most voted
2

answered 2017-02-02 07:51:02 +0100

pierre-yves samyn gravatar image

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

Regards

edit flag offensive delete link more
0

answered 2017-10-21 14:39:05 +0100

Thelma gravatar image

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

edit flag offensive delete link more

Comments

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.

Jim K gravatar imageJim K ( 2017-10-21 17:43:56 +0100 )edit
-1

answered 2018-11-07 13:24:28 +0100

this post is marked as community wiki

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.

edit flag offensive delete link more

Comments

Which question this answer was intended to answer? :-)

Mike Kaganski gravatar imageMike Kaganski ( 2018-11-07 13:28:27 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-02-02 02:39:05 +0100

Seen: 1,733 times

Last updated: Nov 07 '18