[Bug 64258] New: Alternative approach for TDIST function formula evaluation

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 64258] New: Alternative approach for TDIST function formula evaluation

Bugzilla from bugzilla@apache.org
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: [hidden email]
          Reporter: [hidden email]
  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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64258] Alternative approach for TDIST function formula evaluation

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64258

Siddharam Nadgunde <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64258] Alternative approach for TDIST function formula evaluation

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64258

Siddharam Nadgunde <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|All                         |Windows 10

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]