# GrapeCity.Spreadsheet.ExternalVariable

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="GrapeCity_Spreadsheet_ExternalVariable" data-uid="GrapeCity.Spreadsheet.ExternalVariable" class="text-break">ExternalVariable Class
</h1>
  <div class="markdown level0 summary"><p>Represents a external variable.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <div class="inheritance">
    <h5>Inheritance</h5>
    <div class="level0"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></div>
    <div class="level1"><span class="xref">DefinedName</span></div>
    <div class="level2"><span class="xref">ExternalVariable</span></div>
  </div>
  <div class="implements">
    <h5>Implements</h5>
    <div><a class="xref" href="GrapeCity.Spreadsheet.IName.html">IName</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.iequatable-1">IEquatable</a>&lt;<span class="xref">DefinedName</span>&gt;</div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.icomparable">IComparable</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.icomparable-1">IComparable</a>&lt;<a class="xref" href="GrapeCity.Spreadsheet.IName.html">IName</a>&gt;</div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Spreadsheet.html">GrapeCity.Spreadsheet</a></h6>
  <h6><strong>Assembly</strong>: GrapeCity.Spreadsheet.dll</h6>
  <h5 id="GrapeCity_Spreadsheet_ExternalVariable_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public class ExternalVariable : DefinedName, IName, IEquatable&lt;DefinedName&gt;, IComparable, IComparable&lt;IName&gt;</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Class ExternalVariable
    Inherits DefinedName
    Implements IName, IEquatable(Of DefinedName), IComparable, IComparable(Of IName)</code></pre>
  </div>
  <h3 id="constructors">Constructors
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable__ctor" data-uid="GrapeCity.Spreadsheet.ExternalVariable.#ctor">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.-ctor.html#GrapeCity_Spreadsheet_ExternalVariable__ctor">ExternalVariable()</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.html">ExternalVariable</a> class.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable__ctor_System_Boolean_" data-uid="GrapeCity.Spreadsheet.ExternalVariable.#ctor(System.Boolean)">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.-ctor.html#GrapeCity_Spreadsheet_ExternalVariable__ctor_System_Boolean_">ExternalVariable(bool)</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.html">ExternalVariable</a> class.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_Column" data-uid="GrapeCity.Spreadsheet.ExternalVariable.Column">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.Column.html#GrapeCity_Spreadsheet_ExternalVariable_Column">Column</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the context column for evaluating.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_ContextWorksheet" data-uid="GrapeCity.Spreadsheet.ExternalVariable.ContextWorksheet">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.ContextWorksheet.html#GrapeCity_Spreadsheet_ExternalVariable_ContextWorksheet">ContextWorksheet</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the context worksheet to evaluate.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_EvaluationContext" data-uid="GrapeCity.Spreadsheet.ExternalVariable.EvaluationContext">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.EvaluationContext.html#GrapeCity_Spreadsheet_ExternalVariable_EvaluationContext">EvaluationContext</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the global shared evaluation context.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_IsVolatile" data-uid="GrapeCity.Spreadsheet.ExternalVariable.IsVolatile">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.IsVolatile.html#GrapeCity_Spreadsheet_ExternalVariable_IsVolatile">IsVolatile</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a boolean value indicating whether this external variable is volatile.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_Name" data-uid="GrapeCity.Spreadsheet.ExternalVariable.Name">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.Name.html#GrapeCity_Spreadsheet_ExternalVariable_Name">Name</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the name of the defined name.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_Row" data-uid="GrapeCity.Spreadsheet.ExternalVariable.Row">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.Row.html#GrapeCity_Spreadsheet_ExternalVariable_Row">Row</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the context row for evaluating.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_Value" data-uid="GrapeCity.Spreadsheet.ExternalVariable.Value">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.Value.html#GrapeCity_Spreadsheet_ExternalVariable_Value">Value</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the value of this external variable.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="methods">Methods
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_ChangeExpression_GrapeCity_CalcEngine_Expression_" data-uid="GrapeCity.Spreadsheet.ExternalVariable.ChangeExpression(GrapeCity.CalcEngine.Expression)">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.ChangeExpression.html#GrapeCity_Spreadsheet_ExternalVariable_ChangeExpression_GrapeCity_CalcEngine_Expression_">ChangeExpression(Expression)</a>
        </td>
        <td class="markdown level1 summary"><p>Changes the expression.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_DeleteCore" data-uid="GrapeCity.Spreadsheet.ExternalVariable.DeleteCore">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.DeleteCore.html#GrapeCity_Spreadsheet_ExternalVariable_DeleteCore">DeleteCore()</a>
        </td>
        <td class="markdown level1 summary"><p>Designates this external variable to be deleted.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_Dirty" data-uid="GrapeCity.Spreadsheet.ExternalVariable.Dirty">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.Dirty.html#GrapeCity_Spreadsheet_ExternalVariable_Dirty">Dirty()</a>
        </td>
        <td class="markdown level1 summary"><p>Notifies the calculation engine that the value of this external variable is changed.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_EvaluateCore_GrapeCity_CalcEngine_IEvaluationContext_GrapeCity_CalcEngine_IValue_" data-uid="GrapeCity.Spreadsheet.ExternalVariable.EvaluateCore(GrapeCity.CalcEngine.IEvaluationContext,GrapeCity.CalcEngine.IValue)">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.EvaluateCore.html#GrapeCity_Spreadsheet_ExternalVariable_EvaluateCore_GrapeCity_CalcEngine_IEvaluationContext_GrapeCity_CalcEngine_IValue_">EvaluateCore(IEvaluationContext, IValue)</a>
        </td>
        <td class="markdown level1 summary"><p>Evaluates the result of this external variable.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_GetHashCode" data-uid="GrapeCity.Spreadsheet.ExternalVariable.GetHashCode">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.GetHashCode.html#GrapeCity_Spreadsheet_ExternalVariable_GetHashCode">GetHashCode()</a>
        </td>
        <td class="markdown level1 summary"><p>Returns a hash code for this instance.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_IsAbsoluteReferencePreferred" data-uid="GrapeCity.Spreadsheet.ExternalVariable.IsAbsoluteReferencePreferred">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.IsAbsoluteReferencePreferred.html#GrapeCity_Spreadsheet_ExternalVariable_IsAbsoluteReferencePreferred">IsAbsoluteReferencePreferred()</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a boolean value indicating whether the external variable prefers all absolute references.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_IsRequiredNumberFormat" data-uid="GrapeCity.Spreadsheet.ExternalVariable.IsRequiredNumberFormat">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.IsRequiredNumberFormat.html#GrapeCity_Spreadsheet_ExternalVariable_IsRequiredNumberFormat">IsRequiredNumberFormat()</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether the external variable depends on the format of cells.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_IsUndefined" data-uid="GrapeCity.Spreadsheet.ExternalVariable.IsUndefined">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.IsUndefined.html#GrapeCity_Spreadsheet_ExternalVariable_IsUndefined">IsUndefined()</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether this external variable is undefined.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_OnDirtied" data-uid="GrapeCity.Spreadsheet.ExternalVariable.OnDirtied">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.OnDirtied.html#GrapeCity_Spreadsheet_ExternalVariable_OnDirtied">OnDirtied()</a>
        </td>
        <td class="markdown level1 summary"><p>Designates this external variable to be recalculated when the next recalculation occurs.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_OnDirtying" data-uid="GrapeCity.Spreadsheet.ExternalVariable.OnDirtying">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.OnDirtying.html#GrapeCity_Spreadsheet_ExternalVariable_OnDirtying">OnDirtying()</a>
        </td>
        <td class="markdown level1 summary"><p>Designates this external variable to be recalculated when the next recalculation occurs.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ExternalVariable_Volatile_System_Boolean_" data-uid="GrapeCity.Spreadsheet.ExternalVariable.Volatile(System.Boolean)">
          <a class="xref" href="GrapeCity.Spreadsheet.ExternalVariable.Volatile.html#GrapeCity_Spreadsheet_ExternalVariable_Volatile_System_Boolean_">Volatile(bool)</a>
        </td>
        <td class="markdown level1 summary"><p>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.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="seealso">See Also</h3>
  <div class="seealso">
      <div><span class="xref">DefinedName</span></div>
  </div>

</div>
