Thank you all for the responses! I've put together a small document (temporary link: http://www.utsc.utoronto.ca/~04grycwo/overview.pdf) that outlines some thoughts in terms of how I see this going, and a few potential strategies. Here's a quick summary:
1. Creating an R package that communicates directly with OpenOffice and allows the passing of commands back and forth. 2. Doing the above with a TCP/IP connection instead. 3. Macros - sub-optimal in my opinion, but can be done. I downloaded and started playing with OO source code. You're right in saying the documentation isn't the greatest, though I can see why: there's a lot here. I think I'm getting the hang of it all, but just had some questions: 1. Using the wiki, I learned how to modify current functions, and exploring the code shows me where add-ins are placed and how they look. I was wondering, however, where do function names get stored? Again, I see the interpX.cxx but those function names are not the same as the ones I call from Calc -- how does Calc know what to call? 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. 2. From your perspectives, should this be considered an add-in or directly coded into the "sc" folder? Is there any other area of the source code I should be working in? 3. Any thoughts on the TCP/IP versus package-to-OO communication mentioned above? I think it might be a bit beyond the scope of the summer project, but I'd be happy to try to tackle it if there's interest. I just finished my last exam for this school year on Friday at 4 pm, so I'll be working on this pretty much full-time now. You can expect to hear a lot more compared to what you've been hearing so far. :) Thank you, Wojciech On 4/23/07, Niklas Nebel <[EMAIL PROTECTED]> wrote:
Leonard Mada wrote: > 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, rString is set and nType is set to SC_MATVAL_VALUE > > Am I correct with this interpretation? > And, what happens IF the cell is empty? GetDoubleOrStringFromMatrix accesses an intermediate result of matrix type, not directly a cell. It's not of much use outside of formula calculation. If a matrix element is empty, SC_MATVAL_EMPTY is returned. 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/