# GrapeCity.CalcEngine.RangeReference

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="GrapeCity_CalcEngine_RangeReference" data-uid="GrapeCity.CalcEngine.RangeReference" class="text-break">RangeReference Struct
</h1>
  <div class="markdown level0 summary"><p>Represents a contextual range reference.</p>
</div>
  <div class="markdown level0 conceptual"></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.CalcEngine.RangeReference.html">RangeReference</a>&gt;</div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.icomparable-1">IComparable</a>&lt;<a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a>&gt;</div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.CalcEngine.html">GrapeCity.CalcEngine</a></h6>
  <h6><strong>Assembly</strong>: GrapeCity.CalcEngine.dll</h6>
  <h5 id="GrapeCity_CalcEngine_RangeReference_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public struct RangeReference : IEquatable&lt;RangeReference&gt;, IComparable&lt;RangeReference&gt;</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Structure RangeReference
    Implements IEquatable(Of RangeReference), IComparable(Of RangeReference)</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_CalcEngine_RangeReference__ctor_GrapeCity_CalcEngine_CellReference_GrapeCity_CalcEngine_CellReference_" data-uid="GrapeCity.CalcEngine.RangeReference.#ctor(GrapeCity.CalcEngine.CellReference,GrapeCity.CalcEngine.CellReference)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.-ctor.html#GrapeCity_CalcEngine_RangeReference__ctor_GrapeCity_CalcEngine_CellReference_GrapeCity_CalcEngine_CellReference_">RangeReference(CellReference, CellReference)</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> struct.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference__ctor_System_Int32_System_Int32_GrapeCity_CalcEngine_CellRelation_" data-uid="GrapeCity.CalcEngine.RangeReference.#ctor(System.Int32,System.Int32,GrapeCity.CalcEngine.CellRelation)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.-ctor.html#GrapeCity_CalcEngine_RangeReference__ctor_System_Int32_System_Int32_GrapeCity_CalcEngine_CellRelation_">RangeReference(int, int, CellRelation)</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> struct.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference__ctor_System_Int32_System_Int32_GrapeCity_CalcEngine_CellRelation_System_Int32_System_Int32_GrapeCity_CalcEngine_CellRelation_" data-uid="GrapeCity.CalcEngine.RangeReference.#ctor(System.Int32,System.Int32,GrapeCity.CalcEngine.CellRelation,System.Int32,System.Int32,GrapeCity.CalcEngine.CellRelation)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.-ctor.html#GrapeCity_CalcEngine_RangeReference__ctor_System_Int32_System_Int32_GrapeCity_CalcEngine_CellRelation_System_Int32_System_Int32_GrapeCity_CalcEngine_CellRelation_">RangeReference(int, int, CellRelation, int, int, CellRelation)</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> struct.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference__ctor_System_Int32_System_Int32_System_Int32_System_Int32_" data-uid="GrapeCity.CalcEngine.RangeReference.#ctor(System.Int32,System.Int32,System.Int32,System.Int32)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.-ctor.html#GrapeCity_CalcEngine_RangeReference__ctor_System_Int32_System_Int32_System_Int32_System_Int32_">RangeReference(int, int, int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> struct.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="fields">Fields
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_Empty" data-uid="GrapeCity.CalcEngine.RangeReference.Empty">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.Empty.html">Empty</a>
        </td>
        <td class="markdown level1 summary"><p>Represents an empty <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> value.</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_CalcEngine_RangeReference_BottomRight" data-uid="GrapeCity.CalcEngine.RangeReference.BottomRight">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.BottomRight.html#GrapeCity_CalcEngine_RangeReference_BottomRight">BottomRight</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the bottom-right cell reference.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_Column" data-uid="GrapeCity.CalcEngine.RangeReference.Column">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.Column.html#GrapeCity_CalcEngine_RangeReference_Column">Column</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the index of the left column.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_Column2" data-uid="GrapeCity.CalcEngine.RangeReference.Column2">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.Column2.html#GrapeCity_CalcEngine_RangeReference_Column2">Column2</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the index of the right column.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_IsWholeColumn" data-uid="GrapeCity.CalcEngine.RangeReference.IsWholeColumn">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.IsWholeColumn.html#GrapeCity_CalcEngine_RangeReference_IsWholeColumn">IsWholeColumn</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a value indicating whether this instance is whole column.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_IsWholeRow" data-uid="GrapeCity.CalcEngine.RangeReference.IsWholeRow">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.IsWholeRow.html#GrapeCity_CalcEngine_RangeReference_IsWholeRow">IsWholeRow</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a value indicating whether this instance is whole row.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_Relation" data-uid="GrapeCity.CalcEngine.RangeReference.Relation">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.Relation.html#GrapeCity_CalcEngine_RangeReference_Relation">Relation</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the relative of the top left cell with the source.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_Relation2" data-uid="GrapeCity.CalcEngine.RangeReference.Relation2">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.Relation2.html#GrapeCity_CalcEngine_RangeReference_Relation2">Relation2</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the relative of the bottom right cell with the source.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_Row" data-uid="GrapeCity.CalcEngine.RangeReference.Row">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.Row.html#GrapeCity_CalcEngine_RangeReference_Row">Row</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the index of the top row.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_Row2" data-uid="GrapeCity.CalcEngine.RangeReference.Row2">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.Row2.html#GrapeCity_CalcEngine_RangeReference_Row2">Row2</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the index of the bottom row.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_TopLeft" data-uid="GrapeCity.CalcEngine.RangeReference.TopLeft">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.TopLeft.html#GrapeCity_CalcEngine_RangeReference_TopLeft">TopLeft</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the top-left cell reference.</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_CalcEngine_RangeReference_CompareTo_GrapeCity_CalcEngine_RangeReference_" data-uid="GrapeCity.CalcEngine.RangeReference.CompareTo(GrapeCity.CalcEngine.RangeReference)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.CompareTo.html#GrapeCity_CalcEngine_RangeReference_CompareTo_GrapeCity_CalcEngine_RangeReference_">CompareTo(RangeReference)</a>
        </td>
        <td class="markdown level1 summary"><p>Compares the current <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> with another <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_Equals_GrapeCity_CalcEngine_RangeReference_" data-uid="GrapeCity.CalcEngine.RangeReference.Equals(GrapeCity.CalcEngine.RangeReference)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.Equals.html#GrapeCity_CalcEngine_RangeReference_Equals_GrapeCity_CalcEngine_RangeReference_">Equals(RangeReference)</a>
        </td>
        <td class="markdown level1 summary"><p>Indicates whether the current <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> is equal to another <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> of the same type.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_Equals_System_Object_" data-uid="GrapeCity.CalcEngine.RangeReference.Equals(System.Object)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.Equals.html#GrapeCity_CalcEngine_RangeReference_Equals_System_Object_">Equals(object)</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether the specified <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a> is equal to this instance.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_GetHashCode" data-uid="GrapeCity.CalcEngine.RangeReference.GetHashCode">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.GetHashCode.html#GrapeCity_CalcEngine_RangeReference_GetHashCode">GetHashCode()</a>
        </td>
        <td class="markdown level1 summary"><p>Returns a hash code for this instance.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_IntersectWith_GrapeCity_CalcEngine_RangeReference__" data-uid="GrapeCity.CalcEngine.RangeReference.IntersectWith(GrapeCity.CalcEngine.RangeReference@)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.IntersectWith.html#GrapeCity_CalcEngine_RangeReference_IntersectWith_GrapeCity_CalcEngine_RangeReference__">IntersectWith(ref RangeReference)</a>
        </td>
        <td class="markdown level1 summary"><p>Intersects this <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> range with the specified <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_IsEmpty" data-uid="GrapeCity.CalcEngine.RangeReference.IsEmpty">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.IsEmpty.html#GrapeCity_CalcEngine_RangeReference_IsEmpty">IsEmpty()</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether this instance is empty.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_IsIntersected_GrapeCity_CalcEngine_RangeReference__" data-uid="GrapeCity.CalcEngine.RangeReference.IsIntersected(GrapeCity.CalcEngine.RangeReference@)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.IsIntersected.html#GrapeCity_CalcEngine_RangeReference_IsIntersected_GrapeCity_CalcEngine_RangeReference__">IsIntersected(ref RangeReference)</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether this reference is intersected with the specified reference.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_IsIntersected_System_Int32_System_Int32_System_Int32_System_Int32_" data-uid="GrapeCity.CalcEngine.RangeReference.IsIntersected(System.Int32,System.Int32,System.Int32,System.Int32)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.IsIntersected.html#GrapeCity_CalcEngine_RangeReference_IsIntersected_System_Int32_System_Int32_System_Int32_System_Int32_">IsIntersected(int, int, int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether this reference is intersected with the specified reference.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_IsOneCell" data-uid="GrapeCity.CalcEngine.RangeReference.IsOneCell">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.IsOneCell.html#GrapeCity_CalcEngine_RangeReference_IsOneCell">IsOneCell()</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a value indicating whether this reference is one cell.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_Offset_System_Int32_System_Int32_" data-uid="GrapeCity.CalcEngine.RangeReference.Offset(System.Int32,System.Int32)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.Offset.html#GrapeCity_CalcEngine_RangeReference_Offset_System_Int32_System_Int32_">Offset(int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Translates this <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> by the specified amount.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_ReorderAbsolute" data-uid="GrapeCity.CalcEngine.RangeReference.ReorderAbsolute">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.ReorderAbsolute.html#GrapeCity_CalcEngine_RangeReference_ReorderAbsolute">ReorderAbsolute()</a>
        </td>
        <td class="markdown level1 summary"><p>Reorders an aboslute range reference.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_SwitchReferenceType" data-uid="GrapeCity.CalcEngine.RangeReference.SwitchReferenceType">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.SwitchReferenceType.html#GrapeCity_CalcEngine_RangeReference_SwitchReferenceType">SwitchReferenceType()</a>
        </td>
        <td class="markdown level1 summary"><p>Switch the reference type of this <a class="xref" href="GrapeCity.CalcEngine.CellReference.html">CellReference</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_SwitchReferenceType_GrapeCity_CalcEngine_CellRelation_" data-uid="GrapeCity.CalcEngine.RangeReference.SwitchReferenceType(GrapeCity.CalcEngine.CellRelation)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.SwitchReferenceType.html#GrapeCity_CalcEngine_RangeReference_SwitchReferenceType_GrapeCity_CalcEngine_CellRelation_">SwitchReferenceType(CellRelation)</a>
        </td>
        <td class="markdown level1 summary"><p>Switch the reference type of this <a class="xref" href="GrapeCity.CalcEngine.CellReference.html">CellReference</a> to the specified.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_ToAbsolute" data-uid="GrapeCity.CalcEngine.RangeReference.ToAbsolute">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.ToAbsolute.html#GrapeCity_CalcEngine_RangeReference_ToAbsolute">ToAbsolute()</a>
        </td>
        <td class="markdown level1 summary"><p>Removes relate reference flag(s) to get the absolute reference.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_ToAbsolute_System_Int32_System_Int32_" data-uid="GrapeCity.CalcEngine.RangeReference.ToAbsolute(System.Int32,System.Int32)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.ToAbsolute.html#GrapeCity_CalcEngine_RangeReference_ToAbsolute_System_Int32_System_Int32_">ToAbsolute(int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Returns the absolute reference of the <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> object which relates with the context cell
