Hi there, I'm using Eclipse Galileo, JDK 1.6.0_14, jOpenDocument-1.2.jar.
I was trying to modify an empty spreadsheet, using sheet.getCellAt(int, int). I was getting java.lang.IndexOutOfBoundsException all the time: So I folowed the "Modify an existing spreadsheet" Tutorial to find out if I was doing something wrong. Same result: The code: package testes.jopen; import java.io.File; import java.io.FileNotFoundException; import java.io.IOException; import java.util.Date; import org.jopendocument.dom.OOUtils; import org.jopendocument.dom.spreadsheet.Sheet; import org.jopendocument.dom.spreadsheet.SpreadSheet; public class ModifySprdst { public static void main(String[] args) { try { // Load the file. File file = new File("TableTeste.ods"); final Sheet sheet = SpreadSheet.createFromFile(file).getSheet(0); // Change date. sheet.getCellAt("I10").setValue(new Date()); // Change strings. sheet.setValueAt("Filling test", 1, 1); sheet.getCellAt("B27").setValue("On site support"); // Change number. sheet.getCellAt("F24").setValue(3); // Save to file and open it. File outputFile = new File("fillingTest.ods"); OOUtils.open(sheet.getSpreadSheet().saveAs(outputFile)); } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } Console output: Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 9, Size: 1 at java.util.ArrayList.RangeCheck(ArrayList.java:547) at java.util.ArrayList.get(ArrayList.java:322) at org.jopendocument.dom.spreadsheet.Table.getRow(Unknown Source) at org.jopendocument.dom.spreadsheet.Table.getCellAt(Unknown Source) at org.jopendocument.dom.spreadsheet.Table.getCellAt(Unknown Source) at org.jopendocument.dom.spreadsheet.Table.getCellAt(Unknown Source) at testes.jopen.ModifySprdst.main(ModifySprdst.java:20) Regards.