Hi Nick,
On 15 April 2014 11:49, Nicholas Evans <[email protected]> wrote: > Dear Bruno, > > I have tried out your test code and cannot reproduce the exception that you > get. > I don't seem to be able to reproduce it either when running it in the ODF toolkit copy taken from SVN this morning but it hangs instead. This is the behaviour I was seeing when I wrote the first implementation using v0.5-incubating from the Maven repositories; moving to v0.6-incubating using the .jar directly seemed to fix the hanging problem but triggered the exception. Obviously what might have happened is that by doing that I introduced an interfering dependency. Is there any plan to make ODF Toolkit available in the Maven repositories again so that client projects can just reference the Maven repo? > I can load the spreadsheet in without a problem, and can also query the > spreadsheet as expected. > > I couldn't get your test to pass because it seems to take a long time to > run. Methods like getRowCount() can return much higher values than you > expect (on your test code it returns 1048576 for me), and getRowByIndex() > is a very slow method for large numbers of rows. > Right, so what is the best way to iterate over all rows in a table and all cells in a row? This is a very simple spreadsheet with 1 table, 1 row and 3 cells in the first row. If getRowCount() and getRowByIndex() are unreliable and slow, should they be deprecated or at least identified as not safe for general use? > > Are you running this code in a clean project without other dependencies > which might be interfering? If not perhaps you could try this? > This is very possible as my project also uses Apache POI so there may be some dependencies that interfere. As explained above, I'm currently using the 0.6 jar files direct but would prefer to just reference the project in a Maven repo to let Maven sort out dependencies. Cheers, Bruno
