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
