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 was more to show this R/Calc connection is doable. There's a few other bugs as far as I can tell, like if you were to choose two non-adjacent columns. That being said, I won't develop this further until I find other ways of doing this. I don't really want the work to depend on a TCP/IP connection. That being said, I met with Louis Suarez-Potts from OO today (he lives in Toronto and we met through my university) and one thing he brought up was that if a TCP/IP connection is used it could be possible to have people separate the computers running the data analysis from those actually using Calc. I CC'ed him here in case I missed the main point, so please feel free to correct me! I thought this is an interesting idea, and wanted to pass it by you. I can have a R/Calc integration use a local server but build an option into it that will allow the tool to connect to another server to do the analysis. I know other projects (e.g. http://nwb.slis.indiana.edu/) that plan to do something similar. Any thoughts? Thanks, Wojciech On 4/20/07, Leonard Mada <[EMAIL PROTECTED]> wrote:
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 two > columns in Calc. The direct link to an outline of the work, source code, > etc. is: http://www.11-55.org/ooblog/?p=6 Already spotted an error: I believe that 'xs.getCellByPosition(sCol, sRow + i).getValue()' returns '0' for *Missing Values*, instead of NA! This falsifies results where values are missing. [I am NOT sure that this is the culprit, BUT *missing values* are indeed handled incorrectly.] I pointed this out, because IF getValue() indeed interprets missing values as 0, we have a problem with this method. > The purpose here was to get a proof-of-concept working, and this is by no > means an outline of how the final product will look. ... There is still much work to do. Macros could be OK as well, but it is probably better to take the RExcel approach, to store the R commands as strings in the table and have a context menu entry 'Run R Command' and 'Get R Results', and also some Calc menus for useful R functions. Yet, a nice work for the beginning. Regards, Leonard --------------------------------------------------------------------- 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/
