RangeRef Struct

RangeReflink

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

Collapsedlink

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

Declaration

public bool Collapsed { get; }

Property Value

Columnslink

Gets the number of columns in the range.

Declaration

public int Columns { get; }

Property Value

Endlink

Gets the ending cell reference of the range.

Declaration

public Documents.Spreadsheet.CellRef End { get; }

Property Value

Invalidlink

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

Rowslink

Gets the number of rows and columns in the range.

Declaration

public int Rows { get; }

Property Value

Startlink

Gets the starting cell reference of the range.

Declaration

public Documents.Spreadsheet.CellRef Start { get; }

Property Value

Containslink

Checks if this range contains a specific row address.

Declaration

public bool Contains(Documents.Spreadsheet.RowRef address)

Parameters

Returns

Containslink

Checks if this range contains a specific row address.

Declaration

public bool Contains(Documents.Spreadsheet.ColumnRef address)

Parameters

Returns

Containslink

Checks if this range contains a specific row address.

Declaration

public bool Contains(int row, int column)

Parameters

Returns

Containslink

Checks if this range contains a specific row address.

Declaration

public bool Contains(Documents.Spreadsheet.CellRef address)

Parameters

Returns

Equalslink

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

Declaration

public bool Equals(Documents.Spreadsheet.RangeRef other)

Parameters

Returns

Equalslink

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

Declaration

public override bool Equals(object obj)

Parameters

Returns

FromCelllink

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

FromCellslink

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

GetCellslink

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

Declaration

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

Returns

GetHashCodelink

Declaration

public override int GetHashCode()

Returns

Intersectionlink

Calculates the intersection of this range with another range.

Declaration

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

Parameters

Returns

Overlapslink

Checks if this range overlaps with another range.

Declaration

public bool Overlaps(Documents.Spreadsheet.RangeRef other)

Parameters

Returns

Parselink

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

Declaration

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

Parameters

Returns

ToStringlink

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

Declaration

public override string ToString()

Returns

operator !=link

Declaration

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

Parameters

Returns

operator ==link

Declaration

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

Parameters

Returns