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 06:13:51 +0000, ericpa@microsoft.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.


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]