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

FormulaCellValue

Class

Cell value for formula expressions that calculate dynamically; holds the expression tree and recalculates when dependencies change.

Definition

Namespace:Telerik.Windows.Documents.Spreadsheet.Model

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class FormulaCellValue : CellValueBase<RadExpression>, ICellValue

Inheritance: objectCellValueBase<RadExpression>FormulaCellValue

Implements: ICellValue

Inherited Members CellValueBase<RadExpression>.GetValueAsString(CellValueFormat)CellValueBase<RadExpression>.InvalidateEditFormatString()CellValueBase<RadExpression>.Value

Methods

Equals(object)

bool

Determines whether the specified object is equal to the current object.

public override bool Equals(object obj)

Parameters:objobject

The object to compare with the current object.

Returns:

bool

True if the specified object is equal to the current object; otherwise, false.

Overrides: CellValueBase<RadExpression>.Equals(object)

GetHashCode()

int

Serves as a hash function for a particular type.

public override int GetHashCode()

Returns:

int

A hash code for the current object.

Overrides: CellValueBase<RadExpression>.GetHashCode()

GetResultValueAsCellValue()

ICellValue

Evaluates the formula expression and returns the calculated result as a cell value.

public ICellValue GetResultValueAsCellValue()

Returns:

ICellValue

The cell value.

GetResultValueAsString(CellValueFormat)

string

Evaluates the formula and returns the result formatted as a string.

public override string GetResultValueAsString(CellValueFormat format)

Parameters:formatCellValueFormat

The format.

Returns:

string

The result value string.

Overrides: CellValueBase<RadExpression>.GetResultValueAsString(CellValueFormat)

GetValueAsStringOverride(CellValueFormat)

string

Gets the value as string override.

protected override string GetValueAsStringOverride(CellValueFormat format = null)

Parameters:formatCellValueFormat

The format.

Returns:

string

The value as string.

Overrides: CellValueBase<RadExpression>.GetValueAsStringOverride(CellValueFormat)

Properties

RawValue

string

Formula string as entered by the user (e.g., "=SUM(A1:A10)").

public override string RawValue { get; }

Property Value:

The raw value.

Overrides: CellValueBase<RadExpression>.RawValue

ResultValueType

CellValueType

Type of the calculated result after the formula evaluates (e.g., Number, Text, Error).

public override CellValueType ResultValueType { get; }

Property Value:

The type of the result value.

Overrides: CellValueBase<RadExpression>.ResultValueType

ValueType

CellValueType

Returns CellValueType.Formula.

public override CellValueType ValueType { get; }

Property Value:

The type of the value.

Overrides: CellValueBase<RadExpression>.ValueType