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

IsBlank

Class

Tests whether a cell reference is empty and returns TRUE for blank cells, FALSE otherwise.

Definition

Namespace:Telerik.Documents.Spreadsheet.Expressions.Functions

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class IsBlank : FunctionBase

Inheritance: objectFunctionBaseIsBlank

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

Constructors

IsBlank()

Initializes a new ISBLANK function instance for testing whether cells are empty.

public IsBlank()

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 an empty cell or empty expression, 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>)