New to Telerik Document Processing? Start a free 30-day trial

IsNA

Class

Tests whether a value is the #N/A error and returns TRUE for #N/A errors, FALSE otherwise.

Definition

Namespace:Telerik.Documents.Spreadsheet.Expressions.Functions

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class IsNA : FunctionBase

Inheritance: objectFunctionBaseIsNA

Inherited Members FunctionBase.IsSpillingArgument(int, RadExpression)FunctionBase.Evaluate(FunctionEvaluationContext<RadExpression>)FunctionBase.EvaluateLiftedElement(FunctionEvaluationContext<RadExpression>, RadExpression[], int, int)FunctionBase.IsArgumentNumberValid(int)FunctionBase.ArgumentConversionRules

Constructors

IsNA()

Initializes a new ISNA function instance for testing whether values are the #N/A error.

public IsNA()

Fields

FunctionName

string

The name of the function.

public static readonly string FunctionName

Properties

FunctionInfo

Gets metadata describing the function's category, parameters, and localization keys.

public override FunctionInfo FunctionInfo { get; }

Property Value:

The function info as FunctionInfo.

Overrides: FunctionBase.FunctionInfo

When true, FunctionBase automatically evaluates this function element-wise over any multi-element array argument and returns a spilled array result. Override to true in pure scalar functions (e.g. ABS, LEN, MOD) where applying the function independently to each element of an input array is the correct dynamic-array behavior. Leave false (the default) for reducers.

public override bool LiftsOverArrays { get; }

Overrides: FunctionBase.LiftsOverArrays

Name

string

Gets the function name identifier used in formulas.

public override string Name { get; }

Property Value:

The name as String.

Overrides: FunctionBase.Name

Methods

EvaluateOverride(FunctionEvaluationContext<RadExpression>)

Evaluates the function and returns TRUE if the argument is specifically the #N/A error, FALSE otherwise.

protected override RadExpression EvaluateOverride(FunctionEvaluationContext<RadExpression> context)

Parameters:contextFunctionEvaluationContext<RadExpression>

The context.

Returns:

RadExpression

Function result as RadExpression.

Overrides: FunctionBase.EvaluateOverride(FunctionEvaluationContext<RadExpression>)