[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-formula] 3-d references
On Wed, 2008-11-26 at 18:26 +0100, Eike Rathke wrote: > 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, 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 >
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]