Re: [office-formula] 3-d references

[Eike Rathke <erack@sun.com>]

Hi ericpa,

On Tuesday, 2008-11-25 06:13:51 +0000, ericpa@microsoft.com 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.

PGP signature