[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-formula] 3-d references
Hi ericpa, On Tuesday, 2008-11-25 06:13:51 +0000, email@example.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.