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 2022/10/11 18:07:30 UTC
[Bug 66303] New: POI excel formula support does not take into account that many formulas can take a cell range
https://bz.apache.org/bugzilla/show_bug.cgi?id=66303
Bug ID: 66303
Summary: POI excel formula support does not take into account
that many formulas can take a cell range
Product: POI
Version: 5.2.2-FINAL
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: fanningpj@yahoo.com
Target Milestone: ---
Based on https://bz.apache.org/bugzilla/show_bug.cgi?id=65743
It turns out that ABS can take a cell range as input. The POI code only seems
to support ABS taking a single value.
ABS(A1:A5) is supported in Excel and returns 5 cells as a result with each
value in the return being the ABS result of equivalent cell in the input range.
This seems to be a general issues. There are a lot of other functions where POI
seems to expect just one input value but where Excel allows you to provide a
range.
--
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 66303] POI excel formula support does not take into account that many formulas can take a cell range
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=66303
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|normal |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 66303] POI excel formula support does not take into account that many formulas can take a cell range
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=66303
--- Comment #1 from PJ Fanning <fa...@yahoo.com> ---
Apologies - wrong link in the issue description - I meant to paste
https://stackoverflow.com/questions/74025753/apache-poi-522-and-sumproductabsa1a5-formula-evaluation
--
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