internal void FromColorScale(X14.ColorScale cs) { this.SetAllNull(); SLConditionalFormattingValueObject2010 cfvo; SLColor clr; using (OpenXmlReader oxr = OpenXmlReader.Create(cs)) { while (oxr.Read()) { if (oxr.ElementType == typeof(X14.ConditionalFormattingValueObject)) { cfvo = new SLConditionalFormattingValueObject2010(); cfvo.FromConditionalFormattingValueObject((X14.ConditionalFormattingValueObject)oxr.LoadCurrentElement()); this.Cfvos.Add(cfvo); } else if (oxr.ElementType == typeof(X14.Color)) { clr = new SLColor(new List<System.Drawing.Color>(), new List<System.Drawing.Color>()); clr.FromExcel2010Color((X14.Color)oxr.LoadCurrentElement()); this.Colors.Add(clr); } } } }
internal SLConditionalFormattingValueObject2010 ToSLConditionalFormattingValueObject2010() { SLConditionalFormattingValueObject2010 cfvo2010 = new SLConditionalFormattingValueObject2010(); cfvo2010.Formula = this.Val; switch (this.Type) { case ConditionalFormatValueObjectValues.Formula: cfvo2010.Type = X14.ConditionalFormattingValueObjectTypeValues.Formula; break; case ConditionalFormatValueObjectValues.Max: cfvo2010.Type = X14.ConditionalFormattingValueObjectTypeValues.Max; break; case ConditionalFormatValueObjectValues.Min: cfvo2010.Type = X14.ConditionalFormattingValueObjectTypeValues.Min; break; case ConditionalFormatValueObjectValues.Number: cfvo2010.Type = X14.ConditionalFormattingValueObjectTypeValues.Numeric; break; case ConditionalFormatValueObjectValues.Percent: cfvo2010.Type = X14.ConditionalFormattingValueObjectTypeValues.Percent; break; case ConditionalFormatValueObjectValues.Percentile: cfvo2010.Type = X14.ConditionalFormattingValueObjectTypeValues.Percentile; break; } cfvo2010.GreaterThanOrEqual = this.GreaterThanOrEqual; return cfvo2010; }
internal SLConditionalFormattingValueObject2010 Clone() { SLConditionalFormattingValueObject2010 cfvo = new SLConditionalFormattingValueObject2010(); cfvo.Formula = this.Formula; cfvo.Type = this.Type; cfvo.GreaterThanOrEqual = this.GreaterThanOrEqual; return cfvo; }
internal void FromIconSet(X14.IconSet ics) { this.SetAllNull(); if (ics.IconSetTypes != null) this.IconSetType = ics.IconSetTypes.Value; if (ics.ShowValue != null) this.ShowValue = ics.ShowValue.Value; if (ics.Percent != null) this.Percent = ics.Percent.Value; if (ics.Reverse != null) this.Reverse = ics.Reverse.Value; using (OpenXmlReader oxr = OpenXmlReader.Create(ics)) { SLConditionalFormattingValueObject2010 cfvo; SLConditionalFormattingIcon2010 cfi; while (oxr.Read()) { if (oxr.ElementType == typeof(X14.ConditionalFormattingValueObject)) { cfvo = new SLConditionalFormattingValueObject2010(); cfvo.FromConditionalFormattingValueObject((X14.ConditionalFormattingValueObject)oxr.LoadCurrentElement()); this.Cfvos.Add(cfvo); } else if (oxr.ElementType == typeof(X14.ConditionalFormattingIcon)) { cfi = new SLConditionalFormattingIcon2010(); cfi.FromConditionalFormattingIcon((X14.ConditionalFormattingIcon)oxr.LoadCurrentElement()); this.CustomIcons.Add(cfi); } } } }