Hi Eike,
How do we proceed with adding text that describes how sheets positioned between the referenced sheets are handled? Should I submit a proposal?
While a reference of the type [Sheet1.A1:B5]:[Sheet2.B1:C5] seems to be "valid", are the expected results defined? It's unclear how a 3D reference with different ranges or "sides of the cube" should be calculated.
Regards,
Eric
-----Original Message-----
From: Eike Rathke [mailto:]
Sent: Monday, December 01, 2008 5:28 AM
To:
Subject: Re: [office-formula] 3-d references
Hi Eric,
Btw, it is not necessary to send copies to my personal account, I do read the list. The copies just clutter up my inbox. Thanks.
Btw2, somehow your mailer setup is broken, your mail to the list looks like it used format=flowed but that is not declared in the header, so text is interspersed with spurious '= ' and '=3D'. The mail to my personal account does not suffer from that and thus was more legible, and even includes your name in the From header.
On Monday, 2008-12-01 05:42:34 +0000, wrote:
> 1. Based on my reading of the OpenFormula Draft, it appears that
> =3DSUM(['=
> Sheet1'.A1:'Sheet2'.B5]) is equivalent to the Excel syntax of =3DSUM(Sheet1= :Sheet2!A1:B5). Is that correct?
Yes, that's correct. Without the '3D' in 'SUM' and without '= ' of course ;-) So, =SUM(['Sheet1'.A1:'Sheet2'.B5]) is equivalent to Excel =SUM(Sheet1:Sheet2!A1:B5)
> 2. The OpenFormula Draft does not explicitly say whether sheets positioned= in the workbook between the identified sheets are included or not. Can th= is be clarified?
We can explicitly state that. I think it should go into
"5.8 References", other opinions?
> 3. Are references of the following form valid?:
> [Sheet1.A1:B5:Sheet2.B1:C5= ]
No, [Sheet1.A1:B5:Sheet2.B1:C5] is not valid. References can contain at most one ':' operator, see "5.8 References". The expression would had to be written as [Sheet1.A1:B5]:[Sheet2.B1:C5]
Eike
