Hi,
I am currently evaluating aspose.cell (Java) and running into a problem:
I want to store a large string in a cell, which works, but if I am opening the workbook (calling the function a second time) again I get 'String index out of range: -25534' exception.
This is the samplecode:
public void test() throws Exception {
Workbook workbook = new Workbook();
workbook.open("book1.xls");
Worksheets worksheets = workbook.getWorksheets();
Worksheet sheet = worksheets.getSheet(0);
Cell cell = sheet.getCell("A1") ;
String sTxt = "<" ;
for (int i = 0 ; i < 400; i++)
sTxt += "123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 " ;
sTxt += ">";
cell.setValue(sTxt);
workbook.save("book1.xls");
}
Any idea, what's wrong?
regards