Re: [office-formula] Syntax issues

["David A. Wheeler" <dwheeler@dwheeler.com>]

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