Bug 49202 - Please add support for the function 'PERCENTRANK'.
Summary: Please add support for the function 'PERCENTRANK'.
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: unspecified
Hardware: PC All
: P5 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-04-27 13:37 UTC by chrisefr
Modified: 2021-10-08 15:42 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description chrisefr 2010-04-27 13:37:18 UTC
Please add support for the function 'PERCENTRANK'.
Comment 1 Nick Burch 2011-03-17 08:29:00 UTC
Please see Yegor's ApacheCon talk for details on how to go about adding new functions to the formula evaluator:

http://people.apache.org/~yegor/apachecon_us2010/Evaluation_Of_Excel_Formulas_In_POI.pptx

Please do send in a patch if you get something working!
Comment 2 Javen O'Neal 2016-10-19 08:21:14 UTC
https://support.office.com/en-us/article/PERCENTRANK-function-F1B5836C-9619-4847-9FC9-080EC9024442

This function looks like it is used to determine what percentile a given number is within a data set.
It also looks like it is an OOXML-only formula.
Comment 3 PJ Fanning 2021-08-07 14:23:59 UTC
Added with r1892077 - will look at PERCENTRANK.INC and PERCENTRANK.EXC in next few weeks.