Re: Obtainning sheet title inside a sheet

[Jean Bréfort <jean brefort normalesup org>]

Le jeudi 26 janvier 2006 à 10:57 -0600, David Stanaway a écrit :
> On Thu, 2006-01-26 at 17:41 +0100, Benoit Plessis wrote:
> > Morten Welinder wrote:
> > > If your Gnumeric is new enough, this will work:
> > >
> > > =cell("sheetname",B1)
> > >
> > > M.
> > >   
> > sorry it did work, using ';' [=cell("sheetname";B2)]
>
>
> Is that in gnumeric or in oocalc? OO uses ; as a parameter separator,
> but AFAIK, gnumeric doesn't. For me in 1.6.1,  =cell("sheetname",B2)
> works.

This is locale dependent. When the decimal separator is a dot,
=cell("sheetname",B2) works but not =cell("sheetname";B2). But in other
locales, the decimal separator is a comma, and it cannot be used to
separate the function arguments and ; is used instead.