OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[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]