I get the "Error: ) Expected" error message despite all of the parentheses
being there.
The code is as follows:
HSSFCell cell = row.createCell( columnNum );
cell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
cell.setCellFormula(
"SUM(INDIRECT(ADDRESS(3,3)):INDIRECT(ADDRESS(3,6)))" );
It errors out on the setCellFormula method.
If anyone can see what is wrong or has a workaround I would appreciate the
help.
--
View this message in context:
http://www.nabble.com/Creatin-a-function-cell-failed%3A-%22Error%3A-%29-Expected%22-tp15269031p15269031.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
