66096 – support GAMMA and GAMMA.DIST functions

Bug 66096 - support GAMMA and GAMMA.DIST functions

Summary: support GAMMA and GAMMA.DIST functions

Status:	NEW

Alias:	None

Product:	POI
Classification:	Unclassified
Component:	SS Common (show other bugs)
Version:	5.2.2-FINAL
Hardware:	All All

Importance:	P2 enhancement (vote)
Target Milestone:	---
Assignee:	POI Developers List

URL:
Keywords:

Depends on:
Blocks:

Reported:	2022-05-28 15:28 UTC by PJ Fanning
Modified:	2022-08-03 05:04 UTC (History)
CC List:	0 users

Attachments
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 PJ Fanning 2022-05-28 15:28:07 UTC

Likely to be similar implementation for both but Excel GAMMA.DIST has some extra params.

Commons-math supports Gamma dist - https://commons.apache.org/proper/commons-math/javadocs/api-3.5/org/apache/commons/math3/special/Gamma.html

https://support.microsoft.com/en-us/office/gamma-function-ce1702b1-cf55-471d-8307-f83be0fc5297

https://support.microsoft.com/en-us/office/gamma-dist-function-9b6f1538-d11c-4d5f-8966-21f6a2201def