Re: [jopendocument] Merging multiple sheets in one file

[jOpenDocument, Guillaume]

Hi,

It should be fixed in 1.2 final.

Regards,
Guillaume

Hi!

Code could be found at http://www.pkozlowski.pl/odsmerge/ODSMerge.zip

Stacktrace:
java.lang.NullPointerException
        at org.jopendocument.dom.spreadsheet.Column.getWidth(Unknown Source)
        at org.jopendocument.dom.spreadsheet.Table.updateWidth(Unknown Source)
        at org.jopendocument.dom.spreadsheet.Table.setColumnCount(Unknown 
Source)
        at org.jopendocument.dom.spreadsheet.Table.setColumnCount(Unknown 
Source)
        at org.jopendocument.dom.spreadsheet.Table.ensureColumnCount(Unknown 
Source)
        at org.jopendocument.dom.spreadsheet.Table.merge(Unknown Source)
        at org.jopendocument.dom.spreadsheet.Table.merge(Unknown Source)
        at pl.pkozlowski.odsmerge.ODSMerge.main(ODSMerge.java:33)

Regards,
Piotr

2010/11/6 Guillaume Maillard<guillaume.maill...@gmail.com>:

Hi

We will need the stacktrace and/or the files.

Regards,
Guillaume

Envoyé de mon iPhone 4

Le 6 nov. 2010 à 02:18, Piotr Kozlowski<kozlowsk...@gmail.com>  a écrit :

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