Forwarding in case Darren isn't subscribed. And I see now that my reference below to 30 years should have been somewhat less, but still many years. That's what I get for reading only the title of a message. Francis
---------- Forwarded message ---------- From: F C. Costero <fjcc.apa...@gmail.com> Date: Tue, Oct 28, 2014 at 8:16 PM Subject: Re: Can open Open office add? To: dev@openoffice.apache.org Hi Darren, Really, what is the probability that a spreadsheet program that has roots going back 30 years can't add correctly? Could the program survive with that kind of flaw? I understand that it isn't doing what you expect and over at the user forum we would be happy to help straighten out the problem. The fact that a formula works one way in Excel and another in Calc is not evidence that either is wrong. For example, the two programs differ in their willingness to silently convert text to numbers. This commonly leads to Excel users being surprised by a calculation in Calc and, I suppose, Calc users being surprised by Excel. Neither approach is "right"; each expresses a choice about balancing user convenience and the risk of miscalculations. Your problem may be along those lines or may be totally different. If you post an example on the forum, we can probably quickly find the problem. Best regards, Francis On Tue, Oct 28, 2014 at 5:01 PM, Darren Myers <myers_dar...@hotmail.com> wrote: > 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 > > > >
