GrapeCity.CalcEngine.RangeReference
RangeReference Struct
Represents a contextual range reference.
Namespace: GrapeCity.CalcEngine
Assembly: GrapeCity.CalcEngine.dll
Syntax
public struct RangeReference : IEquatable<RangeReference>, IComparable<RangeReference>Public Structure RangeReference
Implements IEquatable(Of RangeReference), IComparable(Of RangeReference)Constructors
| Name | Description |
|---|---|
| RangeReference(CellReference, CellReference) | Initializes a new instance of the RangeReference struct. |
| RangeReference(int, int, CellRelation) | Initializes a new instance of the RangeReference struct. |
| RangeReference(int, int, CellRelation, int, int, CellRelation) | Initializes a new instance of the RangeReference struct. |
| RangeReference(int, int, int, int) | Initializes a new instance of the RangeReference struct. |
Fields
| Name | Description |
|---|---|
| Empty | Represents an empty RangeReference value. |
Properties
| Name | Description |
|---|---|
| BottomRight | Gets the bottom-right cell reference. |
| Column | Gets the index of the left column. |
| Column2 | Gets the index of the right column. |
| IsWholeColumn | Gets a value indicating whether this instance is whole column. |
| IsWholeRow | Gets a value indicating whether this instance is whole row. |
| Relation | Gets the relative of the top left cell with the source. |
| Relation2 | Gets the relative of the bottom right cell with the source. |
| Row | Gets the index of the top row. |
| Row2 | Gets the index of the bottom row. |
| TopLeft | Gets the top-left cell reference. |
Methods
| Name | Description |
|---|---|
| CompareTo(RangeReference) | Compares the current RangeReference with another RangeReference. |
| Equals(RangeReference) | Indicates whether the current RangeReference is equal to another RangeReference of the same type. |
| Equals(object) | Determines whether the specified object is equal to this instance. |
| GetHashCode() | Returns a hash code for this instance. |
| IntersectWith(ref RangeReference) | Intersects this RangeReference range with the specified RangeReference range. |
| IsEmpty() | Determines whether this instance is empty. |
| IsIntersected(ref RangeReference) | Determines whether this reference is intersected with the specified reference. |
| IsIntersected(int, int, int, int) | Determines whether this reference is intersected with the specified reference. |
| IsOneCell() | Gets a value indicating whether this reference is one cell. |
| Offset(int, int) | Translates this RangeReference by the specified amount. |
| ReorderAbsolute() | Reorders an aboslute range reference. |
| SwitchReferenceType() | Switch the reference type of this CellReference. |
| SwitchReferenceType(CellRelation) | Switch the reference type of this CellReference to the specified. |
| ToAbsolute() | Removes relate reference flag(s) to get the absolute reference. |
| ToAbsolute(int, int) | Returns the absolute reference of the RangeReference object which relates with the context cell
(specified by |
| ToContextWithoutReorder(int, int) | Returns the target reference of the RangeReference object which relates with the context cell
(specified by |
| ToRelative(int, int) | Returns the target reference of the RangeReference object which relates with the context cell
(specified by |