Bug 52378

Summary: [PATCH] Support for workday & networkdays functions
Product: POI Reporter: João Enomoto <jfaenomoto>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.8-dev   
Target Milestone: ---   
Hardware: PC   
OS: Linux   
Attachments: patch

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