Brian. Thanks Gee I wish it was that simple. 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. I feel pretty dumb in not getting the result. Thanks Dave
> On Feb 19, 2015, at 10:44 AM, Paul D. Mirowsky <[email protected]> > wrote: > > Doesn't it seem time that this become a new feature with a default setting. > -Automatically expand width of column.- > > 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. >> >>> Went to the Frugal Computer guy to review but did not discover anything >>> glaring wrong in what I was doing. >> >> Sack him and find a better computer guy(/gal). >> >> I trust this helps. >> >> Brian Barker >> >> > > > -- > To unsubscribe e-mail to: [email protected] > 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 > -- To unsubscribe e-mail to: [email protected] 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
