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] Syntax issues

Eike Rathke wrote:
> Hi David,
> I'm picking up on some old stuff:
> On Wed, Aug 09, 2006 at 18:38:31 -0400, David A. Wheeler wrote:
>> ='Sheet1'.$$Hello            # Look for Sheet-local name first, THEN global.
> I don't get it why a global name should be tried at all in this
> constellation. Of course one _can_ do, but writing the sheet prefix plus
> global name would be an error, or what am I missing?
Hmm, this construct could have two different possible semantics.
If possible, we should be very specific.

I think we ought to duplicate whatever the typical semantics are
for applications that support sheet-local names.  I know Gnumeric and
Excel have them - can someone double-check their semantics?

I _think_ these are Excel's semantics. Excel typically tries to do
"something else" instead of reporting an error, even when it's
very arguable that it SHOULD report an error.

--- David A. Wheeler

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