Re: [libreoffice-users] ### signs in Calc

At 15:11 19/02/2015 -0500, Dave Asaibene wrote:
> On 2/19/2015 9:18 AM, Brian Barker wrote:
> >  At 08:57 19/02/2015 -0500, Dave Asaibene wrote:
> > > I take two cells, create a formula in a third cell and the 
> > > calculation results in a ###.
> >
> >  As you can see from the help text (under "### error message"), 
> > this means "The cell is not wide enough to display the contents." 
> > You need either to
> >  o (simplest) increase the column width, or
> >  o reduce the font size, or
> >  o possibly modify the cell formatting so that the displayed 
> > result is narrow enough to fit.
> >
> >  Remember that the result that is too large to be displayed may 
> > itself be an error message.
>
> Gee I wish it was that simple.

Oh, it is, it is!

> I reduced the font size from 10 to 6 changed the font style and 
> increased the column with to the rest of the page. While I do not 
> get ### any longer, I now see the formula =SUM(A1:A2). What is also 
> interesting is on the format cells menu, in the box on the lower 
> right I see the correct result. I am doing this on a blank sheet 
> with single digits like adding 1 and 2 to get the result of 3.

You evidently have Calc set to display formulae in cells rather than 
the results of those formulae. (This can occasionally be useful.) 
Just remove the tick from the option at Tools | Options... | 
LibreOffice Calc | View | Display | Formulae.

> I feel pretty dumb in not getting the result.

Please don't.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted