nadSeeker General User

Joined: 29 Sep 2010 Posts: 7
|
Posted: Sun Oct 17, 2010 11:31 am Post subject: Help needed in accessing cell ranges for Calc Add-ins |
|
|
Hey, i have succeeded in adding a function to Calc and reading the input figures on a Calc spreadsheet. I'm using the <projectName>.impl.java file generated and changing its return statement so as to give the result of my function.
But I can only access a pre-defined number of cells only. i.e. the size of the array i define in the java code. How can I access a dynamically determined cell range and use its values to do a computation??
eg: when the user inputs the cell values as
2 4 7
1 7 3
4 3 9
each value in one cell, and when I program to take a 3*3 array(2-D array), computation succeeds(obvious) But I need to extend the code to be able to access any sized cell range.
I've tried out the method of creating the for loop as
for(int i=0; ; i++){
for(int j=0; ; j++){
...<mycode>
}
}
but it even doesn't work
Great help if one can give me a hint.
Thanx in advance _________________ ~seeker~ |
|