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

Discuss the spreadsheet application

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

Postby CaliRay » Fri Apr 21, 2017 1:19 pm

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

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

Postby MrProgrammer » Fri Apr 21, 2017 7:26 pm

CaliRay wrote:No matter what I try I can't see any previously entered formulas. I can see newly entered formulas. Suggestions?
Attach your ODS document demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).

CaliRay wrote:OOo 3.0.X on Ms Windows XP
This version is quite old, released maybe ten years ago. If you've upgraded but haven't changed your forum signature for posts, fix it in User Control Panel → Profile → Edit Signature, otherwise you may receive inappropriate advice.
Mr. Programmer
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.9.5.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 2891
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

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

Postby CaliRay » Fri Apr 21, 2017 11:11 pm

Thanks. Done.
OOo 4.1.3 on Windows 10 Home
CaliRay
 
Posts: 20
Joined: Sun Apr 26, 2009 6:20 pm

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

Postby Zizi64 » Sat Apr 22, 2017 9:05 am

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.

ShowFormula1.png
Picture for 1. & 2.
ShowFormula1.png (14.14 KiB) Viewed 71 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; LibreOffice4.4.7 - Portable versions: LO3.3.0-LO5.3.2 and AOO4.1.3; on Win7x64Prof.
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 4983
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Postby CaliRay » Sat Apr 22, 2017 7:28 pm

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

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

Postby Zizi64 » Sat Apr 22, 2017 10:59 pm

Please upload your example .ods document here.

Maybe some cells are protected.
Tibor Kovacs, Hungary; LibreOffice4.4.7 - Portable versions: LO3.3.0-LO5.3.2 and AOO4.1.3; on Win7x64Prof.
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 4983
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: No registered users and 45 guests