What list?.... what do you mean by list... a list of numbers, a list of programming flaws, pseudo code structure. There is a significant issue with the basic function which doesn't allow me or a few people I have spoken to tonight work for them. Just admit the sum function doesn't work, it can't add up which I find very difficult to understand. But it doesn't matter, I have found a work around... that's using Excel on my Company laptop as that works!!!, and then re-importing my entire spread sheet into your backwards program to work at home. Date: Tue, 28 Oct 2014 15:55:27 -0700 Subject: Re: Can open Open office add? From: kay.sch...@gmail.com To: dev@openoffice.apache.org; myers_dar...@hotmail.com
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
