Bug 54356 - [PATCH] Support of statistical function INTERCEPT
Summary: [PATCH] Support of statistical function INTERCEPT
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: POI Overall (show other bugs)
Version: unspecified
Hardware: All All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-12-28 10:10 UTC by Johan Karlsteen
Modified: 2012-12-28 12:59 UTC (History)
0 users


Attachments
Implementation of INTERCEPT (3.42 KB, application/x-gzip)
2012-12-28 10:10 UTC, Johan Karlsteen 		Details
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 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