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