public void ListFormula_FormulaValueIsSetFromXmlNodeInConstructorOrderIsCorrect() { // Arrange LoadXmlTestData("A1", "list", "\"1,2\""); // Act var validation = new ExcelDataValidationList(_sheet, "A1", ExcelDataValidationType.List, _dataValidationNode, _namespaceManager); // Assert CollectionAssert.AreEquivalent(new List<string>{ "1", "2"}, (ICollection)validation.Formula.Values); }
public void ListFormula_FormulaValueIsSetFromXmlNodeInConstructor() { // Arrange LoadXmlTestData("A1", "list", "\"1,2\""); // Act var validation = new ExcelDataValidationList(_sheet, "A1", ExcelDataValidationType.List, _dataValidationNode, _namespaceManager); // Assert Assert.AreEqual(2, validation.Formula.Values.Count); }
public void ListFormula_FormulasExcelFormulaIsSetFromXmlNodeInConstructor() { // Arrange LoadXmlTestData("A1", "list", "A1"); // Act var validation = new ExcelDataValidationList(_sheet, "A1", ExcelDataValidationType.List, _dataValidationNode, _namespaceManager); // Assert Assert.AreEqual("A1", validation.Formula.ExcelFormula); }
public void ListFormula_FormulaValueIsSetFromXmlNodeInConstructor() { // Arrange LoadXmlTestData("A1", "list", "\"1,2\""); // Act var validation = new ExcelDataValidationList(_sheet, ExcelDataValidation.NewId(), "A1", ExcelDataValidationType.List, _dataValidationNode, _namespaceManager); // Assert Assert.AreEqual(2, validation.Formula.Values.Count); }
/// <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); }
public void ListFormula_FormulaValueIsSetFromXmlNodeInConstructorOrderIsCorrect() { // Arrange LoadXmlTestData("A1", "list", "\"1,2\""); // Act var validation = new ExcelDataValidationList(_sheet, "A1", ExcelDataValidationType.List, _dataValidationNode, _namespaceManager); // Assert CollectionAssert.AreEquivalent(new List <string> { "1", "2" }, (ICollection)validation.Formula.Values); }