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
