-------- Original-Nachricht --------
Datum: Thu, 31 May 2007 02:35:21 -0400
Von: "Wojciech Gryc" <[EMAIL PROTECTED]>
An: [email protected]
Betreff: Re: [sc-dev] Calc Add-in Questions (and bugs?)
> Thanks very much for the advice, I'll definitely be using it...
>
> With regards to function calculations for cells, when I hit SHIFT + CTRL
> +F9, all the cells calling for the random function rnorm() get the same
> value. It might be the way I code it (specifically, with how the function
> connects to R), so I'll let you know why it's been happening, once I
> figure
> it out.
>
> Thanks,
> Wojciech
There could be some connection to the bug I am experiencing (Rserve crash on
2nd access of the function).
OOo and Rserve become unresponsive. After killing Rserve, OOo responds normally
(though the R-session is lost).
Sincerely,
Leonard
>
> On 5/25/07, Niklas Nebel <[EMAIL PROTECTED]> wrote:
> >
> > Wojciech Gryc wrote:
> > > I just had a few questions with regards to add-in development... I'll
> > just
> > > list them as concisely as possible. (Note that these relate to the
> > R/Calc
> > > integration!)
> > >
> > > 1. Is it possible to have Calc functions overload each other? I have
> a
> > > number of functions that each pass different types of parameters
> (e.g.
> > > R("cor.test"; A1:A10; B1:B10) and R("rnorm(1)"), etc...) and I think
> > > giving them different names would be confusing.
> >
> > Each function name can have only one implementation, but it can have
> > variable parameters, see below.
> >
> > > 2. Is it possible to create a UNO add-in function with unlimited
> > > parameters? I know concatenate() does this, but it's hard-coded, and
> I
> > > can't
> > > seem to find anything on the topic.
> >
> > For the last parameter, use the type "sequence<any>". The sequence will
> > contain the remaining parameters.
> >
> > > Also, some bugs or problems I'm having -- any advice would be
> > appreciated.
> > >
> > > 1. If I write a function that calls R (suppose R("rnorm(1)") and
> write
> > > it in one cell, and the drag the cell so that the function repeats a
> > > number
> > > of times in a column or row, the adjacent cell gets a new value, but
> > then
> > > all subsequent cells have the same values. Considering rnorm(1) is a
> > > random
> > > number, it's unlikely this is a random occurrence. Is there any way
> to
> > > change it?
> >
> > Normally, each cell is calculated separately. Are you sure there isn't
> > something wrong with your code?
> >
> > > 2. While built-in functions like RAND() update automatically, the
> > > functions I wrote in the add-in do not... For example, the rnorm(1)
> > > question
> > > above does not update itself when RAND() does. Can I force an
> update?
> >
> > Shift-Ctrl-F9 (or the API method calculateAll) causes all formulas to be
> > recalculated. You can't make an add-in function that is always
> > recaclulated like RAND. We have that problem with RANDBETWEEN, too.
> >
> > Niklas
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> --
>
> Five Minutes to Midnight:
> Youth on human rights and current affairs
> http://www.fiveminutestomidnight.org/
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
