Re: [office-formula] Syntax issues

From
Andreas J. Guelzow <>
Date
2006-09-06T22:25:42+00:00
ID
1157581535.2731.9.camel@steiner.
Thread
Re: [office-formula] Syntax issues
On Wed, 2006-06-09 at 18:01 -0400, David A. Wheeler wrote:
> 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?

Gnumeric will default to the global name. In fact without that fall back
there would be little need for sheet-local and global names since then
sheet-local names could be eumulated by a naming scheme. 

For example I want to be able to access the database used on Sheet1,
which may be the global database.

Andreas
-- 
Andreas J. Guelzow, Professor
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta