Hi everyone, I just wanted to update everyone about the R / Calc integration, and also had some questions. First and foremost, for the duration of Summer of Code (maybe longer!) I'll be keeping a blog about my progress. It's available at http://www.11-55.org/ooblog/ -- feel free to comment and share ideas. I'll post major announcements to this list as well.
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 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. However, based on this work, I had a few questions: 1. Again, IP issues. Is using RServe ("a TCP/IP server which allows other programs to use facilities of R") a GPL-safe solution? I understand that it is, especially if I license macro code or other work as GPL as well, but wanted confirmation from someone who knows more about these issues. 2. I found that when I create a Scripts/java/ folder in the ODS archive and throw my macro folder into it, saving the spreadsheet at a later time deletes the Scripts folder and all subdirectories. Is this a bug? I'd be happy to submit it as one, but wanted to ensure it's not meant to be that way. 3. Would writing tutorials on some of the work I've done be useful? I had a tough time finding any sort of extensive walk-through on creating Java-based macros and thought it might be a good idea. Thanks, Wojciech -- Five Minutes to Midnight: Youth on human rights and current affairs http://www.fiveminutestomidnight.org/
