Hi Sylvain, Thank you for your suggestions, they're helpful. Still I have a few questions, sorry:
On Jan 13, 2:49 pm, Sylvain Cuaz <[email protected]> wrote: > Philip a crit : > > > Hi, > > > Congratulations for this initiative, looks good and promising! > > Hi, thanks : <snip> : > > - I found I can only *modify* cells. Trying to *add* data beyond the > > envelope of currently existing rows and columns leads to out-of-bound > > errors. > > You need to call Table.setColumnCount()/setRowCount() or if you have > many values merge(). How can I get a Table referring to a specific sheet? Suppose I do sh = getSheet ('Datasheet#1') (where Datasheet#1 contains an unknown number of data) Q.1: How do I get a handle to Table()? In the jOpenDocument javadocs I see that sh.getTABLE() is -again- protected. Q.2: How do I know what values to enter for setColumnCount() & setRowCount(), knowing the array size to write but *not* knowing the data size already present in the sheet. In other words, if I set setColumnCount or setRowCount too small, do I run the risk that existing data will be truncated? Q.3: In a more general sense, is there a method to find out the size of existing data in a sheet, e.g. like Excel/VB's UsedRange()? BTW I tried to search the svn but I can't find the link on the jOpenDocument web page. Thank you & best wishes, Philip
