/// <summary>
/// Adds an <see cref="IExcelDataValidationList"/> to the worksheet. The accepted values are defined
/// in a list.
/// </summary>
/// <param name="address">The range/address to validate</param>
/// <returns></returns>
public IExcelDataValidationList AddListValidation(string address)
{
ValidateAddress(address);
EnsureRootElementExists();
var item = new ExcelDataValidationList(_worksheet, address, ExcelDataValidationType.List);
_validations.Add(item);
OnValidationCountChanged();
return(item);
}
internal IExcelDataValidationList AddListValidation(string address, string uid)
{
ValidateAddress(address);
EnsureRootElementExists();
var item = new ExcelDataValidationList(_worksheet, uid, address, ExcelDataValidationType.List);
((ExcelDataValidationFormula)item.Formula).RegisterFormulaListener(_formulaListener);
_validations.Add(item);
OnValidationCountChanged();
return(item);
}
