public void ExcelCustomFiltersCollectionConstructorTest() { XmlDocument document = new XmlDocument(); document.LoadXml(@"<customFilters xmlns=""http://schemas.openxmlformats.org/spreadsheetml/2006/main""> <customFilter operator=""greaterThan"" val=""512*""/> </customFilters>" ); var namespaceManager = TestUtility.CreateDefaultNSM(); var customFilterCollection = new ExcelCustomFiltersCollection(namespaceManager, document.SelectSingleNode("//d:customFilters", namespaceManager)); Assert.IsNotNull(customFilterCollection); Assert.AreEqual("greaterThan", customFilterCollection[0].FilterComparisonOperator); Assert.AreEqual("512*", customFilterCollection[0].TopOrBottomValue); }
public void LoadItems() { var namespaceManager = TestUtility.CreateDefaultNSM(); var xmlDoc = new XmlDocument(namespaceManager.NameTable); xmlDoc.LoadXml(@"<customFilters xmlns=""http://schemas.openxmlformats.org/spreadsheetml/2006/main"" and=""1""> <customFilter operator=""greaterThanOrEqual"" val=""c""/> <customFilter operator=""lessThanOrEqual"" val=""p""/> </customFilters>" ); var node = xmlDoc.FirstChild; var itemsCollection = new ExcelCustomFiltersCollection(namespaceManager, node); Assert.AreEqual("greaterThanOrEqual", itemsCollection[0].FilterComparisonOperator); Assert.AreEqual("c", itemsCollection[0].TopOrBottomValue); Assert.AreEqual("lessThanOrEqual", itemsCollection[1].FilterComparisonOperator); Assert.AreEqual("p", itemsCollection[1].TopOrBottomValue); }