- GrapeCity.CalcEngine Assembly
-
GrapeCity.Spreadsheet Assembly
- GrapeCity.CalcEngine
- GrapeCity.Core
- GrapeCity.Drawing
-
GrapeCity.Spreadsheet
- Classes
-
Structs
- ActionResult<T>
- Alignment
- AutoFilterColumn
- Border
- BorderLine
- Break
- CellProtection
- CellReference
- CfExecutedResult
- CfIcon
- CfValue
- Color
- CustomFilterCriteria
- DataValidationExecutedResult
- DataValidationSuggestionItem
- DateGroupItem
- Fill
- FormatResult
- GradientFillEffect
- GradientStop
- NumberFormat
- Reference
- StyleFormat
- TableStyleElement
- WorksheetReference
- Enums
- Interfaces
- GrapeCity.Spreadsheet.Charts
- GrapeCity.Spreadsheet.Commands
- GrapeCity.Spreadsheet.Data
- GrapeCity.Spreadsheet.Drawing
- GrapeCity.Spreadsheet.FormControls
- GrapeCity.Spreadsheet.IO
- GrapeCity.Spreadsheet.IO.OpenXml
- GrapeCity.Spreadsheet.Localization
- GrapeCity.Spreadsheet.Printing
- GrapeCity.Spreadsheet.UI
- GrapeCity.Wpf.SpreadSheet Assembly
- GrapeCity.Wpf.Spreadsheet.CellType Assembly
GrapeCity.Spreadsheet.Reference
Reference Struct
Represents a reference to a range of cells.
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
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. |