[Solved] Cell display of function results

Discuss the spreadsheet application

[Solved] Cell display of function results

Postby rtaylor@ntin.net » Wed Jan 16, 2019 1:09 am

I enter a formula for a cell, eg.= B3*C3, the reults displayed are ### . If i look in the the function wizard I see the correct result, but cannot get Calc to display the numerical answer. Thanks
Last edited by rtaylor@ntin.net on Wed Jan 16, 2019 2:55 am, edited 1 time in total.
openoffice 4.1.6 on Windows 10
rtaylor@ntin.net
 
Posts: 2
Joined: Fri Jan 27, 2017 12:01 am

Re: cell display of function results

Postby robleyd » Wed Jan 16, 2019 1:18 am

That simply means the column is not wide enough to display the contents. Right click on the column header and use one of the Column width options to adjust the width; or simply drag the right border of the column header to increase the width.

If you are new to spreadsheets, you may find the following to be useful resources.

[Tutorial] Ten concepts that every Calc user should know
OpenOffice Spreadsheet Tutorial for Beginners with Examples
Cheers
David
Apache OpenOffice 4.2.0 Build 9820 alpha version - 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: 2570
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: cell display of function results

Postby rtaylor@ntin.net » Wed Jan 16, 2019 2:07 am

thanks for quick reply. I did read the 10 must subjects and found that notation about width, but the result is only five digits long, but I extended the width of the column anyway and still get either the formula displayed or the triple ###.
openoffice 4.1.6 on Windows 10
rtaylor@ntin.net
 
Posts: 2
Joined: Fri Jan 27, 2017 12:01 am

Re: cell display of function results

Postby FJCC » Wed Jan 16, 2019 2:28 am

It sounds like the option to display formulas is active. Go to the menu Tools -> Options and expand the Calc list on the left. Click View and remove the selection from Formulas in the Display section.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7091
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: cell display of function results

Postby robleyd » Wed Jan 16, 2019 2:33 am

It seems that Calc is configured to display the actual formulae, not results of formulae, on your computer. Go to Tools | Options | OpenOffice Calc | View; under Display make sure that the Formulae checkbox is NOT checked.

 Edit: Whilst you are in the Tools | Options it would be worth your while to have a look at all the various things you can configure from there. 
Cheers
David
Apache OpenOffice 4.2.0 Build 9820 alpha version - 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: 2570
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 16 guests