Search Results for

    Show / Hide Table of Contents

    TXlsCellRange Record

    An Excel Cell range, 1-based.

    Syntax

    Unit: FlexCel.Core

    TXlsCellRange = record;

    Fields

    Name Description
    HasValue False if the record doesn't have a defined value. When this field is false, the values of left, right, top and bottom don't matter.
    Top First row on range.
    Left First column on range.
    Bottom Last row on range.
    Right Last column on range.

    Methods

    Name Description
    Intersects Returns true if this range intersects with another.
    Create Overloaded
    Create
    Create(string)
    Create(Integer, Integer, Integer, Integer)
    Null Creates an invalid Cell range with the IsNull field set.
    FullRange Creates a range with all cells on the sheet (65536 rows x 256 columns in Excel 97-2003)
    Transpose Returns the range transposed, rows by columns.
    Offset Creates a new range with the start at newTopRow, newLeftCol.
    HasRow True if the specified row is in the range
    HasCol True if the specified column is in the range
    CalcTopCell Returns the minimum top and left coordinates for an array of ranges. If for example you have C7 and D5, this method will return C5
    Dec Returns a COPY of the range decremented by one.
    Inc Returns a COPY of the range incremented by one.
    Equals Returns true if both objects are equal.
    GetHashCode Returns the hashcode of the object.
    Contains Returns true if the cell is inside the range.
    ToString A human-readable representation of the range.
    IsNull Returns true if the record doesn't have a defined value. This is the inverse of HasValue

    Operators

    Name Description
    Equality Adapts the = operator so it returns true when both instances have the same values.
    Inequality Adapts the <> operator so it returns true when both instances have different values.

    Properties

    Name Description
    IsOneCell Returns true if the range has only one cell.
    RowCount Number of rows on the range.
    ColCount Number of columns on the range.
    CellRef Gets or sets the string that defines the 2D-range in A1 notation.
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com