Table of Contents

TFormulaSpan Structure

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

Syntax

Namespace: FlexCel.Core

public struct TFormulaSpan

Constructors

Name Description
TFormulaSpan Creates a new TFormulaSpan and sets its values.

Methods

Name Description
Equals Returns true of the 2 FormulaSpans are the same.
GetHashCode Returns the hashcode for this object.

Operators

Name Description
Equality This operator is overridden so you can compare this structure directly with ==
Inequality This operator is overriden so you can compare this structure directly with !=

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)