GrapeCity.Spreadsheet.ExternalVariable

ExternalVariable Class

Represents a external variable.

DefinedName

ExternalVariable

IEquatable<DefinedName>

public class ExternalVariable : DefinedName, IName, IEquatable<DefinedName>, IComparable, IComparable<IName>

Public Class ExternalVariable
    Inherits DefinedName
    Implements IName, IEquatable(Of DefinedName), IComparable, IComparable(Of IName)

Name	Description
ExternalVariable()	Initializes a new instance of the ExternalVariable class.
ExternalVariable(bool)	Initializes a new instance of the ExternalVariable class.

Name	Description
Column	Gets the context column for evaluating.
ContextWorksheet	Gets the context worksheet to evaluate.
EvaluationContext	Gets the global shared evaluation context.
IsVolatile	Gets or sets a boolean value indicating whether this external variable is volatile.
Name	Gets or sets the name of the defined name.
Row	Gets the context row for evaluating.
Value	Gets the value of this external variable.

Name	Description
ChangeExpression(Expression)	Changes the expression.
DeleteCore()	Designates this external variable to be deleted.
Dirty()	Notifies the calculation engine that the value of this external variable is changed.
EvaluateCore(IEvaluationContext, IValue)	Evaluates the result of this external variable.
GetHashCode()	Returns a hash code for this instance.
IsAbsoluteReferencePreferred()	Gets a boolean value indicating whether the external variable prefers all absolute references.
IsRequiredNumberFormat()	Determines whether the external variable depends on the format of cells.
IsUndefined()	Determines whether this external variable is undefined.
OnDirtied()	Designates this external variable to be recalculated when the next recalculation occurs.
OnDirtying()	Designates this external variable to be recalculated when the next recalculation occurs.
Volatile(bool)	Marks this external variable as volatile. A volatile external variable must be recalculated whenever calculation occurs in any cells on the worksheet. A nonvolatile external variable is recalculated only when the input variables change.