Re: [office-formula] 3-d references

[Eike Rathke <erack@sun.com>]

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.

PGP signature