Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.