RE: Can open Open office add?
@Darren, *, On Windows 7 sp1, 64-bit en-US with the 4.1.1 release AOO411m6(Build:9775) - Rev. 1617669 2014-08-13 09:06:54 (Mi, 13 Aug 2014) Simply not having any issues with a newly created Calc sheet and =sum() ranges that skip rows as you describe. I've uploaded the .ods file for review on Nabble hosted ML here: Calc_skipped_rows_inSum_noIssues.ods <http://openoffice.2283327.n4.nabble.com/file/n4669060/Calc_skipped_rows_inSum_noIssues.ods> Stuart -- View this message in context: http://openoffice.2283327.n4.nabble.com/Can-open-Open-office-add-tp4668915p4669060.html Sent from the Development mailing list archive at Nabble.com. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Fwd: Can open Open office add?
Am 29.10.2014 um 03:36 schrieb F C. Costero: > 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 > Hi, It's 35 years since the first release of Visicalc which followed the same calculation rules as todays spreadsheet application. > http://www.danbricklin.com/history/refcard1.htm Text values are documented as "Labels" and were not subject to arithmetic operations. You could enter numeric labels with a preceeding double-quote. Today this is a single quote. According to > http://www.excelfunctions.net/Excel-Sum-Function.html text representations of numbers within ranges are ignored by Excel's SUM function. As Rob already pointed out, Excel does some fatal mistakes when it comes to implicit string to number conversions in other contexts. The same Excel document loaded into the same version of MS Excel may yields different results on both sides of the Atlantic Ocean because different language versions of Excel convert the same text values differently. If you enter/paste/import numeric text values into your Calc document, Calc behaves correctly and consistently. You may convert these values if they are wrong (no, formatting doesn't change any values) and you can explicitly convert these values by means of the VALUE function. But you can not SUM up any text. Cheers to all the pesky trolls kidding the dev mailing list with childish rants about non-issues, Andreas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
RE: Can open Open office add?
-Original Message- From: Rob Weir [mailto:r...@robweir.com] Sent: Wednesday, October 29, 2014 08:10 To: dev@openoffice.apache.org; Dennis Hamilton Cc: myers_dar...@hotmail.com Subject: Re: Can open Open office add? On Wed, Oct 29, 2014 at 10:57 AM, Dennis E. Hamilton wrote: > Have you checked the definition of these functions, like SUM(), in the > OpenFormula specification before you get too carried away? Those have to be > reconciled with the data type that a cell is identified as carrying. So if > the cell is identified as carrying Text, rather than Number, the rules of > OpenFormula prevail. Now, OpenFormula does not dictate how the type of a > cell is established and how entries via the UI are converted, so you have > some leeway there. Just be careful, please. > > Also, it is preferable, when comparing what is correct or not in interchange > among implementations, to compare with the way the same ODS file (not XLS) is > processed when opened by Excel 2013, for example. If there is still an > interoperability discrepancy, we can narrow that down. (Conversions among > ODS and XSL[X] just create even more places for possible round-trip defects > having nothing to do with the rules for the SUM function itself.) > > Finally, is there a bug report on this, with an example of what is claimed to > be a defective computation?. It would be good to ground this situation with > some actual spreadsheet files that we can all inspect and be clear about what > we are looking at. > Another factor, when dealing with text, rather than numbers, in a cell is the locale. The string "1,000" could be interpreted differently in an English spreadsheet document versus a German one. A yes, all of the issues around internationalization of text entries taken as numbers. Important. Also, I forgot that there must also be preservation of interoperability with ODS in LibreOffice as well as determining the alignment with Excel 2013 handling of ODS files. -Rob > > -- Dennis E. Hamilton > dennis.hamil...@acm.org+1-206-779-9430 > https://keybase.io/orcmid PGP F96E 89FF D456 628A > X.509 certs used and requested for signed e-mail > > > -Original Message- > From: Darren Myers [mailto:myers_dar...@hotmail.com] > Sent: Wednesday, October 29, 2014 06:30 > To: Max Merbald; dev@openoffice.apache.org > Subject: RE: Can open Open office add? > > Hello > > I have been working in IT for 32 years, from Mainframe design through to > cloud integrations within VM ESX servers I build. So I know a little bit > about hardware and software. I found the issue, and a team of developers I > know have found a resolution. > > The backend code for the function doesn't equate for single routines of sum > in other formats based on the cell, that why it errors. However they have > proposed a code change that sums any value numeric where the format is not > equal to an integer. > > The code allows and can distingish the Value enetered, irraspective of > format, and provides the total. At the moment OpenOffice doesn't, its flawed. > > > >> Date: Wed, 29 Oct 2014 13:37:48 +0100 >> From: max.merb...@gmx.de >> To: dev@openoffice.apache.org; myers_dar...@hotmail.com >> Subject: Re: Fwd: Can open Open office add? >> >> Hello there, >> >> I used to have a Star Writer from 1988 (Version 3.0) and it was just >> only a text processing program and did not contain any spreadsheat as it >> was not a calculation program. I believe the full Star Office only came >> during the 1990s. I can't tell, however, where the spreadsheets from >> StarOffice originated. >> >> Second, of course AOO Calc can add. I've never encountered any problem >> with it regarding simple calculations like adding. What I have >> encountered multiple times, however, in 25 years of working with >> computers is that some people don't really know how to use some software >> correctly and blame the resulting errors on the software. Often enough >> they sincerely believe something is wrong with the software while the >> actual mistake was their own, using, if we go back to the calc >> programme, a flawed formula or something. Maybe that was the case here. >> >> Max >> >> >> Am 29.10.2014 um 04:57 schrieb jonathon: >> > >> > On 29/10/14 02:36, F C. Costero wrote: >> >> 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. >> > Picky. >> > I have no idea if the StarWriter from 1985 included that functi
Re: Can open Open office add?
On Wed, Oct 29, 2014 at 10:57 AM, Dennis E. Hamilton wrote: > Have you checked the definition of these functions, like SUM(), in the > OpenFormula specification before you get too carried away? Those have to be > reconciled with the data type that a cell is identified as carrying. So if > the cell is identified as carrying Text, rather than Number, the rules of > OpenFormula prevail. Now, OpenFormula does not dictate how the type of a > cell is established and how entries via the UI are converted, so you have > some leeway there. Just be careful, please. > > Also, it is preferable, when comparing what is correct or not in interchange > among implementations, to compare with the way the same ODS file (not XLS) is > processed when opened by Excel 2013, for example. If there is still an > interoperability discrepancy, we can narrow that down. (Conversions among > ODS and XSL[X] just create even more places for possible round-trip defects > having nothing to do with the rules for the SUM function itself.) > > Finally, is there a bug report on this, with an example of what is claimed to > be a defective computation?. It would be good to ground this situation with > some actual spreadsheet files that we can all inspect and be clear about what > we are looking at. > Another factor, when dealing with text, rather than numbers, in a cell is the locale. The string "1,000" could be interpreted differently in an English spreadsheet document versus a German one. -Rob > > -- Dennis E. Hamilton > dennis.hamil...@acm.org+1-206-779-9430 > https://keybase.io/orcmid PGP F96E 89FF D456 628A > X.509 certs used and requested for signed e-mail > > > -Original Message- > From: Darren Myers [mailto:myers_dar...@hotmail.com] > Sent: Wednesday, October 29, 2014 06:30 > To: Max Merbald; dev@openoffice.apache.org > Subject: RE: Can open Open office add? > > Hello > > I have been working in IT for 32 years, from Mainframe design through to > cloud integrations within VM ESX servers I build. So I know a little bit > about hardware and software. I found the issue, and a team of developers I > know have found a resolution. > > The backend code for the function doesn't equate for single routines of sum > in other formats based on the cell, that why it errors. However they have > proposed a code change that sums any value numeric where the format is not > equal to an integer. > > The code allows and can distingish the Value enetered, irraspective of > format, and provides the total. At the moment OpenOffice doesn't, its flawed. > > > >> Date: Wed, 29 Oct 2014 13:37:48 +0100 >> From: max.merb...@gmx.de >> To: dev@openoffice.apache.org; myers_dar...@hotmail.com >> Subject: Re: Fwd: Can open Open office add? >> >> Hello there, >> >> I used to have a Star Writer from 1988 (Version 3.0) and it was just >> only a text processing program and did not contain any spreadsheat as it >> was not a calculation program. I believe the full Star Office only came >> during the 1990s. I can't tell, however, where the spreadsheets from >> StarOffice originated. >> >> Second, of course AOO Calc can add. I've never encountered any problem >> with it regarding simple calculations like adding. What I have >> encountered multiple times, however, in 25 years of working with >> computers is that some people don't really know how to use some software >> correctly and blame the resulting errors on the software. Often enough >> they sincerely believe something is wrong with the software while the >> actual mistake was their own, using, if we go back to the calc >> programme, a flawed formula or something. Maybe that was the case here. >> >> Max >> >> >> Am 29.10.2014 um 04:57 schrieb jonathon: >> > >> > On 29/10/14 02:36, F C. Costero wrote: >> >> 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. >> > Picky. >> > I have no idea if the StarWriter from 1985 included that functionality, >> > but it was not uncommon in spreadsheets of that era. >> > By 1990, it would have been a mandatory feature. >> > >> > jonathon >> > >> >* English - detected >> >* English >> > >> >* English >> > >> > >> > >> > - >> > 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 > - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
RE: Can open Open office add?
Have you checked the definition of these functions, like SUM(), in the OpenFormula specification before you get too carried away? Those have to be reconciled with the data type that a cell is identified as carrying. So if the cell is identified as carrying Text, rather than Number, the rules of OpenFormula prevail. Now, OpenFormula does not dictate how the type of a cell is established and how entries via the UI are converted, so you have some leeway there. Just be careful, please. Also, it is preferable, when comparing what is correct or not in interchange among implementations, to compare with the way the same ODS file (not XLS) is processed when opened by Excel 2013, for example. If there is still an interoperability discrepancy, we can narrow that down. (Conversions among ODS and XSL[X] just create even more places for possible round-trip defects having nothing to do with the rules for the SUM function itself.) Finally, is there a bug report on this, with an example of what is claimed to be a defective computation?. It would be good to ground this situation with some actual spreadsheet files that we can all inspect and be clear about what we are looking at. -- Dennis E. Hamilton dennis.hamil...@acm.org+1-206-779-9430 https://keybase.io/orcmid PGP F96E 89FF D456 628A X.509 certs used and requested for signed e-mail -Original Message- From: Darren Myers [mailto:myers_dar...@hotmail.com] Sent: Wednesday, October 29, 2014 06:30 To: Max Merbald; dev@openoffice.apache.org Subject: RE: Can open Open office add? Hello I have been working in IT for 32 years, from Mainframe design through to cloud integrations within VM ESX servers I build. So I know a little bit about hardware and software. I found the issue, and a team of developers I know have found a resolution. The backend code for the function doesn't equate for single routines of sum in other formats based on the cell, that why it errors. However they have proposed a code change that sums any value numeric where the format is not equal to an integer. The code allows and can distingish the Value enetered, irraspective of format, and provides the total. At the moment OpenOffice doesn't, its flawed. > Date: Wed, 29 Oct 2014 13:37:48 +0100 > From: max.merb...@gmx.de > To: dev@openoffice.apache.org; myers_dar...@hotmail.com > Subject: Re: Fwd: Can open Open office add? > > Hello there, > > I used to have a Star Writer from 1988 (Version 3.0) and it was just > only a text processing program and did not contain any spreadsheat as it > was not a calculation program. I believe the full Star Office only came > during the 1990s. I can't tell, however, where the spreadsheets from > StarOffice originated. > > Second, of course AOO Calc can add. I've never encountered any problem > with it regarding simple calculations like adding. What I have > encountered multiple times, however, in 25 years of working with > computers is that some people don't really know how to use some software > correctly and blame the resulting errors on the software. Often enough > they sincerely believe something is wrong with the software while the > actual mistake was their own, using, if we go back to the calc > programme, a flawed formula or something. Maybe that was the case here. > > Max > > > Am 29.10.2014 um 04:57 schrieb jonathon: > > > > On 29/10/14 02:36, F C. Costero wrote: > >> 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. > > Picky. > > I have no idea if the StarWriter from 1985 included that functionality, > > but it was not uncommon in spreadsheets of that era. > > By 1990, it would have been a mandatory feature. > > > > jonathon > > > >* English - detected > >* English > > > >* English > > > > > > > > - > > 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
RE: Can open Open office add?
Hello I have been working in IT for 32 years, from Mainframe design through to cloud integrations within VM ESX servers I build. So I know a little bit about hardware and software. I found the issue, and a team of developers I know have found a resolution. The backend code for the function doesn't equate for single routines of sum in other formats based on the cell, that why it errors. However they have proposed a code change that sums any value numeric where the format is not equal to an integer. The code allows and can distingish the Value enetered, irraspective of format, and provides the total. At the moment OpenOffice doesn't, its flawed. > Date: Wed, 29 Oct 2014 13:37:48 +0100 > From: max.merb...@gmx.de > To: dev@openoffice.apache.org; myers_dar...@hotmail.com > Subject: Re: Fwd: Can open Open office add? > > Hello there, > > I used to have a Star Writer from 1988 (Version 3.0) and it was just > only a text processing program and did not contain any spreadsheat as it > was not a calculation program. I believe the full Star Office only came > during the 1990s. I can't tell, however, where the spreadsheets from > StarOffice originated. > > Second, of course AOO Calc can add. I've never encountered any problem > with it regarding simple calculations like adding. What I have > encountered multiple times, however, in 25 years of working with > computers is that some people don't really know how to use some software > correctly and blame the resulting errors on the software. Often enough > they sincerely believe something is wrong with the software while the > actual mistake was their own, using, if we go back to the calc > programme, a flawed formula or something. Maybe that was the case here. > > Max > > > Am 29.10.2014 um 04:57 schrieb jonathon: > > > > On 29/10/14 02:36, F C. Costero wrote: > >> 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. > > Picky. > > I have no idea if the StarWriter from 1985 included that functionality, > > but it was not uncommon in spreadsheets of that era. > > By 1990, it would have been a mandatory feature. > > > > jonathon > > > >* English - detected > >* English > > > >* English > > > > > > > > - > > To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org > > For additional commands, e-mail: dev-h...@openoffice.apache.org > > > > >
Re: Fwd: Can open Open office add?
Hello there, I used to have a Star Writer from 1988 (Version 3.0) and it was just only a text processing program and did not contain any spreadsheat as it was not a calculation program. I believe the full Star Office only came during the 1990s. I can't tell, however, where the spreadsheets from StarOffice originated. Second, of course AOO Calc can add. I've never encountered any problem with it regarding simple calculations like adding. What I have encountered multiple times, however, in 25 years of working with computers is that some people don't really know how to use some software correctly and blame the resulting errors on the software. Often enough they sincerely believe something is wrong with the software while the actual mistake was their own, using, if we go back to the calc programme, a flawed formula or something. Maybe that was the case here. Max Am 29.10.2014 um 04:57 schrieb jonathon: On 29/10/14 02:36, F C. Costero wrote: 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. Picky. I have no idea if the StarWriter from 1985 included that functionality, but it was not uncommon in spreadsheets of that era. By 1990, it would have been a mandatory feature. jonathon * English - detected * English * English - 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
Re: Fwd: Can open Open office add?
On 29/10/14 02:36, F C. Costero wrote: > 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. Picky. I have no idea if the StarWriter from 1985 included that functionality, but it was not uncommon in spreadsheets of that era. By 1990, it would have been a mandatory feature. jonathon * English - detected * English * English - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Fwd: Can open Open office add?
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 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 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 > 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...?? WTFserious 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 > > > >
Re: Can open Open office add?
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 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 > 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...?? WTFserious 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 > > > >
Re: Can open Open office add?
Hi Darren Darren Myers schrieb: What list? what do you mean by list... a list of numbers, a list of programming flaws, pseudo code structure. This mailing list. The mailing list does not allow attachments. You should ask on https://forum.openoffice.org/en/forum/ There you can attach a file to your question. Kind regards Regina - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
RE: Can open Open office add?
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 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...?? WTFserious 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
Re: Can open Open office add?
On Tue, Oct 28, 2014 at 3:23 PM, Darren Myers 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...?? WTFserious 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
RE: Can open Open office add?
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. 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...?? WTFserious 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
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...?? WTFserious fix this most basic problem. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Can open Open office add?
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...?? WTFserious fix this most basic problem.