You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by Adrian Butnaru <am...@gmail.com> on 2009/11/09 20:43:10 UTC

[Fwd: Re: VLOOKUP, HLOOKUP is not evaluating]

Sorry I made a mistake
I make the recalculation with:

evalA.evaluateFormulaCell(risksheet.getRow(35).getCell(18));
System.err.println("VLOOKUP 
"+risksheet.getRow(35).getCell(18).getNumericCellValue());

and I receive

java.lang.RuntimeException: Specified sheet from a different book
	org.apache.poi.ss.formula.WorkbookEvaluator.getSheetIndex(WorkbookEvaluator.java:168)
	org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:177)
	org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:297)
	org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:190)


Regards,
Adrian