# GrapeCity.Documents.Excel.Expressions.Reference

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="GrapeCity_Documents_Excel_Expressions_Reference" data-uid="GrapeCity.Documents.Excel.Expressions.Reference" class="text-break">Reference Class
</h1>
  <div class="markdown level0 summary"><p>Represents a reference in formula.</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">Reference</span></div>
  </div>
  <div class="implements">
    <h5>Implements</h5>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.iequatable-1">IEquatable</a>&lt;<a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.html">Reference</a>&gt;</div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.icloneable">ICloneable</a></div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Documents.Excel.Expressions.html">GrapeCity.Documents.Excel.Expressions</a></h6>
  <h6><strong>Assembly</strong>: DS.Documents.Excel.dll</h6>
  <h5 id="GrapeCity_Documents_Excel_Expressions_Reference_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public sealed class Reference : IEquatable&lt;Reference&gt;, ICloneable</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public NotInheritable Class Reference
    Implements IEquatable(Of Reference), ICloneable</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_Documents_Excel_Expressions_Reference__ctor" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.#ctor">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.-ctor.html#GrapeCity_Documents_Excel_Expressions_Reference__ctor">Reference()</a>
        </td>
        <td class="markdown level1 summary"></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_Documents_Excel_Expressions_Reference_Column" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.Column">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.Column.html#GrapeCity_Documents_Excel_Expressions_Reference_Column">Column</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the 0-based column index.
The default value is 0.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_HasColumn" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.HasColumn">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.HasColumn.html#GrapeCity_Documents_Excel_Expressions_Reference_HasColumn">HasColumn</a>
        </td>
        <td class="markdown level1 summary"><p>Indicates whether the reference has column.
The default value is <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">true</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_HasRow" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.HasRow">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.HasRow.html#GrapeCity_Documents_Excel_Expressions_Reference_HasRow">HasRow</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the reference has row.
The default value is <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">true</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_IsColumnRelative" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.IsColumnRelative">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.IsColumnRelative.html#GrapeCity_Documents_Excel_Expressions_Reference_IsColumnRelative">IsColumnRelative</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the column is relative.
The default value is <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">true</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_IsError" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.IsError">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.IsError.html#GrapeCity_Documents_Excel_Expressions_Reference_IsError">IsError</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the reference contains error.
The default value is <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">false</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_IsLastColumnRelative" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.IsLastColumnRelative">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.IsLastColumnRelative.html#GrapeCity_Documents_Excel_Expressions_Reference_IsLastColumnRelative">IsLastColumnRelative</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the last column is relative.
The default value is <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">true</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_IsLastRowRelative" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.IsLastRowRelative">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.IsLastRowRelative.html#GrapeCity_Documents_Excel_Expressions_Reference_IsLastRowRelative">IsLastRowRelative</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the last row is absolute.
The default value is <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">true</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_IsRange" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.IsRange">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.IsRange.html#GrapeCity_Documents_Excel_Expressions_Reference_IsRange">IsRange</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the reference is range.
The default value is <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">false</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_IsRowRelative" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.IsRowRelative">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.IsRowRelative.html#GrapeCity_Documents_Excel_Expressions_Reference_IsRowRelative">IsRowRelative</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the row is relative.
The default value is <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">true</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_LastColumn" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.LastColumn">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.LastColumn.html#GrapeCity_Documents_Excel_Expressions_Reference_LastColumn">LastColumn</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the end column index.
The default value is 0.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_LastRow" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.LastRow">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.LastRow.html#GrapeCity_Documents_Excel_Expressions_Reference_LastRow">LastRow</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the 0-based end row index.
The default value is 0.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_LastWorksheetName" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.LastWorksheetName">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.LastWorksheetName.html#GrapeCity_Documents_Excel_Expressions_Reference_LastWorksheetName">LastWorksheetName</a>
        </td>
        <td class="markdown level1 summary"><p>The name of the end worksheet of the 3D reference.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_Row" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.Row">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.Row.html#GrapeCity_Documents_Excel_Expressions_Reference_Row">Row</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the 0-based row index.
The default value is 0.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_Workbook" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.Workbook">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.Workbook.html#GrapeCity_Documents_Excel_Expressions_Reference_Workbook">Workbook</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the external workbook reference.
The default value is <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/keywords/null">null</a> (<code>Nothing</code>).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_WorksheetName" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.WorksheetName">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.WorksheetName.html#GrapeCity_Documents_Excel_Expressions_Reference_WorksheetName">WorksheetName</a>
        </td>
        <td class="markdown level1 summary"><p>The name of the worksheet.</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_Documents_Excel_Expressions_Reference_Clone" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.Clone">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.Clone.html#GrapeCity_Documents_Excel_Expressions_Reference_Clone">Clone()</a>
        </td>
        <td class="markdown level1 summary"><p>Copy the reference.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_Equals_GrapeCity_Documents_Excel_Expressions_Reference_" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.Equals(GrapeCity.Documents.Excel.Expressions.Reference)">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.Equals.html#GrapeCity_Documents_Excel_Expressions_Reference_Equals_GrapeCity_Documents_Excel_Expressions_Reference_">Equals(Reference)</a>
        </td>
        <td class="markdown level1 summary"><p>Equality comparison.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_Equals_System_Object_" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.Equals(System.Object)">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.Equals.html#GrapeCity_Documents_Excel_Expressions_Reference_Equals_System_Object_">Equals(object)</a>
        </td>
        <td class="markdown level1 summary"><p>Equality comparison for late binding.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_GetHashCode" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.GetHashCode">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.GetHashCode.html#GrapeCity_Documents_Excel_Expressions_Reference_GetHashCode">GetHashCode()</a>
        </td>
        <td class="markdown level1 summary"><p>This object doesn't support getting hash code, because all fields are mutable.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_ToString" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.ToString">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.ToString.html#GrapeCity_Documents_Excel_Expressions_Reference_ToString">ToString()</a>
        </td>
        <td class="markdown level1 summary"><p>Converts the reference to A1 string.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_Expressions_Reference_ToString_GrapeCity_Documents_Excel_Expressions_UnParseContext_" data-uid="GrapeCity.Documents.Excel.Expressions.Reference.ToString(GrapeCity.Documents.Excel.Expressions.UnParseContext)">
          <a class="xref" href="GrapeCity.Documents.Excel.Expressions.Reference.ToString.html#GrapeCity_Documents_Excel_Expressions_Reference_ToString_GrapeCity_Documents_Excel_Expressions_UnParseContext_">ToString(UnParseContext)</a>
        </td>
        <td class="markdown level1 summary"><p>Converts the reference to string.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>
