Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 27 Nov 2019 11:17:24 +0100edit directly in cellhttps://ask.libreoffice.org/en/question/86707/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?Thu, 02 Feb 2017 02:39:05 +0100https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/Comment by pateksan for <p>Microsoft has an option, which can be disabled, called "enable edit directly in cell".</p>
<p>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 <em>in the cell</em> in the spreadsheet. </p>
<p>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.</p>
<p>Does this option actually exist in LIbreoffice?</p>
https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/?comment=219039#post-id-219039At 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?Wed, 27 Nov 2019 11:17:24 +0100https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/?comment=219039#post-id-219039Answer by ExcelJoe for <p>Microsoft has an option, which can be disabled, called "enable edit directly in cell".</p>
<p>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 <em>in the cell</em> in the spreadsheet. </p>
<p>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.</p>
<p>Does this option actually exist in LIbreoffice?</p>
https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/?answer=171550#post-id-171550Editing in the formula bar IS necessary for any non-trivial spreadsheet job. Both mode are needed.Wed, 07 Nov 2018 13:24:28 +0100https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/?answer=171550#post-id-171550Comment by Mike Kaganski for <p>Editing in the formula bar IS necessary for any non-trivial spreadsheet job. Both mode are needed.</p>
https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/?comment=171552#post-id-171552Which question this answer was intended to answer? :-)Wed, 07 Nov 2018 13:28:27 +0100https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/?comment=171552#post-id-171552Answer by Thelma for <p>Microsoft has an option, which can be disabled, called "enable edit directly in cell".</p>
<p>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 <em>in the cell</em> in the spreadsheet. </p>
<p>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.</p>
<p>Does this option actually exist in LIbreoffice?</p>
https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/?answer=135326#post-id-135326Just move the cursor to the cell and press F2. This feature is available in Libre 5.4.0.3Sat, 21 Oct 2017 14:39:05 +0200https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/?answer=135326#post-id-135326Comment by Jim K for <p>Just move the cursor to the cell and press F2. This feature is available in Libre 5.4.0.3</p>
https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/?comment=135361#post-id-135361That'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.Sat, 21 Oct 2017 17:43:56 +0200https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/?comment=135361#post-id-135361Answer by pierre-yves samyn for <p>Microsoft has an option, which can be disabled, called "enable edit directly in cell".</p>
<p>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 <em>in the cell</em> in the spreadsheet. </p>
<p>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.</p>
<p>Does this option actually exist in LIbreoffice?</p>
https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/?answer=86714#post-id-86714Hi
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](/upfiles/14860181637986155.png)
RegardsThu, 02 Feb 2017 07:51:02 +0100https://ask.libreoffice.org/en/question/86707/edit-directly-in-cell/?answer=86714#post-id-86714