TDataValidationInfo.SecondFormula Property
Formula for the second condition of the data validation, if it has two conditions. The text of the formula is limited to 255 characters.
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 TExcelFile.RecalcRange.
To get the text for a particular cell, use TExcelFile.OffsetRelativeFormula.
To get the result of evaluating the formula, use TExcelFile.RecalcRelativeFormula.
Syntax
Unit: FlexCel.Core
property TDataValidationInfo.SecondFormula: string