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

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 ;-)


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]