Mailing-List: contact dev-help@openoffice.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openoffice.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Reply-To: <orcmid@apache.org>
From: "Dennis E. Hamilton" <orcmid@apache.org>
To: <dev@openoffice.apache.org>
Cc: <rb.henschel@t-online.de>
References: <5116D794.1070500@apache.org> <511828CE.5040500@t-online.de>
 <001c01ce07f1$a2c42780$e84c7680$@apache.org>
In-Reply-To: <001c01ce07f1$a2c42780$e84c7680$@apache.org>
Subject: RE: Calc behavior: result of 0 ^ 0
Date: Sun, 10 Feb 2013 17:25:00 -0800
Message-ID: <002501ce07f6$9d40c520$d7c24f60$@apache.org>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQN2XPAr0F+MKWgP93ooeHS0y4MO+gF2c9QbAkS24yaVBVWfoA==
Content-Language: en-us

For the record, I checked IS29500-1 (:2008 and :2011) on what the rules =
are for OOXML.=20

OOXML does not specify any edge cases or failure modes for SERIESSUM =
whatsoever.  It simply gives the mathematical expansion and provides a =
non-revealing example. =20

On the other hand, POWER(0,0) is defined to return #DIV/0!  The =
definitions are carried over verbatim from ECMA-376-4 of December 2006.  =


Nevertheless, Excel 2010 and 2013 (Preview) both result in #NUM! for =
=3DPOWER(0,0). =20

(Sigh)

-----Original Message-----
From: Dennis E. Hamilton [mailto:orcmid@apache.org]=20
Sent: Sunday, February 10, 2013 16:49
To: dev@openoffice.apache.org
Subject: RE: Calc behavior: result of 0 ^ 0

[ ... ]

PS: It appears that Excel does not satisfy the OpenFormula definition.  =
=3DSERIESSUM(0,0,1,C1:C1) where C1 =3D PI() returns #NUM!  =
SERIESSUM(1,0,1,C1:C1) returns PI().  This is the case for Excel 2010 =
and Excel 2013 (Preview).  Since SERIESSUM has no implementation in =
Apache OpenOffice, any interchange-interoperability failure is yet to =
come.=20

-----Original Message-----
From: Regina Henschel [mailto:rb.henschel@t-online.de]=20
Sent: Sunday, February 10, 2013 15:10
To: dev@openoffice.apache.org
Subject: Re: Calc behavior: result of 0 ^ 0

Hi all,

Here my view:
We should not change the current behavior, because
- It is one of three allowed result, so it is not an error.
- Changing it, would break old documents.
- returning 1 will be consistent with SERIESSUM (I know, that SERIESSUM=20
is currently not yet adapted to ODF1.2, but for SERIESSUM there is no=20
choice.)
- returning 1 is the same as in BASIC.


[ ... ]