Bug 52378 - [PATCH] Support for workday & networkdays functions
Summary: [PATCH] Support for workday & networkdays functions
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.8-dev
Hardware: PC Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-12-20 23:58 UTC by João Enomoto
Modified: 2011-12-26 17:06 UTC (History)
0 users


Attachments
patch (41.95 KB, patch)
2011-12-20 23:58 UTC, João Enomoto 		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 João Enomoto 2011-12-20 23:58:15 UTC 
Created attachment 28094 [details]
patch

Support for Excel's Analysis Tool Pack functions workday and networkdays.

Implementation of features followed rules as expressed in:

http://office.microsoft.com/pt-br/excel-help/workday-HP005209339.aspx
http://office.microsoft.com/pt-br/excel-help/networkdays-HP005209190.aspx

Added a minor bugfix at AnalysisToolPak.java in which functions from ATP couldn't match depending on function case.

Apply patch by using following commands: patch -p0 -i workday.patch
Comment 1 Yegor Kozlov 2011-12-21 11:53:47 UTC 
Very cool! Applied in r1221682

I had to rename test classes to match the Test*.java pattern  - this is how POI's build system recognizes tests. 

Regards,
Yegor
Comment 2 João Enomoto 2011-12-21 13:12:24 UTC 
Which version will it be avaiable? 3.8-beta6?

[]'s

Joao
Comment 3 Yegor Kozlov 2011-12-21 13:33:43 UTC 
I hope that the next version will 3.8-final. Can't promise when it will happen - my current estimation is Feb 2012.

Yegor

(In reply to comment #2)
> Which version will it be avaiable? 3.8-beta6?
> 
> []'s
> 
> Joao