(specified by <code class="paramref">contextRow</code> and <code class="paramref">contextColumn</code>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_ToContextWithoutReorder_System_Int32_System_Int32_" data-uid="GrapeCity.CalcEngine.RangeReference.ToContextWithoutReorder(System.Int32,System.Int32)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.ToContextWithoutReorder.html#GrapeCity_CalcEngine_RangeReference_ToContextWithoutReorder_System_Int32_System_Int32_">ToContextWithoutReorder(int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Returns the target reference of the <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> object which relates with the context cell
(specified by <code class="paramref">contextRow</code> and <code class="paramref">contextColumn</code>.
Position state of the <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> is unchanged.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_RangeReference_ToRelative_System_Int32_System_Int32_" data-uid="GrapeCity.CalcEngine.RangeReference.ToRelative(System.Int32,System.Int32)">
          <a class="xref" href="GrapeCity.CalcEngine.RangeReference.ToRelative.html#GrapeCity_CalcEngine_RangeReference_ToRelative_System_Int32_System_Int32_">ToRelative(int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Returns the target reference of the <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> object which relates with the context cell
(specified by <code class="paramref">contextRow</code> and <code class="paramref">contextColumn</code>.
Position state of the <a class="xref" href="GrapeCity.CalcEngine.RangeReference.html">RangeReference</a> is unchanged.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>