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