/// <summary>
/// Adds an <see cref="IExcelDataValidationInt"/> regarding text length to the worksheet.
/// </summary>
/// <param name="address">The range/address to validate</param>
/// <returns></returns>
public IExcelDataValidationInt AddTextLengthValidation(string address)
{
ValidateAddress(address);
EnsureRootElementExists();
var item = new ExcelDataValidationInt(_worksheet, address, ExcelDataValidationType.TextLength);
_validations.Add(item);
OnValidationCountChanged();
return(item);
}
/// <summary>
/// Adds an <see cref="IExcelDataValidationInt"/> to the worksheet. Whole means that the only accepted values
/// are integer values.
/// </summary>
/// <param name="address">the range/address to validate</param>
public IExcelDataValidationInt AddIntegerValidation(string address)
{
ValidateAddress(address);
EnsureRootElementExists();
var item = new ExcelDataValidationInt(_worksheet, ExcelDataValidation.NewId(), address, ExcelDataValidationType.Whole);
_validations.Add(item);
OnValidationCountChanged();
return(item);
}