internal SLConditionalFormattingRule2010 ToSLConditionalFormattingRule2010() { var cfr2010 = new SLConditionalFormattingRule2010(); cfr2010.Type = Type; cfr2010.Priority = Priority; cfr2010.StopIfTrue = StopIfTrue; cfr2010.AboveAverage = AboveAverage; cfr2010.Percent = Percent; cfr2010.Bottom = Bottom; cfr2010.HasOperator = HasOperator; cfr2010.Operator = Operator; cfr2010.Text = Text; cfr2010.HasTimePeriod = HasTimePeriod; cfr2010.TimePeriod = TimePeriod; cfr2010.Rank = Rank; cfr2010.StandardDeviation = StdDev; cfr2010.EqualAverage = EqualAverage; foreach (var f in Formulas) { cfr2010.Formulas.Add(new DocumentFormat.OpenXml.Office.Excel.Formula(f.Text)); } cfr2010.HasColorScale = HasColorScale; cfr2010.ColorScale = ColorScale.ToSLColorScale2010(); cfr2010.HasDataBar = HasDataBar; cfr2010.DataBar = DataBar.ToDataBar2010(); cfr2010.HasIconSet = HasIconSet; cfr2010.IconSet = IconSet.ToSLIconSet2010(); cfr2010.HasDifferentialType = HasDifferentialFormat; cfr2010.DifferentialType = DifferentialFormat.Clone(); return(cfr2010); }
internal SLConditionalFormattingRule Clone() { var cfr = new SLConditionalFormattingRule(); cfr.Formulas = new List <Formula>(); for (var i = 0; i < Formulas.Count; ++i) { cfr.Formulas.Add((Formula)Formulas[i].CloneNode(true)); } cfr.HasColorScale = HasColorScale; cfr.ColorScale = ColorScale.Clone(); cfr.HasDataBar = HasDataBar; cfr.DataBar = DataBar.Clone(); cfr.HasIconSet = HasIconSet; cfr.IconSet = IconSet.Clone(); cfr.Extensions = new List <ConditionalFormattingRuleExtension>(); for (var i = 0; i < Extensions.Count; ++i) { cfr.Extensions.Add((ConditionalFormattingRuleExtension)Extensions[i].CloneNode(true)); } cfr.Type = Type; cfr.FormatId = FormatId; cfr.HasDifferentialFormat = HasDifferentialFormat; cfr.DifferentialFormat = DifferentialFormat.Clone(); cfr.Priority = Priority; cfr.StopIfTrue = StopIfTrue; cfr.AboveAverage = AboveAverage; cfr.Percent = Percent; cfr.Bottom = Bottom; cfr.HasOperator = HasOperator; cfr.Operator = Operator; cfr.Text = Text; cfr.HasTimePeriod = HasTimePeriod; cfr.TimePeriod = TimePeriod; cfr.Rank = Rank; cfr.StdDev = StdDev; cfr.EqualAverage = EqualAverage; return(cfr); }