Re: [office-formula] 3-d references

[Eike Rathke <erack@sun.com>]

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

Hi Eric,

On Thursday, 2008-12-04 17:37:22 -0800, Eric Patterson wrote:

> How do we proceed with adding text that describes how sheets
> positioned between the referenced sheets are handled?  Should I submit
> a proposal?

A sentence or two to clarify in   4.6 Reference   would do, I think.

> While a reference of the type [Sheet1.A1:B5]:[Sheet2.B1:C5] seems to
> be "valid", are the expected results defined?

I think they are. The range operator in between the two 2D ranges is
defined as "a reference to the smallest 3-dimensional cube of cells that
include both Left and Right", see
6.3.10 Infix Operator Reference Range (":")

In this case the result would be Sheet1.A1:Sheet2.C5

> It's unclear how a 3D reference with different ranges or "sides of the
> cube" should be calculated.

Is there a better wording you would suggest?

  Eike

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

--sm4nu43k4a2Rpi4c
Content-Type: application/pgp-signature
Content-Disposition: inline

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

iD8DBQFJPtaqZcn5tYf41BIRAgp/AJ4wRZhD41c4qVF5mMWAz3cHcFC7HwCbBBA1
r3XSi+cV1NxJIEnOTRiIYU0=
=v32E
-----END PGP SIGNATURE-----

--sm4nu43k4a2Rpi4c--