I am investigating my sheet and it looks that the first term of the VLOOKUP
VLOOKUP($P$37;Exemptions!$E$10:$I$31;2)
is
which is a formula like that:
!Sheet0.B26
I am evaluating this formula and it gives me
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)
even if Sheet0 is part of this workbook.
I have the impression that the evaluator is not evaluating from a
different worksheet. !Sheet0.B26 is a HLOOKUP in the same sheet.
Josh Micich schreef:
Evaluation of VLOOKUP and HLOOKUP are both supported, as is evaluation
across multiple workbooks, so you should expect any basic use case to
work. It's possible that you're doing something slightly beyond what
POI supports so far. Please provide more details to help diagnose
your problem.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
