Bug 60307 - XIRR not supported
Summary: XIRR not supported
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: unspecified
Hardware: PC All
: P2 enhancement with 3 votes (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-10-26 13:37 UTC by Robot
Modified: 2022-05-28 15:10 UTC (History)
0 users


Attachments
error log (1.50 KB, text/plain)
2016-10-26 13:37 UTC, Robot 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Robot 2016-10-26 13:37:03 UTC 
Created attachment 34405 [details]
error log

Caused by: org.apache.poi.ss.formula.eval.NotImplementedFunctionException: XIRR
Comment 1 Javen O'Neal 2016-10-26 16:26:23 UTC 
XIRR is an OOXML 2007+ function

https://support.office.com/en-us/article/XIRR-function-de1242ec-6477-445b-b11b-a303ad9adc9d
Comment 2 PJ Fanning 2022-05-28 15:10:46 UTC 
https://github.com/RayDeCampo/java-xirr might be a good starting point if someone wanted to work on this