Apache POI - Common 5.3.0 · org.apache.poi.ss.formula.functions.NormSDist

public final Class NormSDist

Implementation for Excel NORMSDIST() and NORM.S.DIST functions.

https://support.microsoft.com/en-us/office/normsdist-function-463369ea-0345-445d-802a-4ff0d6ce7cac
https://support.microsoft.com/en-us/office/norm-s-dist-function-1e787282-3832-4520-a9ae-bd2a8d99ba88

Field Summary

Modifier and Type	Field and Description
public static final NormSDist	instance

Access	Constructor and Description
private	NormSDist()

Modifier and Type	Method and Description
public ValueEval	evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1) Implements org.apache.poi.ss.formula.functions.Function1Arg.evaluate. see `Function#evaluate(ValueEval[], int, int)`
public ValueEval	evaluate(ValueEval[] the pre-evaluated arguments for this function. args is never `null`, nor are any of its elements. args, OperationEvaluationContext primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals. ec) Implements org.apache.poi.ss.formula.functions.FreeRefFunction.evaluate.
private static Double	evaluateValue(ValueEval arg, int srcRowIndex, int srcColumnIndex)

Inherited from org.apache.poi.ss.formula.functions.Fixed1ArgFunction:: evaluate

instance	back to summary
public static final NormSDist instance

NormSDist	back to summary
private NormSDist()

evaluate back to summary

evaluate	back to summary
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1) Implements org.apache.poi.ss.formula.functions.Function1Arg.evaluate. Doc from org.apache.poi.ss.formula.functions.Function1Arg.evaluate. see `Function#evaluate(ValueEval[], int, int)` Annotations @Override

public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1)

Annotations

evaluate back to summary

evaluate	back to summary
public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec) Implements org.apache.poi.ss.formula.functions.FreeRefFunction.evaluate. Parameters args:ValueEval[] Doc from org.apache.poi.ss.formula.functions.FreeRefFunction.evaluate. the pre-evaluated arguments for this function. args is never `null`, nor are any of its elements. ec:OperationEvaluationContext Doc from org.apache.poi.ss.formula.functions.FreeRefFunction.evaluate. primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals. Returns:ValueEval Doc from org.apache.poi.ss.formula.functions.FreeRefFunction.evaluate. never `null`. Possibly an instance of `ErrorEval` in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors). Annotations @Override

Parameters

args:ValueEval[]

the pre-evaluated arguments for this function. args is never null, nor are any of its elements.

primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals.

never null. Possibly an instance of ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).

Annotations

evaluateValue	back to summary
private static Double evaluateValue(ValueEval arg, int srcRowIndex, int srcColumnIndex) throws EvaluationException