RangeRef Struct

RangeReflinkLink to this section

Initializes a new instance of the RangeRef struct with the specified start and end cell references.

Declaration

public RangeRef(Documents.Spreadsheet.CellRef start, Documents.Spreadsheet.CellRef end)

Parameters

CollapsedlinkLink to this section

Checks if this range is collapsed, meaning the start and end cell references are the same.

Declaration

public bool Collapsed { get; }

Property Value

ColumnslinkLink to this section

Gets the number of columns in the range.

Declaration

public int Columns { get; }

Property Value

EndlinkLink to this section

Gets the ending cell reference of the range.

Declaration

public Documents.Spreadsheet.CellRef End { get; }

Property Value

InvalidlinkLink to this section

Represents an invalid range reference, which is used to indicate that a range is not defined or does not exist.

Declaration

public Documents.Spreadsheet.RangeRef Invalid { get; }

Property Value

RowslinkLink to this section

Gets the number of rows and columns in the range.

Declaration

public int Rows { get; }

Property Value

StartlinkLink to this section

Gets the starting cell reference of the range.

Declaration

public Documents.Spreadsheet.CellRef Start { get; }

Property Value

ContainslinkLink to this section

Checks if this range contains a specific row address.

Declaration

public bool Contains(Documents.Spreadsheet.RowRef address)

Parameters

Returns

ContainslinkLink to this section

Checks if this range contains a specific row address.

Declaration

public bool Contains(Documents.Spreadsheet.ColumnRef address)

Parameters

Returns

ContainslinkLink to this section

Checks if this range contains a specific row address.

Declaration

public bool Contains(int row, int column)

Parameters

Returns

ContainslinkLink to this section

Checks if this range contains a specific row address.

Declaration

public bool Contains(Documents.Spreadsheet.CellRef address)

Parameters

Returns

EqualslinkLink to this section

Checks if this RangeRef instance is equal to another RangeRef instance.

Declaration

public bool Equals(Documents.Spreadsheet.RangeRef other)

Parameters

Returns

EqualslinkLink to this section

Checks if this RangeRef instance is equal to another RangeRef instance.

Declaration

public override bool Equals(object obj)

Parameters

Returns

FromCelllinkLink to this section

Creates a new RangeRef instance from two cell references, representing the start and end of the range.

Declaration

public static Documents.Spreadsheet.RangeRef FromCell(Documents.Spreadsheet.CellRef cell)

Parameters

Returns

FromCellslinkLink to this section

Creates a new RangeRef instance from two cell references, representing the start and end of the range.

Declaration

public static Documents.Spreadsheet.RangeRef FromCells(Documents.Spreadsheet.CellRef start, Documents.Spreadsheet.CellRef end)

Parameters

Returns

GetCellslinkLink to this section

Returns a collection of cell references that represent all the cells in the range.

Declaration

public IEnumerable<Documents.Spreadsheet.CellRef> GetCells()

Returns

GetHashCodelinkLink to this section

Declaration

public override int GetHashCode()

Returns

IntersectionlinkLink to this section

Calculates the intersection of this range with another range.

Declaration

public Documents.Spreadsheet.RangeRef Intersection(Documents.Spreadsheet.RangeRef other)

Parameters

Returns

OverlapslinkLink to this section

Checks if this range overlaps with another range.

Declaration

public bool Overlaps(Documents.Spreadsheet.RangeRef other)

Parameters

Returns

ParselinkLink to this section

Parses a string representation of a range into a RangeRef instance.

Declaration

public static Documents.Spreadsheet.RangeRef Parse(string range)

Parameters

Returns

ToStringlinkLink to this section

Returns a string representation of the range in A1 notation (e.g., "A1:B2").

Declaration

public override string ToString()

Returns

operator !=linkLink to this section

Declaration

public static bool operator !=(Documents.Spreadsheet.RangeRef left, Documents.Spreadsheet.RangeRef right)

Parameters

Returns

operator ==linkLink to this section

Declaration

public static bool operator ==(Documents.Spreadsheet.RangeRef left, Documents.Spreadsheet.RangeRef right)

Parameters

Returns