Bug 54356

Summary: [PATCH] Support of statistical function INTERCEPT
Product: POI Reporter: Johan Karlsteen <johan.karlsteen>
Component: POI OverallAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: All   
OS: All   
Attachments: Implementation of INTERCEPT

Description Johan Karlsteen 2012-12-28 10:10:17 UTC
Created attachment 29796 [details]
Implementation of INTERCEPT

Patch containing implementation of INTERCEPT.

I reused a lot from XYNumericFunction since it was a good start but it lead to some code duplication. I couldn't extend XYNumericFunction since I needed to do 2 passes over the array.

Haven't been able to verify the documentation since I cannot get Apache Forrest running.
Comment 1 Yegor Kozlov 2012-12-28 12:52:52 UTC
Thanks for the patch, applied in r1426485

I added one more unit test based on the example on http://office.microsoft.com/en-us/excel-help/intercept-function-HP010062512.aspx?CTT=5&origin=HA010277524 and it nicely passed.

Regards,
Yegor
Comment 2 Johan Karlsteen 2012-12-28 12:59:14 UTC
Nice! Thanks for the quick response!

The first test was taken from this example:
http://support.microsoft.com/kb/828234

Regards,
Johan

(In reply to comment #1)
> Thanks for the patch, applied in r1426485
> 
> I added one more unit test based on the example on
> http://office.microsoft.com/en-us/excel-help/intercept-function-HP010062512.
> aspx?CTT=5&origin=HA010277524 and it nicely passed.
> 
> Regards,
> Yegor