[jopendocument] Merging multiple sheets in one file

[Piotr Kozlowski]

Hi!

I'm trying to merge multiple spreadsheets (each containing just one
sheet) into one file (which should have many sheets - one from each
input file), but I get a lot of exceptions. Ie.:

SpreadSheet merged = SpreadSheet.createEmpty(new DefaultTableModel());
for (File filename : list) {
        merged.addSheet(filename.getName());
        Sheet sheet = merged.getSheet(filename.getName());

        SpreadSheet part = SpreadSheet.createFromFile(filename);
        TableModel tm2 = part.getSheet(0).getTableModel(0, 0);

        sheet.merge(tm2, 0, 0); //at this point I got NullPointerException
        sheet.setColumnCount(10); //the same
}

I'm using Java 1.6.0.22 on Ubuntu 10.04 x64, jOpenDocument 1.2 beta 3.

Any ideas what am I doing wrong?

Regards,
Piotr