posted 13 years ago
This stack trace I am getting :
org.apache.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'Pivot Data'!B2
at org.apache.poi.ss.formula.WorkbookEvaluator.addExceptionInfo(WorkbookEvaluator.java:321)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:288)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:221)
at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:320)
at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(HSSFFormulaEvaluator.java:240)
at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(HSSFFormulaEvaluator.java:46)
Formula is : =IF(ISBLANK('Export Data'!B2),"",IF(LEFT('Export Data'!B2,3)="%%%","",VALUE(TRIM(CLEAN('Export Data'!B2)))))
Will this help any way? Is there any workaround for this?