On Tue, Oct 28, 2014 at 3:23 PM, Darren Myers <myers_dar...@hotmail.com> wrote:
> Nope categorically incorrect, I'm afraid your wrong and you need to look > at the code again. There are serious bugs within OpenOffice, doesn't anyone > test the basics? > > attached is a screen shot and it clearly shows the issue. A calculation > of different numbers showing clearly the formula which in excel WORKS! but > in OpenOffice doesn't. > > Is it a limitation of the program? > > The only way I was able to calculate was doing the following formula > which is medieval =sum(c5+c9+C11 etc etc that then produced a total. > Darren -- This list does not allow attachments so your screenshot did not come through. Please make use of the Support Forums -- https://forum.openoffice.org/ where you can provide an attachment of the sheet you're using that is returning the incorrect result. Typically a screenshot is not helpful for solving problems of this nature. For the great majority of us, the SUM function works correctly. > Date: Tue, 28 Oct 2014 00:12:20 +0100 > From: j...@juergen-lange.de > To: dev@openoffice.apache.org > Subject: Re: Can open Open office add? > > Ok Darren, OpenOffice works fine for me. If I put numbers like 4,5,4,3 > into C5..C8 OpenOffice sums them up - the result is 16. If you put empty > fields between (why?) you will see, that OpenOffice will mark only the > last field with a box. Extend the box over all your numbers and you'll > get 16 again. > > Jürgen > > > Am 27.10.2014 um 23:18 schrieb Darren Myers: > > The reason I ask if it can add is, I don't think it can.... > > > > I found a huge flaw in your program.... the formulas don't work... > > > > Example =sum(C5:C15) with a list of numbers... 4, 5, 4, 3 which should > > equate to 16.... Well in EXCEL it does!!! Your crappy program adds the > > fucking numbers and comes up with 3...?? WTF serious fix this most > > basic problem. > > > > > > > > > > --------------------------------------------------------------------- To > unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional > commands, e-mail: dev-h...@openoffice.apache.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org > For additional commands, e-mail: dev-h...@openoffice.apache.org > -- ------------------------------------------------------------------------------------------------- MzK "One must still have chaos in oneself to be able to give birth to a dancing star." -- Friedrich Nietzsche
