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 SLColor Clone() { SLColor clr = new SLColor(this.listThemeColors, this.listIndexedColors); clr.clrDisplay = this.clrDisplay; clr.Auto = this.Auto; clr.Indexed = this.Indexed; clr.Rgb = this.Rgb; clr.Theme = this.Theme; clr.Tint = this.Tint; return(clr); }
internal void FromBorderPropertiesType(HorizontalBorder border) { if (border.Color != null) { this.clrReal = new SLColor(this.listThemeColors, this.listIndexedColors); this.clrReal.FromSpreadsheetColor(border.Color); HasColor = !this.clrReal.IsEmpty(); } else { RemoveColor(); } if (border.Style != null) { this.BorderStyle = border.Style.Value; } else { RemoveBorderStyle(); } }
private void SetAllNull() { this.FontName = null; this.CharacterSet = null; this.FontFamily = null; this.Bold = null; this.Italic = null; this.Strike = null; this.Outline = null; this.Shadow = null; this.Condense = null; this.Extend = null; this.clrFontColor = new SLColor(this.listThemeColors, this.listIndexedColors); HasFontColor = false; this.FontSize = null; this.vUnderline = UnderlineValues.None; HasUnderline = false; this.vVerticalAlignment = VerticalAlignmentRunValues.Baseline; HasVerticalAlignment = false; this.vFontScheme = FontSchemeValues.None; HasFontScheme = false; }
private void SetAllNull() { this.clrTabColor = new SLColor(this.listThemeColors, this.listIndexedColors); this.HasTabColor = false; this.ApplyStyles = false; this.SummaryBelow = true; this.SummaryRight = true; this.ShowOutlineSymbols = true; this.AutoPageBreaks = true; this.FitToPage = false; this.SyncHorizontal = false; this.SyncVertical = false; this.SyncReference = string.Empty; this.TransitionEvaluation = false; this.TransitionEntry = false; this.Published = true; this.CodeName = string.Empty; this.FilterMode = false; this.EnableFormatConditionsCalculation = true; }
/// <summary> /// Remove any existing color. /// </summary> public void RemoveColor() { this.clrReal = new SLColor(this.listThemeColors, this.listIndexedColors); HasColor = false; }
internal void FromFont(Font f) { this.SetAllNull(); if (f.FontName != null && f.FontName.Val != null) { this.FontName = f.FontName.Val.Value; } if (f.FontCharSet != null && f.FontCharSet.Val != null) { this.CharacterSet = f.FontCharSet.Val.Value; } if (f.FontFamilyNumbering != null && f.FontFamilyNumbering.Val != null) { this.FontFamily = f.FontFamilyNumbering.Val.Value; } if (f.Bold != null) { if (f.Bold.Val == null) { this.Bold = true; } else if (f.Bold.Val.Value) { this.Bold = true; } } if (f.Italic != null) { if (f.Italic.Val == null) { this.Italic = true; } else if (f.Italic.Val.Value) { this.Italic = true; } } if (f.Strike != null) { if (f.Strike.Val == null) { this.Strike = true; } else if (f.Strike.Val.Value) { this.Strike = true; } } if (f.Outline != null) { if (f.Outline.Val == null) { this.Outline = true; } else if (f.Outline.Val.Value) { this.Outline = true; } } if (f.Shadow != null) { if (f.Shadow.Val == null) { this.Shadow = true; } else if (f.Shadow.Val.Value) { this.Shadow = true; } } if (f.Condense != null) { if (f.Condense.Val == null) { this.Condense = true; } else if (f.Condense.Val.Value) { this.Condense = true; } } if (f.Extend != null) { if (f.Extend.Val == null) { this.Extend = true; } else if (f.Extend.Val.Value) { this.Extend = true; } } if (f.Color != null) { this.clrFontColor = new SLColor(this.listThemeColors, this.listIndexedColors); this.clrFontColor.FromSpreadsheetColor(f.Color); HasFontColor = !this.clrFontColor.IsEmpty(); } if (f.FontSize != null && f.FontSize.Val != null) { this.FontSize = f.FontSize.Val.Value; } if (f.Underline != null) { if (f.Underline.Val != null) { this.Underline = f.Underline.Val.Value; } else { this.Underline = UnderlineValues.Single; } } if (f.VerticalTextAlignment != null && f.VerticalTextAlignment.Val != null) { this.VerticalAlignment = f.VerticalTextAlignment.Val.Value; } if (f.FontScheme != null && f.FontScheme.Val != null) { this.FontScheme = f.FontScheme.Val.Value; } }