Hi all, I'm calling evaluateInCell on an apparently-valid formula (that is, c.getCellType() == Cell.CELL_TYPE_FORMULA) and receiving an exception relating to an invalid reference (below). Is it possible for a cell to contain invalid references, yet not be of the type "CELL_TYPE_ERROR"?
Thanks. Exception in thread "main" java.lang.IllegalArgumentException: Invalid sheetIndex: -1. at org.apache.poi.ss.formula.SheetRefEvaluator.<init>(SheetRefEvaluator.java:35) at org.apache.poi.ss.formula.OperationEvaluationContext.createExternSheetRefEvaluator(OperationEvaluationContext.java:95) at org.apache.poi.ss.formula.OperationEvaluationContext.getArea3DEval(OperationEvaluationContext.java:254) at org.apache.poi.ss.formula.WorkbookEvaluator.getEvalForPtg(WorkbookEvaluator.java:565) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:439) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:260) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:206) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:317) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(HSSFFormulaEvaluator.java:237) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(HSSFFormulaEvaluator.java:46) at ExcelEditorService.recalc(ExcelEditorService.java:219) at ExcelEditorService.loadAndEdit(ExcelEditorService.java:145) at ExcelEditorService.main(ExcelEditorService.java:42)
