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

What you're describing sort of sounds like the feature that prevent
computing formula if the file originate from another office suite if it
could cause issues, but that's probably not it as it should not prevent you
from typing new formula.

Could you upload such problematic file somewhere so we can look at it?

-- 
Cley Faye
http://cleyfaye.net

2015-02-19 21:11 GMT+01:00 Dave Asaibene <dasaibene@icloud.com>:

> 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 <p_mirowsky@bentaxna.com>
> 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: 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
> >
>
>
> --
> 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

-- 
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