On Wed, 2008-11-26 at 18:26 +0100, Eike Rathke wrote:
> 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,
I believe in Excel 'Sheet1'.B4:'Sheet2'.C5 refers to many more cells
than 'Sheet1':'Sheet2'.B4:C5 if there is a sheet between Sheet1 ad
Sheet2. So they are not equivalent!
Andreas
>
