Search Results for

    Show / Hide Table of Contents

    TFormulaSpan Record

    This structure is used in formulas that span more than one cell, like some array formulas, or "what-if" table formulas.

    Syntax

    Unit: FlexCel.Core

    TFormulaSpan = record;

    Methods

    Name Description
    Create Overloaded
    Create
    Create(Integer, Integer, Boolean)
    Equals Returns true of the 2 FormulaSpans are the same.
    GetHashCode Returns the hashcode for this object.

    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
    RowSpan How many rows the formula will use.
    ColSpan How many columns the formula will use.
    IsTopLeft Indicates if this is the first formula of the array. Only the formula that is at the top left cell of the group will be used when setting a formula. Other formulas will be ignored, so you can copy formulas in a loop from one place to the other without worring if the cell is at the top left or not.
    IsOneCell Returns true if this formula spans over a single cell. (the most usual case)
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com