[]
Represents a reference in formula.
public sealed class Reference : IEquatable<Reference>, ICloneable
Public NotInheritable Class Reference
Implements IEquatable(Of Reference), ICloneable
Name | Description |
---|---|
Reference() |
Name | Description |
---|---|
Column | Gets or sets the 0-based column index. The default value is 0. |
HasColumn | Indicates whether the reference has column. The default value is true. |
HasRow | Gets or sets whether the reference has row. The default value is true. |
IsColumnRelative | Gets or sets whether the column is relative. The default value is true. |
IsError | Gets or sets whether the reference contains error. The default value is false. |
IsLastColumnRelative | Gets or sets whether the last column is relative. The default value is true. |
IsLastRowRelative | Gets or sets whether the last row is absolute. The default value is true. |
IsRange | Gets or sets whether the reference is range. The default value is false. |
IsRowRelative | Gets or sets whether the row is relative. The default value is true. |
LastColumn | Gets or sets the end column index. The default value is 0. |
LastRow | Gets or sets the 0-based end row index. The default value is 0. |
LastWorksheetName | The name of the end worksheet of the 3D reference. |
Row | Gets or sets the 0-based row index. The default value is 0. |
Workbook | Gets or sets the external workbook reference.
The default value is null ( |
WorksheetName | The name of the worksheet. |
Name | Description |
---|---|
Clone() | Copy the reference. |
Equals(Reference) | Equality comparison. |
Equals(object) | Equality comparison for late binding. |
GetHashCode() | This object doesn't support getting hash code, because all fields are mutable. |
ToString() | Converts the reference to A1 string. |
ToString(UnParseContext) | Converts the reference to string. |