[Solved] setDataArray causes exception

[ptsenter]

Hi,
here a snippet from Java program:

Code: Select all

Object dataArguments[][] = new Object[1][Policy.analysisLength];
XCellRange cellRange     = sheet.getCellRangpByPosition(0, j, Policy.analysisLength - 1, j);  //I assume this is one row
XCellRangeData cellData  = (XCellRangeData)UnoRuntime.queryInterface(XCellRangeData.class, cellRange);
dataArguments            = cellData.getDataArray();         // I got correct data
cellData.setDataArray(dataArguments);                       // always fails  "com.sun.star.uno.RuntimeException"

The last statement always fails.
What are possible reasons for that?

Thank you.

[Villeroy]

setDataArray requires a nested list of list.
A1:C3.getDataArray() => ( (A1,B1,C1), (A2,B2,C2), (A3,B3,C3) )

[ptsenter]

But what does this mean in Java's terms?
getDataArray returns Object[][] which is sequence of sequence.
One would assume what's returned by getDataArray should be successfully passed to setDataArray - which is exactly what documentation claims true.

[Villeroy]

Sorry, I don't read Java well. However, the "old forum" provides the richest source of examples.
http://www.oooforum.org/forum/viewtopic ... tdataarray

[ptsenter]

OK, it turned out that an error lies outside of a code I provided: a spreadsheet I tried to update with setDataArray was read-only. One might argue it's an user's error. It is.
But OpenOffice might have been smarter and throw more meaningful exception instead of generic com.sun.star.uno.RuntimeException. In this particular case, and in most Java cases, error handling routine does not even need to know what exception has been raised by Java and just propagate (raise) it upstream and I would see IIOException.
The only reason for com.sun.star.uno.RuntimeException in this case documentation provides is size mismatch, which is completely confusing.
Anyway, thank you for your help, especially CellRange, which saved my day - it sped up filling a spreadsheet by 120+ times.