Hi ericpa,
On Tuesday, 2008-11-25 06:13:51 +0000, wrote:
> Continuing the same question...
>
> Given the same reference below (=SUM(['Sheet1'.B4:'Sheet2'.C5])), does
> the specification explicitly define this to be the sum of B4:C5 on
> sheet1, sheet2 and any sheets in between?
Yes, see my previous answer.
> For references, this seems to be equivalent to an Excel 3d reference
> of the type SUM(['Sheet1':'Sheet2'.B4:C5]
Yes, that's equivalent. Though it would be SUM('Sheet1':'Sheet2'!B4:C5)
in Excel.
Eike
--
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.
