I've searched the Calc forum, read the help files, checked tutorials. Nothing.
I could, at one time see formulas in cells.
Sheet and document protection is off.
Saved file as both ods and xls.
No matter what I try I can't see any previously entered formulas.
I can see newly entered formulas.
Suggestions?
[Solved] Checked box to show formulas. Formulas not shown.
[Solved] Checked box to show formulas. Formulas not shown.
Last edited by CaliRay on Sun Apr 23, 2017 12:16 pm, edited 1 time in total.
OOo 4.1.3 on Windows 10 Home
Re: Checked box to show formulas. Formulas not shown.
Where you want to see the formula? In the actual cell, or in the formula editor box?I could, at one time see formulas in cells.
1.: In the Formula edit box;
Select a cell. The formula box will show the formula of the selected cell. If the Formula box is not visible, then you can customize the user interface.
2.: In the cell;
Double click on the cell. The cell will show the formula instead of the value. You can edit the formula in the cell.
3.: You can adjust the setting:
Tools - Options - Open/LibreOffice Calc - View - Display - Formulae.
The Calc will show the formulas in the cells permanently (instead of the referenced/calculated values).
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Checked box to show formulas. Formulas not shown.
Thanks for the solution. I have not seen this before anywhere. BTW, checking the box to show the formula has no effect in my spreadsheet. Newly entered formulas show as I enter them. Others, previously in entered into the same sheet do not show until I double click the cell.
OOo 4.1.3 on Windows 10 Home
Re: Checked box to show formulas. Formulas not shown.
Please upload your example .ods document here.
Maybe some cells are protected.
Maybe some cells are protected.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.