[Solved] Checked box to show formulas. Formulas not shown.

Discuss the spreadsheet application
Post Reply
CaliRay
Posts: 71
Joined: Sun Apr 26, 2009 6:20 pm

[Solved] Checked box to show formulas. Formulas not shown.

Post by CaliRay »

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?
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
CaliRay
Posts: 71
Joined: Sun Apr 26, 2009 6:20 pm

Re: Checked box to show formulas. Formulas not shown.

Post by CaliRay »

Thanks. Done.
OOo 4.1.3 on Windows 10 Home
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Checked box to show formulas. Formulas not shown.

Post by Zizi64 »

I could, at one time see formulas in cells.
Where you want to see the formula? In the actual cell, or in the formula editor box?



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.
Picture for 1. & 2.
Picture for 1. & 2.
ShowFormula1.png (14.14 KiB) Viewed 1569 times
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).
ShowFormula3.png
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.
CaliRay
Posts: 71
Joined: Sun Apr 26, 2009 6:20 pm

Re: Checked box to show formulas. Formulas not shown.

Post by CaliRay »

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
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Checked box to show formulas. Formulas not shown.

Post by Zizi64 »

Please upload your example .ods document here.

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.
Post Reply