Bug 54508 - Implement missing function EDATE
Summary: Implement missing function EDATE
Status: RESOLVED FIXED
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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-31 09:17 UTC by Detlef Brendle
Modified: 2013-02-04 22:03 UTC (History)
0 users


Attachments
Patch including function plus testcase (4.37 KB, patch)
2013-01-31 09:17 UTC, Detlef Brendle 		Details | Diff
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 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.

Thanks,
detlef
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!