Page 1 of 1

[Solved] Cell display of function results

PostPosted: Wed Jan 16, 2019 1:09 am
by rtaylor@ntin.net
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

Re: cell display of function results

PostPosted: Wed Jan 16, 2019 1:18 am
by robleyd
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

Re: cell display of function results

PostPosted: Wed Jan 16, 2019 2:07 am
by rtaylor@ntin.net
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 ###.

Re: cell display of function results

PostPosted: Wed Jan 16, 2019 2:28 am
by FJCC
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.

Re: cell display of function results

PostPosted: Wed Jan 16, 2019 2:33 am
by robleyd
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.