Hello,

I'm using the ODF toolkit in my tool SQL Workbench/J 
(http://www.sql-workbench.net) to import ODS spreadsheets into the database.

I got a report from a user that when importing his spreadsheet my application 
hangs and stops respsonding.

I tracked this down to Row.getCellCount() which I use to determine the real 
number of columns in the spreadsheet before importing it.

For some reason the ODS file claims to have 1024 columns and 1048576 rows and the above 
mentioned function uses two nested loop over the rows and columns. So while the 
application does not really "hang" it will probably take a long time to count 
the number of columns in the spreadsheet
(I killed it after 10 minutes running on a Intel Core i7 CPU).

I have attached the ODS file in question (I hope the mailing list allows this).

Kind regards
Thomas Kellerer

Attachment: IT_machines.ods
Description: application/vnd.oasis.opendocument.spreadsheet

Reply via email to