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: 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 javascript:void(0); - 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?
On Wed, Oct 29, 2014 at 10:57 AM, Dennis E. Hamilton dennis.hamil...@acm.org 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 javascript:void(0); - 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?
-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 dennis.hamil...@acm.org 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. orcnote 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. /orcnote -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 javascript:void(0); - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org - To unsubscribe, e
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?
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...?? 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?
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...?? 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?
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
