Hello Marco,
The code you supplied is incomplete, but I assume from your comment
"the row number is 0", that the problem is due to using "0" as the row
number in a cell reference expression. The following code shows the
problem more clearly:
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Sheet1");
HSSFRow row = sheet.createRow(0);
HSSFCell cell = row.createCell(0);
cell.setCellFormula("Sheet1!B0"); // <<<< ERROR - no such cell as "B0"
POI is correct in raising this error, and your fix is to use 1-based
rows in formula cell references.
>From your stack trace, it seems like you are running some pre-release
version of POI 3.5-beta4 (between svn r712084 and r718838). I've
checked 3.5-beta4 and it is also OK for this issue. There have been
many improvements since beta4 (including support for larger grids and
clearer parser error messages). Unfortunately these changes have
caused a regression on svn trunk (which silently accepts references
like "B0"). I will fix that ASAP.
regards,
Josh
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
