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.
_______________________________________________
gnumeric-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnumeric-list
