https://issues.apache.org/bugzilla/show_bug.cgi?id=50437
Summary: NPV Function doesn't properly support ranges
Product: POI
Version: 3.7
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: P2
Component: POI Overall
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=26379)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=26379)
Test .xls file that demonstrates the issue.
Using POI 3.7 the NPV function doesn't support ranges in the second argument.
For example, assume that A1 thru A3 contain numbers and A4 contains some double
value. Assume A4 is the cell in which we are using the NPV function. The
formula:
=NPV(A4,A1,A2,A3) - works
=NPV(A4,A1:A3) - fails
When you use POI to evaluate these, the first expression works but the second
one does not and it should.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
