Search Results for

    Show / Hide Table of Contents

    TFormula Record

    An Excel formula. Use this class to pass a formula to an Excel sheet.

    Syntax

    Unit: FlexCel.Core

    TFormula = record;

    Fields

    Name Description
    Span For multicell formulas (like an array formula entered over more than one cell) this property says how many rows and columns the formula uses. Normal formulas will span one single cell

    Methods

    Name Description
    Create Overloaded
    Create
    Create(string)
    Create(string, TSingleFormulaValue)
    Create(string, TSingleFormulaValue, TFormulaSpan)
    Null Creates an undefined Excel formula
    ToString Returns the formula result as a string.
    Equals Returns true if obj is equal to this instance.
    GetHashCode Hashcode of the formula.
    IsNull Returns true if the record doesn't have a defined value.
    HasValue Returns true if the record has a defined value. This is the inverse of IsNull

    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
    Text The formula text, as it is written on Excel. It must begin with "=" or "{" for array formulas.
    FormulaResult The formula result.
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com