Hi, 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?? [image:
Rolling Eyes]
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
--
~SeekerN~
