[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 05:16:43 +0000, ericpa@microsoft.com wrote: > Reading through section 5.8, I have a question about 3-d referencing. > Given a reference of the form: =SUM(['Sheet1'.B4:'S heet2'.C5]) > > Does the specfication explicitly define how to interpret references of > this type when there are more than 2 sheets involved? Excel, for > example will sum the cells in the specified workbooks AND all cells in > sheets that are positioned between the 2 sheets. Same with Calc. I think we don't mention it explicitly at other places, but 6.3.10 Infix Operator Reference Range (":") says | Takes two references and computes the range, that is, a reference to the | smallest 3-dimensional cube of cells that include both Left and Right. A cube to my understanding does include all atoms in between corners, sides and edges ;-) Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]