GrapeCity.Documents.Excel.Expressions.Reference

Class Reference

Namespace

GrapeCity.Documents.Excel.Expressions

Assembly

GcDocs.Excel.dll

Represents a reference in formula.

public sealed class Reference : IEquatable<Reference>, ICloneable

Inheritance

object

Reference

Implements

System.IEquatable<T><Reference>

System.ICloneable

Inherited Members

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetType()

Constructors

Reference()

public Reference()

Properties

Column

Gets or sets the 0-based column index. The default value is 0.

public int Column { get; set; }

Property Value

int

HasColumn

Indicates whether the reference has column. The default value is true.

public bool HasColumn { get; set; }

Property Value

bool

HasRow

Gets or sets whether the reference has row. The default value is true.

public bool HasRow { get; set; }

Property Value

bool

IsColumnRelative

Gets or sets whether the column is relative. The default value is true.

public bool IsColumnRelative { get; set; }

Property Value

bool

IsError

Gets or sets whether the reference contains error. The default value is false.

public bool IsError { get; set; }

Property Value

bool

IsLastColumnRelative

Gets or sets whether the last column is relative. The default value is true.

public bool IsLastColumnRelative { get; set; }

Property Value

bool

IsLastRowRelative

Gets or sets whether the last row is absolute. The default value is true.

public bool IsLastRowRelative { get; set; }

Property Value

bool

IsRange

Gets or sets whether the reference is range. The default value is false.

public bool IsRange { get; set; }

Property Value

bool

IsRowRelative

Gets or sets whether the row is relative. The default value is true.

public bool IsRowRelative { get; set; }

Property Value

bool

LastColumn

Gets or sets the end column index. The default value is 0.

public int LastColumn { get; set; }

Property Value

int

LastRow

Gets or sets the 0-based end row index. The default value is 0.

public int LastRow { get; set; }

Property Value

int

LastWorksheetName

The name of the end worksheet of the 3D reference.

public string LastWorksheetName { get; set; }

Property Value

string

Row

Gets or sets the 0-based row index. The default value is 0.

public int Row { get; set; }

Property Value

int

Workbook

Gets or sets the external workbook reference. The default value is null (Nothing).

public WorkbookReference Workbook { get; set; }

Property Value

WorkbookReference

WorksheetName

The name of the worksheet.

public string WorksheetName { get; set; }

Property Value

string

Methods

Clone()

Copy the reference.

public Reference Clone()

Returns

Reference

A copy of the reference.

Equals(Reference)

Equality comparison.

public bool Equals(Reference other)

Parameters

other Reference

Another reference.

Returns

bool

Equals(object)

Equality comparison for late binding.

public override bool Equals(object obj)

Parameters

obj object

Another reference.

Returns

bool

GetHashCode()

This object doesn't support getting hash code, because all fields are mutable.

public override int GetHashCode()

Returns

int

The hash code of the current type.

ToString()

Converts the reference to A1 string.

public override string ToString()

Returns

string

ToString(UnParseContext)

Converts the reference to string.

public string ToString(UnParseContext context)

Parameters

context UnParseContext

The parse options.

Returns

string