public void LoadItems()
        {
            var namespaceManager = TestUtility.CreateDefaultNSM();
            var xmlDoc           = new XmlDocument(namespaceManager.NameTable);

            xmlDoc.LoadXml(@"<filters xmlns=""http://schemas.openxmlformats.org/spreadsheetml/2006/main"">
					<filter val=""c""/>
			</filters>"            );
            var itemsCollection = new ExcelFilterCriteriaCollection(namespaceManager, xmlDoc.FirstChild);

            Assert.AreEqual(string.Empty, itemsCollection[0].FilterComparisonOperator);
            Assert.AreEqual("c", itemsCollection[0].TopOrBottomValue);
        }
        public void ExcelFilterCriteriaCollectionConstructorTest()
        {
            XmlDocument document = new XmlDocument();

            document.LoadXml(@"<filters xmlns=""http://schemas.openxmlformats.org/spreadsheetml/2006/main"">
								<filter val=""chicago""/>
							</filters>"                            );
            var namespaceManager         = TestUtility.CreateDefaultNSM();
            var filterCriteriaCollection = new ExcelFilterCriteriaCollection(namespaceManager, document.SelectSingleNode("//d:filters", namespaceManager));

            Assert.IsNotNull(filterCriteriaCollection);
            Assert.AreEqual("chicago", filterCriteriaCollection[0].TopOrBottomValue);
            Assert.AreEqual(string.Empty, filterCriteriaCollection[0].FilterComparisonOperator);
        }