Reference Struct

Represents a reference to a range of cells.

Implements

Namespace: GrapeCity.Spreadsheet

Assembly: GrapeCity.Spreadsheet.dll

Syntax

public struct Reference : IComparable<Reference>, IEquatable<Reference>

Public Structure Reference
    Implements IComparable(Of Reference), IEquatable(Of Reference)

Constructors

Name	Description
Reference(int, int)	Initializes a new instance of the Reference class.
Reference(int, int, int, int)	Initializes a new instance of the Reference class.
Reference(string)	Initializes a new instance of the Reference class.

Fields

Name	Description
Empty	Returns the empty value of Reference struct.

Properties

Name	Description
BottomRight	Gets the bottom right cell of this Reference value.
Column	Gets the left column index.
Column2	Gets the right column index.
ColumnCount	Gets the totals column count.
Row	Gets the top row index.
Row2	Gets the bottom row index.
RowCount	Gets the totals row count.
TopLeft	Gets the top left cell of this Reference value.

Methods

Name	Description
CompareTo(Reference)	Compares the current instance with another object of the same type and returns an integer that indicates whether the current instance precedes, follows, or occurs in the same position in the sort order as the other object.
Contains(int, int)	Determines whether this reference contains the specified cell.
Equals(Reference)	Indicates whether the current object is equal to another object of the same type.
Equals(ref Reference)	Indicates whether the current object is equal to another object of the same type.
Equals(object)	Determines whether the specified object is equal to this reference.
GetHashCode()	Returns a hash code for this instance.
IntersectWith(Reference)	Intersects this Reference range with the specified Reference range.
IntersectWith(ref Reference)	Intersects this Reference range with the specified Reference range.
IsEmpty()	Determines whether this reference is empty.
IsIntersected(ref Reference)	Determines whether this reference is intersected with the specified reference.
IsIntersected(int, int)	Determines whether this reference is intersected with the specified cell.
IsIntersected(int, int, int, int)	Determines whether this reference is intersected with the specified reference.
IsIntersectedWith(Reference[])	Determines whether this reference is intersected with the specified references.
IsOneCell()	Gets a value indicating whether this reference is one cell.
IsOverlapped(int, int, int, int)	Determines whether this reference is overlapped by the specified range.
Offset(int, int)	Translates this RangeReference by the specified amount.
Overlaps(Reference)	Determines whether this reference overlaps the specified range.
Overlaps(int, int, int, int)	Determines whether this reference overlaps the specified range.
ToString()	Returns a string that represents this instance.
Union(Reference)	Unions the current Reference with the specified reference.
Union(int, int)	Unions the current Reference with the specified reference.
Union(int, int, int, int)	Unions the current Reference with the specified reference.
Xor(Reference, Reference)	Computes the difference of two Reference. Difference of two Reference can produce a maximum of four Reference.If the two Reference do not intersect a zero-length array is returned.

Operators

Name	Description
implicit operator Reference(RangeReference)	Performs an implicit conversion from RangeReference to Reference.
implicit operator RangeReference(Reference)	Performs an implicit conversion from Reference to RangeReference.