Re: [office-formula] Test Case Data for SUMPRODUCT() (Section 6.4.5)

[Eike Rathke <erack@sun.com>]

--ZJcv+A0YCCLh2VIg
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi Eric,

On Friday, 2009-02-13 00:01:26 +0000, Eric Patterson wrote:

> One of the test cases listed for the SUMPRODUCT() function is as follows:
>=20
> =3DSUMPRODUCT([.A41:.C43];[.A41:.C43])
>=20
> The test case data in section 2.4 doesn't have any data in cells A1:C43. =
 What is expected here?

Indeed, there's something missing.

Several functions' test cases refer data in the range A41:N43, i.e.
MDETERM, MINVERSE, MMULT, MUNIT, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2
and TRANSPOSE, one may easily check searching with the regular
expression \[\..4.:\..4.\]

That seems to had been matrix test case data.

Also earlier and very early revisions of the draft are lacking it. The
matrix functions' test cases using it were introduced with revision 19
of the draft,
http://www.oasis-open.org/committees/download.php/20175/openformula-2006090=
6.odt

David, could you dig out who contributed that and maybe where the data
was lost during transfer and whether it could be retrieved? If not, we'd
have to create a new data set and adapt test cases using it.

  Eike

--=20
Automatic string conversions considered dangerous. They are the GOTO statem=
ents
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's =
list.

--ZJcv+A0YCCLh2VIg
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFJlay4Zcn5tYf41BIRApouAKC0DujjX4ylqGtKQaXnqm3Ky8zyywCgw3oI
v7aCT+sFMPkGt1HMz17ztYA=
=Sfpz
-----END PGP SIGNATURE-----

--ZJcv+A0YCCLh2VIg--