[]
        
(Showing Draft Content)

GrapeCity.Documents.Excel.Expressions.Reference

Reference Class

Represents a reference in formula.

Inheritance
Reference
Namespace: GrapeCity.Documents.Excel.Expressions
Assembly: DS.Documents.Excel.dll
Syntax
public sealed class Reference : IEquatable<Reference>, ICloneable
Public NotInheritable Class Reference
    Implements IEquatable(Of Reference), ICloneable

Constructors

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 (Nothing).

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.