Hello, I'm trying to open multiple sheets with different threads, and I get
this exception. Can you tell me whats wrong with my code?
I'm comparing two .ods sheets from different directory
@Override
public void run() {
try {
File fileOld = new File(filePathOld + "\\" + report.getId() + "-" +
report.getHashcode() + ".ods");
File fileNew = new File(filePathNew + "\\" + report.getId() + "-" +
report.getHashcode() + ".ods");
Sheet sheetOld = SpreadSheet.createFromFile(fileOld).getSheet(0);
Sheet sheetNew = SpreadSheet.createFromFile(fileNew).getSheet(0);
int rows = 1000; //sheetOld.getRowCount();
int cols = 100; //sheetOld.getColumnCount();
for (int row = 0; row < rows; row++) {
for (int col = 0; col < cols; col++) {
MutableCell<SpreadSheet> cellOld = sheetOld.getCellAt(col, row);
MutableCell<SpreadSheet> cellNew = sheetNew.getCellAt(col, row);
if (!cellOld.getValue().equals(cellNew.getValue())) {
sb.append(new Date().toString() + ": Cell at - row: " + row
+ ", col: " + col + "; doesn't match in report with id:" + report.getId() + "
and hashcode: " + report.getHashcode() + "\n");
}
}
}
} catch (IOException ex) {
ex.printStackTrace();
} catch (IllegalStateException ex) {
ex.printStackTrace();
}
}
and here is exception:
java.lang.IllegalStateException: class
org.jopendocument.dom.spreadsheet.CellStyle duplicate
at org.jopendocument.dom.Style.register(Unknown Source)
at org.jopendocument.dom.Style.registerAllVersions(Unknown Source)
at org.jopendocument.dom.Style.loadDescs(Unknown Source)
at org.jopendocument.dom.Style.getStyleDesc(Unknown Source)
at org.jopendocument.dom.Style.getStyleDesc(Unknown Source)
at org.jopendocument.dom.StyledNode.getStyleDesc(Unknown Source)
at org.jopendocument.dom.ImmutableDocStyledNode.<init>(Unknown Source)
at org.jopendocument.dom.spreadsheet.TableCalcNode.<init>(Unknown Source)
at org.jopendocument.dom.spreadsheet.Table.<init>(Unknown Source)
at org.jopendocument.dom.spreadsheet.Sheet.<init>(Unknown Source)
at org.jopendocument.dom.spreadsheet.SpreadSheet.getSheet(Unknown Source)
at org.jopendocument.dom.spreadsheet.SpreadSheet.getSheet(Unknown Source)
at net.fina2.MainFrame$CompareReport.run(MainFrame.java:453)
at java.lang.Thread.run(Thread.java:745)
java.lang.IllegalStateException: class
org.jopendocument.dom.spreadsheet.CellStyle duplicate
at org.jopendocument.dom.Style.register(Unknown Source)
at org.jopendocument.dom.Style.registerAllVersions(Unknown Source)
at org.jopendocument.dom.Style.loadDescs(Unknown Source)
at org.jopendocument.dom.Style.getStyleDesc(Unknown Source)
at org.jopendocument.dom.Style.getStyleDesc(Unknown Source)
at org.jopendocument.dom.StyledNode.getStyleDesc(Unknown Source)
at org.jopendocument.dom.ImmutableDocStyledNode.<init>(Unknown Source)
at org.jopendocument.dom.spreadsheet.TableCalcNode.<init>(Unknown Source)
at org.jopendocument.dom.spreadsheet.Table.<init>(Unknown Source)
at org.jopendocument.dom.spreadsheet.Sheet.<init>(Unknown Source)
at org.jopendocument.dom.spreadsheet.SpreadSheet.getSheet(Unknown Source)
at org.jopendocument.dom.spreadsheet.SpreadSheet.getSheet(Unknown Source)
at net.fina2.MainFrame$CompareReport.run(MainFrame.java:453)
at java.lang.Thread.run(Thread.java:745)
--
---
You received this message because you are subscribed to the Google Groups
"jOpenDocument" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to jopendocument+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
