Class
FormulaCellValue

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:

cs-api-definition

public class FormulaCellValue : CellValueBase<RadExpression>, ICellValue

Inheritance: objectCellValueBase<RadExpression>FormulaCellValue

Implements: ICellValue

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

Properties

RawValue

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

Declaration

cs-api-definition

public override string RawValue { get; }

Property Value

string

The raw value.

Overrides CellValueBase<RadExpression>.RawValue

ResultValueType

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

Declaration

cs-api-definition

public override CellValueType ResultValueType { get; }

Property Value

CellValueType

The type of the result value.

Overrides CellValueBase<RadExpression>.ResultValueType

ValueType

Returns CellValueType.Formula.

Declaration

cs-api-definition

public override CellValueType ValueType { get; }

Property Value

CellValueType

The type of the value.

Overrides CellValueBase<RadExpression>.ValueType

Methods

Equals(object)

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

Declaration

cs-api-definition

public override bool Equals(object obj)

Parameters

obj

object

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()

Serves as a hash function for a particular type.

Declaration

cs-api-definition

public override int GetHashCode()

Returns

int

A hash code for the current object.

Overrides CellValueBase<RadExpression>.GetHashCode()

GetResultValueAsCellValue()

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

Declaration

cs-api-definition

public ICellValue GetResultValueAsCellValue()

Returns

ICellValue

The cell value.

GetResultValueAsString(CellValueFormat)

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

Declaration

cs-api-definition

public override string GetResultValueAsString(CellValueFormat format)

Parameters

format

CellValueFormat

The format.

Returns

string

The result value string.

Overrides CellValueBase<RadExpression>.GetResultValueAsString(CellValueFormat)

GetValueAsStringOverride(CellValueFormat)

Gets the value as string override.

Declaration

cs-api-definition

protected override string GetValueAsStringOverride(CellValueFormat format = null)

Parameters

format

CellValueFormat

The format.

Returns

string

The value as string.

Overrides CellValueBase<RadExpression>.GetValueAsStringOverride(CellValueFormat)

ClassFormulaCellValue

Class
FormulaCellValue