[Solved] Cannot get Calc to calculate

Discuss the spreadsheet application

[Solved] Cannot get Calc to calculate

Postby Craig209Smith » Sat Sep 14, 2019 2:00 am

I was using OO 4.1.2 when Calc stopped calculation. I uninstalled 4.1.2 and installed OO 4.1.6 TWICE
Pressing CTL-A, CTL-M, F9 has no effect
I have Tools-Cell Contents-AutoCalculate clicked on
I have done a complete virus check
I have done a full defrag
I have powered down - waited five minutes - then powered back up
Repeated all of the above to no avail
No matter what I do the cell doesn't show results only the formula - see attachment
I am obviously doing something wrong and stupid but for the life of me, I can't see it
Would someone please provide constructive help

Thank you all -Told you it was a dumb mistake
Solution: TOOLS - OPTIONS - OPENOFFICECALC - VIEW - Uncheck Formulas - OK - Restart
I am guessing that the check box is available if one wanted to print out the formulas
Attachments
Why.ods
I tried entering a formula several different ways The Function Dialog Box shows the correct result but doesn't put it in the cell - just the formula
(9.04 KiB) Downloaded 7 times
Last edited by robleyd on Sat Sep 14, 2019 11:47 am, edited 3 times in total.
Reason: Tagged [Solved]
OpenOffice 4.1.2 on Windows 10
Craig209Smith
 
Posts: 3
Joined: Thu Nov 15, 2018 1:17 pm

Re: Cannot get Calc to calculate

Postby robleyd » Sat Sep 14, 2019 2:15 am

Go to Tools | Options | OpenOffice Calc | View ; under Display ensure that Formulae is NOT selected.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2933
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] Cannot get Calc to calculate

Postby robleyd » Sat Sep 14, 2019 12:00 pm

You shouldn't need to restart to have this option take effect.

You might find it interesting to take a look through all the global settings that are available via Tools | Options for all the AOO tools you use.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2933
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: No registered users and 38 guests