GrapeCity.Documents.Excel.Expressions.Reference
Reference Class
Represents a reference in formula.
Namespace: GrapeCity.Documents.Excel.Expressions
Assembly: DS.Documents.Excel.dll
Syntax
public sealed class Reference : IEquatable<Reference>, ICloneablePublic NotInheritable Class Reference
Implements IEquatable(Of Reference), ICloneableConstructors
| Name | Description |
|---|---|
| Reference() |
Properties
| 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. |
Methods
| 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. |