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)