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 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 SecondFormula { get; set; }