Thx For your reply Sylvain :-). Yes it's a version problem, now it works well after using jopendocument 1.2.
Regards! On Friday, May 4, 2012 12:40:31 PM UTC+1, gammoudi neji wrote: > > Hello, > I have a method which read all records from an input .ods file, It works > well especially for multi-line cell. > For multi-line cell i get only the first line and not all the content. > This is my code: > sheet = SpreadSheet.createFromFile(file).getSheet(2); > > //Iterating through each row of the selected sheet > MutableCell cell = null; > > for(int nRowIndex = 5; nRowIndex < 20; nRowIndex++) > { > //Iterating through each column > > for( int nColIndex = 0;nColIndex < 11; nColIndex++) > { > cell = sheet.getCellAt(nColIndex, nRowIndex); > > // cell.setValue(obj) > > excelData[nRowIndex][nColIndex]=cell.getValue().toString(); > > excelData[5][10]=component; > > System.out.println("aaaaaaaaa"+cell.getValue().toString()); > > } > > } > > > How can do with multiples line? someone has an idea please? > >