Bug 49202 - Please add support for the function 'PERCENTRANK'.
Summary: Please add support for the function 'PERCENTRANK'.
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
Depends on:
Reported: 2010-04-27 13:37 UTC by chrisefr
Modified: 2021-10-08 15:42 UTC (History)
0 users


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:


Please do send in a patch if you get something working!
Comment 2 Javen O'Neal 2016-10-19 08:21:14 UTC

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.