Bug 54508 - Implement missing function EDATE
Summary: Implement missing function EDATE
Alias: None
Product: POI
Classification: Unclassified
Component: POI Overall (show other bugs)
Version: 3.9-FINAL
Hardware: PC Linux
: P2 enhancement with 4 votes (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2013-01-31 09:17 UTC by Detlef Brendle
Modified: 2013-02-04 22:03 UTC (History)
0 users

Patch including function plus testcase (4.37 KB, patch)
2013-01-31 09:17 UTC, Detlef Brendle
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Detlef Brendle 2013-01-31 09:17:54 UTC
Created attachment 29909 [details]
Patch including function plus testcase

The function EDATE (http://office.microsoft.com/en-us/excel-help/edate-function-HP010342465.aspx) should also be part of POI.
I implemented a function incl. a testcase for it.

Would be great if you add that to your distribution some time.

Comment 1 Anthony J Clink 2013-02-04 17:42:35 UTC
I implemented his solution, worked fine... but would really like to see this implemented in the core library.

Several of our internal test tools use excel created spreadsheets. but we have a use case where these functions need to be updated programatically.

Implementing this solution seems the only course.
Comment 2 Nick Burch 2013-02-04 22:03:50 UTC
Thanks for this, committed in r1442392.

If there are any more like this, please do go ahead and open a new bugzilla entry then upload a patch for it!