/// <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); }