Hi ericpa,
On Tuesday, 2008-11-25 05:16:43 +0000, 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.
