public void SlicerRangeItemDisplayName()
{
var xmlDoc = new XmlDocument(ExcelSlicer.SlicerDocumentNamespaceManager.NameTable);
xmlDoc.LoadXml("<i n=\"[Bill-to Customer].[by Country by City].[Country].&[AT]\" c=\"Austria\"/>");
var node = xmlDoc.FirstChild;
var slicerRangeItem = new SlicerRangeItem(node, ExcelSlicer.SlicerDocumentNamespaceManager);
Assert.AreEqual("Austria", slicerRangeItem.DisplayName);
slicerRangeItem.DisplayName = "Belgium";
Assert.AreEqual("Belgium", slicerRangeItem.DisplayName);
Assert.AreEqual("<i n=\"[Bill-to Customer].[by Country by City].[Country].&[AT]\" c=\"Belgium\" />", node.OuterXml);
}
public void SlicerRangeItemNonDisplayDoesNotExist()
{
var xmlDoc = new XmlDocument(ExcelSlicer.SlicerDocumentNamespaceManager.NameTable);
xmlDoc.LoadXml("<i n=\"[Bill-to Customer].[by Country by City].[Country].&[AT]\" c=\"Austria\"/>");
var node = xmlDoc.FirstChild;
var slicerRangeItem = new SlicerRangeItem(node, ExcelSlicer.SlicerDocumentNamespaceManager);
Assert.IsFalse(slicerRangeItem.NonDisplay);
slicerRangeItem.NonDisplay = true;
Assert.IsTrue(slicerRangeItem.NonDisplay);
Assert.AreEqual("<i n=\"[Bill-to Customer].[by Country by City].[Country].&[AT]\" c=\"Austria\" nd=\"1\" />", node.OuterXml);
}
public void SlicerRangeItemLoadsParentsIfTheyExist()
{
var xmlDoc = new XmlDocument(ExcelSlicer.SlicerDocumentNamespaceManager.NameTable);
xmlDoc.LoadXml($@"
<i n=""[Bill-to Customer].[by Country by City].[Country].&[AT]"" c=""Austria"" xmlns=""{ExcelPackage.schemaMain2009}"">
<p n=""parent1"" />
<p n=""parent2"" />
</i>" );
var node = xmlDoc.FirstChild;
var slicerRangeItem = new SlicerRangeItem(node, ExcelSlicer.SlicerDocumentNamespaceManager);
Assert.AreEqual(2, slicerRangeItem.Parents.Count);
Assert.AreEqual("parent1", slicerRangeItem.Parents[0].Name);
Assert.AreEqual("parent2", slicerRangeItem.Parents[1].Name);
}
