You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by Darren Myers <my...@hotmail.com> on 2014/10/27 23:18:40 UTC
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...?? WTF serious fix this most basic problem.
RE: Can open Open office add?
Posted by "Dennis E. Hamilton" <de...@acm.org>.
-----Original Message-----
From: Rob Weir [mailto:rob@robweir.com]
Sent: Wednesday, October 29, 2014 08:10
To: dev@openoffice.apache.org; Dennis Hamilton
Cc: myers_darren@hotmail.com
Subject: Re: Can open Open office add?
On Wed, Oct 29, 2014 at 10:57 AM, Dennis E. Hamilton
<de...@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.hamilton@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_darren@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.merbald@gmx.de
>> To: dev@openoffice.apache.org; myers_darren@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-unsubscribe@openoffice.apache.org
>> > For additional commands, e-mail: dev-help@openoffice.apache.org
>> >
>> >
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Can open Open office add?
Posted by Rob Weir <ro...@robweir.com>.
On Wed, Oct 29, 2014 at 10:57 AM, Dennis E. Hamilton
<de...@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.hamilton@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_darren@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.merbald@gmx.de
>> To: dev@openoffice.apache.org; myers_darren@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-unsubscribe@openoffice.apache.org
>> > For additional commands, e-mail: dev-help@openoffice.apache.org
>> >
>> >
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
RE: Can open Open office add?
Posted by "Dennis E. Hamilton" <de...@acm.org>.
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.hamilton@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_darren@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.merbald@gmx.de
> To: dev@openoffice.apache.org; myers_darren@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-unsubscribe@openoffice.apache.org
> > For additional commands, e-mail: dev-help@openoffice.apache.org
> >
> >
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
RE: Can open Open office add?
Posted by Darren Myers <my...@hotmail.com>.
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.merbald@gmx.de
> To: dev@openoffice.apache.org; myers_darren@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-unsubscribe@openoffice.apache.org
> > For additional commands, e-mail: dev-help@openoffice.apache.org
> >
> >
>
Re: Fwd: Can open Open office add?
Posted by Max Merbald <ma...@gmx.de>.
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-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Fwd: Can open Open office add?
Posted by jonathon <to...@gmail.com>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Fwd: Can open Open office add?
Posted by Andreas Säger <sa...@t-online.de>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Fwd: Can open Open office add?
Posted by "F C. Costero" <fj...@gmail.com>.
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 <fj...@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 <my...@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.schenk@gmail.com
> To: dev@openoffice.apache.org; myers_darren@hotmail.com
>
>
>
> On Tue, Oct 28, 2014 at 3:23 PM, Darren Myers <my...@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: jl@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-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
>
>
>
> ---------------------------------------------------------------------
>
> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
>
> For additional commands, e-mail: dev-help@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?
Posted by "F C. Costero" <fj...@gmail.com>.
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 <my...@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.schenk@gmail.com
> To: dev@openoffice.apache.org; myers_darren@hotmail.com
>
>
>
> On Tue, Oct 28, 2014 at 3:23 PM, Darren Myers <my...@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: jl@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-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
>
>
>
> ---------------------------------------------------------------------
>
> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
>
> For additional commands, e-mail: dev-help@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?
Posted by Regina Henschel <rb...@t-online.de>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
RE: Can open Open office add?
Posted by Darren Myers <my...@hotmail.com>.
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.schenk@gmail.com
To: dev@openoffice.apache.org; myers_darren@hotmail.com
On Tue, Oct 28, 2014 at 3:23 PM, Darren Myers <my...@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: jl@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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@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?
Posted by Kay Schenk <ka...@gmail.com>.
On Tue, Oct 28, 2014 at 3:23 PM, Darren Myers <my...@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: jl@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-unsubscribe@openoffice.apache.org For additional
> commands, e-mail: dev-help@openoffice.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@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?
Posted by V Stuart Foote <VS...@utsa.edu>.
@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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
RE: Can open Open office add?
Posted by Darren Myers <my...@hotmail.com>.
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: jl@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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Can open Open office add?
Posted by Jürgen Lange <jl...@juergen-lange.de>.
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.
>
>
>