https://bz.apache.org/bugzilla/show_bug.cgi?id=64258
Bug ID: 64258
Summary: Alternative approach for TDIST function formula
evaluation
Product: POI
Version: 4.1.2-FINAL
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
I am trying to evaluate formula using the below approach:
FormulaEvaluator evaluator =
workbook.getCreationHelper().createFormulaEvaluator();
for (Sheet sheet : workbook) {
for (Row r : sheet) {
for (Cell c : r) {
if (c.getCellTypeEnum().equals(CellType.FORMULA)) {
try {
evaluator.evaluateFormulaCellEnum(c);
} catch (Exception e) {
log.info("Exception: " + e.getMessage(), e);
}
}
}
}
}
And the exccel formula is : IF(G7<0,TDIST(ABS(G7),MIN(C7,C$6),1),"-")
After executing this I got below exception:
org.apache.poi.ss.formula.eval.NotImplementedFunctionException: TDIST
So, my question is is there any alternative solution to evaluate the given
formula by Apache POI library in Java?
Please kindly help me for the same.
Thanks in advance.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
