Bug 64258

Summary: Provide implementation for TDIST function
Product: POI Reporter: Siddharam Nadgunde <siddhunadgunde4>
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: enhancement    
Priority: P2    
Version: 4.1.2-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description Siddharam Nadgunde 2020-03-23 13:12:04 UTC
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.
Comment 1 PJ Fanning 2021-10-19 14:01:55 UTC
added r1894378