private void UpdateColorNode(XmlNode node, Color color) { if (!color.IsEmpty) { ExcelSparklineGroup.SetAttribute(node, "rgb", ExcelSparklineGroup.XmlColor(color)); } else if (node.Attributes.Count == 0) { this.TopNode.RemoveChild(node); } // Else: the node has an unsupported color definition (such as a theme) and should be left alone. }
private void SaveAttributes() { if (this.ManualMax != null) { ExcelSparklineGroup.SetAttribute(this.TopNode, "manualMax", this.ManualMax.ToString()); } else { this.ClearAttribute(this.TopNode, "manualMax"); } if (this.ManualMin != null) { ExcelSparklineGroup.SetAttribute(this.TopNode, "manualMin", this.ManualMin.ToString()); } else { this.ClearAttribute(this.TopNode, "manualMin"); } if (this.LineWeight != null && this.LineWeight != 0.75) { ExcelSparklineGroup.SetAttribute(this.TopNode, "lineWeight", this.LineWeight.ToString()); } else { this.ClearAttribute(this.TopNode, "lineWeight"); } if (this.Type != null && this.Type != SparklineType.Line) { ExcelSparklineGroup.SetAttribute(this.TopNode, "type", ExcelSparklineGroup.SparklineTypeToString(this.Type.Value)); } else { this.ClearAttribute(this.TopNode, "type"); } if (this.DateAxis) { ExcelSparklineGroup.SetAttribute(this.TopNode, "dateAxis", "1"); } else { this.ClearAttribute(this.TopNode, "dateAxis"); } if (this.DisplayEmptyCellsAs != null && this.DisplayEmptyCellsAs != DispBlanksAs.Zero) { ExcelSparklineGroup.SetAttribute(this.TopNode, "displayEmptyCellsAs", ExcelSparklineGroup.DisplayBlanksAsToString(this.DisplayEmptyCellsAs.Value)); } else { this.ClearAttribute(this.TopNode, "displayEmptyCellsAs"); } if (this.Markers) { ExcelSparklineGroup.SetAttribute(this.TopNode, "markers", "1"); } else { this.ClearAttribute(this.TopNode, "markers"); } if (this.High) { ExcelSparklineGroup.SetAttribute(this.TopNode, "high", "1"); } else { this.ClearAttribute(this.TopNode, "high"); } if (this.Low) { ExcelSparklineGroup.SetAttribute(this.TopNode, "low", "1"); } else { this.ClearAttribute(this.TopNode, "low"); } if (this.First) { ExcelSparklineGroup.SetAttribute(this.TopNode, "first", "1"); } else { this.ClearAttribute(this.TopNode, "first"); } if (this.Last) { ExcelSparklineGroup.SetAttribute(this.TopNode, "last", "1"); } else { this.ClearAttribute(this.TopNode, "last"); } if (this.Negative) { ExcelSparklineGroup.SetAttribute(this.TopNode, "negative", "1"); } else { this.ClearAttribute(this.TopNode, "negative"); } if (this.DisplayXAxis) { ExcelSparklineGroup.SetAttribute(this.TopNode, "displayXAxis", "1"); } else { this.ClearAttribute(this.TopNode, "displayXAxis"); } if (this.DisplayHidden) { ExcelSparklineGroup.SetAttribute(this.TopNode, "displayHidden", "1"); } else { this.ClearAttribute(this.TopNode, "displayHidden"); } if (this.MinAxisType != SparklineAxisMinMax.Individual) { ExcelSparklineGroup.SetAttribute(this.TopNode, "minAxisType", ExcelSparklineGroup.SparklineAxisMinMaxToString(this.MinAxisType)); } else { this.ClearAttribute(this.TopNode, "minAxisType"); } if (this.MaxAxisType != SparklineAxisMinMax.Individual) { ExcelSparklineGroup.SetAttribute(this.TopNode, "maxAxisType", ExcelSparklineGroup.SparklineAxisMinMaxToString(this.MaxAxisType)); } else { this.ClearAttribute(this.TopNode, "maxAxisType"); } if (this.RightToLeft) { ExcelSparklineGroup.SetAttribute(this.TopNode, "rightToLeft", "1"); } else { this.ClearAttribute(this.TopNode, "rightToLeft"); } }