Table of Contents

TDataValidationInfo.FirstFormula Property

Formula for the first condition of the data validation. The text of the formula is limited to 255 characters. If ExplicitList is true, this formula can contain a list of values.

Note that with relative references, we always consider "A1" to be the cell where the data validation is. This means that the formula: "=$A$1 + A1" when evaluated in Cell B8, will read "=$A$1 + B8". To provide a negative offset, you need to wrap the formula. For example "=A1048575" will evaluate to B7 when evaluated in B8.

Remarks

If this formula refers to a cell range, you can get the cell range by calling ExcelFile.RecalcRange.

To get the text for a particular cell, use ExcelFile.OffsetRelativeFormula.

To get the result of evaluating the formula, use ExcelFile.RecalcRelativeFormula

Syntax

Namespace: FlexCel.Core

public String FirstFormula { get; set; }

See also