OOo3.0 Calc Issue on Sum
Leonard Chatagnier
lenc5570 at sbcglobal.net
Sun Sep 6 19:47:35 UTC 2009
----- Original Message ----
> From: "JW Spear, Sr." <jw at JSAcivil.com>
> To: ubuntu-users at lists.ubuntu.com
> Sent: Sunday, September 6, 2009 7:52:27 AM
> Subject: OOo3.0 Calc Issue on Sum
>
> I have a 'SUM' issued on my OOo3.0. I have a 21-component sum that
> consistently returns the error '#VALUE in my Ubuntu 9.04 environment but
> when I load the same file in OOo3.1 in my Windows7 environment, with no
> further, the file reports the sum reports correctly?
>
> What to do??
>
>
Could it be that your column width is not wide enough to show all the digits in the sum?
Try increasing the column width to some abnormally large value to see if that helps. If
not you can always go back to what it was. This is pretty common in spreadsheets.
Leonard Chatagnier
lenc5570 at sbcglobal.net
More information about the ubuntu-users
mailing list