Re: [sc-dev] R + Calc Update

2007-05-02 Thread Niklas Nebel
Kohei Yoshida wrote: You may have already seen it, but there is also the scaddins module where you can add new functions. This module was there originally to ease addition of new cell functions without touching the Calc core, but I don't know if this module is actively used today (Niklas?). I

Re: [sc-dev] R + Calc Update

2007-05-02 Thread Wojciech Gryc
Niklas -- I'll focus on UNO components then. There will definitely be dialogs and visual guides for people, but I've been focusing on functions because I'd like to build something that can use any function in R, sort of like a very basic scripting process that can send anything to R and get the

Re: [sc-dev] R + Calc Update

2007-05-01 Thread Kohei Yoshida
Hi Wojciech, These are just my views, but hopefully they will be useful in some way. :-) On Sun, 2007-04-29 at 18:23 -0400, Wojciech Gryc wrote: I guess what I am trying to get at is, how can I add functions to Calc through the source code? All the tutorials I've found are for add-ins.

Re: [sc-dev] R + Calc Update

2007-05-01 Thread Wojciech Gryc
Hi, Sound good. I'll worry about getting it to work rather than making it GPL-compatible. A little off-topic now, but I wrote an article for the wiki on adding functions to the Calc code: http://wiki.services.openoffice.org/wiki/Hacking_Calc_-_Adding_Functions Feel free to comment, add, etc.

Re: [sc-dev] R + Calc Update

2007-04-30 Thread Leonard Mada
Hi, this is the answer for a similar question I once asked Niklas: Find the function name in sc/source/core/src/compiler.src, the corresponding OpCode value in sc/inc/opcode.hxx, and look in ScInterpreter::Interpret (sc/source/core/tool/interpr4.cxx) which method is called for the OpCode.

Re: [sc-dev] R + Calc Update

2007-04-21 Thread Wojciech Gryc
Thanks for the responses! With regards to GPL / LGPL issues, I understand the macro code would be under GPL, but is that okay from your end? I don't mind that license, but am not sure how OO developers feel. :) Regarding the bias in the macro (missing = 0) -- yes, this is a problem but the goal

Re: [sc-dev] R + Calc Update

2007-04-21 Thread Leonard Mada
Hi Niklas, could you please explain what this code does? { ScMatValType nType = GetDoubleOrStringFromMatrix( fVal, rString); bIsString = (nType != SC_MATVAL_VALUE); } My thinking is: - it gets content of current table cell - IF content is a numerical value, fVal is set - IF content is string,

Re: [sc-dev] R + Calc Update

2007-04-21 Thread Kohei Yoshida
Hi Wojciech, On Sat, 2007-04-21 at 02:16 -0400, Wojciech Gryc wrote: Thanks for the responses! With regards to GPL / LGPL issues, I understand the macro code would be under GPL, but is that okay from your end? I don't mind that license, but am not sure how OO developers feel. :) This is

Re: [sc-dev] R + Calc Update

2007-04-20 Thread Leonard Mada
Nice to see the work started. There is still a lot to do, but at least the work has started and it is possible to connect Calc to R. Wojciech Gryc wrote: ... Now, I also wanted to let everyone know that using RServe, I built a Java-based macro that gets R to calculate the correlation between