You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2020/03/23 13:12:04 UTC

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

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: dev@poi.apache.org
          Reporter: siddhunadgunde4@gmail.com
  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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 64258] Provide implementation for TDIST function

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64258

PJ Fanning <fa...@yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|NEW                         |RESOLVED

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 64258] Provide implementation for TDIST function

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64258

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Alternative approach for    |Provide implementation for
                   |TDIST function formula      |TDIST function
                   |evaluation                  |
           Severity|major                       |enhancement

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 64258] Provide implementation for TDIST function

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64258

--- Comment #1 from PJ Fanning <fa...@yahoo.com> ---
added r1894378

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 64258] Alternative approach for TDIST function formula evaluation

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64258

Siddharam Nadgunde <si...@gmail.com> changed:

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 64258] Alternative approach for TDIST function formula evaluation

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64258

Siddharam Nadgunde <si...@gmail.com> 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 64258] Alternative approach for TDIST function formula evaluation

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64258

Dominik Stadler <do...@gmx.at> changed:

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org