Hi Guillaume, Thanks for your prompt response.
I don't know hot to attach a file here so I'll send by email to you the ODS file. How I can provide you with the stack trace? I'm using Eclipse 3.5.2, JDK 1.6.0_20 and/or 1.7.0_04. JOpenDocument 1.2 (recommended version on the site). This is the stack trace? Exception in thread "main" java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 43) at java.lang.reflect.Method.invoke(Method.java:601) at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java: 56) Caused by: java.lang.IndexOutOfBoundsException: Index: 1024, Size: 1024 at java.util.ArrayList.rangeCheck(ArrayList.java:604) at java.util.ArrayList.get(ArrayList.java:382) at org.jopendocument.dom.spreadsheet.Row.getCellAt(Unknown Source) at org.jopendocument.dom.spreadsheet.Table.getImmutableCellAt(Unknown Source) at org.jopendocument.dom.spreadsheet.Table.isCellValid(Unknown Source) at RaportTraficInbound.main(RaportTraficInbound.java:206) ... 5 more Best regards, Andrei On Jun 7, 7:57 pm, "jOpenDocument, Guillaume" <g...@jopendocument.org> wrote: > Le 07/06/2012 10:11, Andrei Miron a crit : > > > > > > > > > Hi guys, > > > I'm trying to use jOpenDocument for modifying an existing ODS > > template. > > I get this error when I'm trying to set a value in a cell. > > > After reading some of the advices from this group I'm stuck. > > The problem is that this part of the code: > > > System.out.println(sheet.getColumnCount()); > > System.out.println(column); > > sheet.isCellValid(column,0); > > > First line is giving me 1024 columns in my sheet and the column in > > which I'm writing is 506. > > > Do you have any advice? > > > Thanks, > > Andrei > > Hi, > > In order to help, we will need the stack trace and/or the file you are > using. > What is the version of jOpenDocument used in your tests? > > Regards, > Guillaume