OO.o CALC SUM() GIVES WRONG ANSWER

[Leonard Chatagnier]

--- On Wed, 11/19/08, Bart Silverstrim <bsilver at chrononomicon.com> wrote:

> From: Bart Silverstrim <bsilver at chrononomicon.com>
> 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, 2:55 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. Yep, I was one of the many that got 4
> feet of water in the house, but could have been worse if we
> were closer to the coast line. Would appreciate anyone
> knowing what might be causing this error to give me a clue.
> It would be very appreciated.
> 
> Can you make a simple spreadsheet where the problem occurs,
> and post it 
> somewhere where others could download it and see if they
> can reproduce 
> the problem on their installations of OO.o?
> 
>
Bart, that was one quick reply and thanks. I can certainly do what you ask and would be happy to only if you or someone could give me a link to upload it to.  I've seen on the list people doing this but I've never uploaded anything before. A link to upload to would be most helpful and I do have file uploader ubstalled on firefox. Thanks again.

Leonard Chatagnier
lenc5570 at sbcglobal.net