OO.o CALC SUM() GIVES WRONG ANSWER

[Leonard Chatagnier]

--- On Wed, 11/19/08, Wulfy <wulfmann at tiscali.co.uk> wrote:

> From: Wulfy <wulfmann at tiscali.co.uk>
> Subject: Re: OO.o CALC SUM() GIVES WRONG ANSWER
> To: "Ubuntu user technical support, not for general discussions" <ubuntu-users at lists.ubuntu.com>
> Date: Wednesday, November 19, 2008, 3:32 PM
> Leonard Chatagnier wrote:
> > Searching google on the subject gave no solution or
> insight. I have a simple column(P) of numbers formatted as
> US currency. There are spaces between the numbers as the
> descriptions to the left are too long for one line. While
> using the summation icon in the function bar several lines
> below the list of numbers and in the same column(P) the
> answer it gives is in error low by 137. Have deleted the
> sum() function and entered it again several times but no
> joy. The problem seem to first occur after adding to the
> list of numbers and moving the sum() function down the
> column to make room for the additional numbers added to the
> column.  When I select the function it shows in the title
> bar, =SUM(P56:P108), which seems to be correct as it
> includes the first and last entries on the column.
> > When I use my old trusty TI-34II calculator I get a
> reproducible number 137 higher than the sum() gives. The
> spreadsheet is for income tax return itemizing Hurricane Ike
> losses and those in the USA knows what the IRS does with
> inaccurate returns. Would appreciate anyone
> knowing what might be causing this error to give me a clue.
> It would be very appreciated.
> >
> >
> > Leonard Chatagnier
> > lenc5570 at sbcglobal.net
> >
> >   
> How many digits are in the sum?  It sounds like it might be
> a rounding 
> error...
> 
Blessings to you also, Wolfy. I did think of that too. Under Format->Cells I added 2 decimal places instead of the 0 default but it didn't change the sum() output value at all. As you asked, there are 17 entries for the sum() function and the starting number and ending number in the sum function includes the beginning and ending numbers in the column. Very strange indeed. I may have to go join NoOp at the OO.o forum for this yet but hoping the list could give me a clue that works.  Thanks for the help,

Leonard Chatagnier
lenc5570 at sbcglobal.net