Class FormulaCellValue

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

Inheritance
System.Object
CellValueBase<RadExpression>
FormulaCellValue
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Windows.Documents.Spreadsheet.Model
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public class FormulaCellValue : CellValueBase<RadExpression>, ICellValue, ICopyable<FormulaCellValue>

Properties

RawValue

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

Declaration
public override string RawValue { get; }
Property Value
System.String

The raw value.
Overrides
Telerik.Windows.Documents.Spreadsheet.Model.CellValueBase<Telerik.Windows.Documents.Spreadsheet.Expressions.RadExpression>.RawValue

ResultValueType

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

Declaration
public override CellValueType ResultValueType { get; }
Property Value
CellValueType

The type of the result value.
Overrides
Telerik.Windows.Documents.Spreadsheet.Model.CellValueBase<Telerik.Windows.Documents.Spreadsheet.Expressions.RadExpression>.ResultValueType

ValueType

Returns CellValueType.Formula.

Declaration
public override CellValueType ValueType { get; }
Property Value
CellValueType

The type of the value.
Overrides
Telerik.Windows.Documents.Spreadsheet.Model.CellValueBase<Telerik.Windows.Documents.Spreadsheet.Expressions.RadExpression>.ValueType

Methods

Equals(Object)

Determines whether the specified System.Object is equal to the current System.Object.

Declaration
public override bool Equals(object obj)
Parameters
System.Object obj

The System.Object to compare with the current System.Object.
Returns
System.Boolean

True if the specified System.Object is equal to the current System.Object; otherwise, false.
Overrides
Telerik.Windows.Documents.Spreadsheet.Model.CellValueBase<Telerik.Windows.Documents.Spreadsheet.Expressions.RadExpression>.Equals(System.Object)

GetHashCode()

Serves as a hash function for a particular type.

Declaration
public override int GetHashCode()
Returns
System.Int32

A hash code for the current System.Object.
Overrides
Telerik.Windows.Documents.Spreadsheet.Model.CellValueBase<Telerik.Windows.Documents.Spreadsheet.Expressions.RadExpression>.GetHashCode()

GetResultValueAsCellValue()

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

Declaration
public ICellValue GetResultValueAsCellValue()
Returns
ICellValue

The cell value.

GetResultValueAsString(CellValueFormat)

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

Declaration
public override string GetResultValueAsString(CellValueFormat format)
Parameters
CellValueFormat format

The format.
Returns
System.String

The result value string.
Overrides
Telerik.Windows.Documents.Spreadsheet.Model.CellValueBase<Telerik.Windows.Documents.Spreadsheet.Expressions.RadExpression>.GetResultValueAsString(Telerik.Windows.Documents.Spreadsheet.Model.CellValueFormat)

GetValueAsStringOverride(CellValueFormat)

Gets the value as string override.

Declaration
protected override string GetValueAsStringOverride(CellValueFormat format = null)
Parameters
CellValueFormat format

The format.
Returns
System.String

The value as string.
Overrides
Telerik.Windows.Documents.Spreadsheet.Model.CellValueBase<Telerik.Windows.Documents.Spreadsheet.Expressions.RadExpression>.GetValueAsStringOverride(Telerik.Windows.Documents.Spreadsheet.Model.CellValueFormat)