PERCENTILE problem

Aspose.Cells Product Family
1

Hi

I’m trying to calculate the lower quartile of a range of values, but the cell value is always #NAME?

Here is the code:

Cell cell = ws.Cells[0, 0];
cell.Formula = “=PERCENTILE(A2:A10, 0.25)”;
workbook.CalculateFormula(true);
decimal decLQ = Convert.ToDecimal(cell.Value);


I also tried R1C1Formula but got the same result. If I paste the formula directly into the cell in the spreadsheet in Excel, it’s fine. Other functions such as AVERAGE, MIN, MAX are ok.

Why won’t it work?

Martin

2

Hi Martin,

Thanks for considering Aspose.

Well, PERCENTILE Function is not supported by Aspose.Cells calculation engine, we will support it soon for your need.

Thank you.

3

Hi Martin,

Please try this attached version. We support Percentile function now.