OOo3.0 Calc Issue on Sum

[Leonard Chatagnier]

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