internal void FromColorScale(X14.ColorScale cs) { SetAllNull(); SLConditionalFormattingValueObject2010 cfvo; SLColor clr; using (var oxr = OpenXmlReader.Create(cs)) { while (oxr.Read()) { if (oxr.ElementType == typeof(X14.ConditionalFormattingValueObject)) { cfvo = new SLConditionalFormattingValueObject2010(); cfvo.FromConditionalFormattingValueObject( (X14.ConditionalFormattingValueObject)oxr.LoadCurrentElement()); Cfvos.Add(cfvo); } else if (oxr.ElementType == typeof(X14.Color)) { clr = new SLColor(new List <Color>(), new List <Color>()); clr.FromExcel2010Color((X14.Color)oxr.LoadCurrentElement()); Colors.Add(clr); } } } }
internal void FromColorScale(ColorScale cs) { SetAllNull(); SLConditionalFormatValueObject cfvo; SLColor clr; using (var oxr = OpenXmlReader.Create(cs)) { while (oxr.Read()) { if (oxr.ElementType == typeof(ConditionalFormatValueObject)) { cfvo = new SLConditionalFormatValueObject(); cfvo.FromConditionalFormatValueObject((ConditionalFormatValueObject)oxr.LoadCurrentElement()); Cfvos.Add(cfvo); } else if (oxr.ElementType == typeof(Color)) { clr = new SLColor(new List <System.Drawing.Color>(), new List <System.Drawing.Color>()); clr.FromSpreadsheetColor((Color)oxr.LoadCurrentElement()); Colors.Add(clr); } } } }
private void SetAllNull() { Is2010 = false; MinimumType = SLConditionalFormatAutoMinMaxValues.Percentile; MinimumValue = string.Empty; MaximumType = SLConditionalFormatAutoMinMaxValues.Percentile; MaximumValue = string.Empty; Color = new SLColor(new List <Color>(), new List <Color>()); BorderColor = new SLColor(new List <Color>(), new List <Color>()); NegativeFillColor = new SLColor(new List <Color>(), new List <Color>()); NegativeBorderColor = new SLColor(new List <Color>(), new List <Color>()); AxisColor = new SLColor(new List <Color>(), new List <Color>()); MinLength = 10; MaxLength = 90; ShowValue = true; }
private void SetAllNull() { Cfvo1 = new SLConditionalFormattingValueObject2010(); Cfvo2 = new SLConditionalFormattingValueObject2010(); FillColor = new SLColor(new List <Color>(), new List <Color>()); BorderColor = new SLColor(new List <Color>(), new List <Color>()); NegativeFillColor = new SLColor(new List <Color>(), new List <Color>()); NegativeBorderColor = new SLColor(new List <Color>(), new List <Color>()); AxisColor = new SLColor(new List <Color>(), new List <Color>()); MinLength = 10; MaxLength = 90; ShowValue = true; Border = false; Gradient = true; Direction = X14.DataBarDirectionValues.Context; NegativeBarColorSameAsPositive = false; NegativeBarBorderColorSameAsPositive = true; AxisPosition = X14.DataBarAxisPositionValues.Automatic; }
private void SetAllNull() { clrTabColor = new SLColor(listThemeColors, listIndexedColors); HasTabColor = false; ApplyStyles = false; SummaryBelow = false; SummaryRight = false; ShowOutlineSymbols = true; AutoPageBreaks = true; FitToPage = false; SyncHorizontal = false; SyncVertical = false; SyncReference = string.Empty; TransitionEvaluation = false; TransitionEntry = false; Published = true; CodeName = string.Empty; FilterMode = false; EnableFormatConditionsCalculation = true; }
private void InitialiseDataBarOptions(SLConditionalFormatDataBarValues DataBar, bool Is2010Default) { Is2010 = Is2010Default; FillColor = new SLColor(new List <Color>(), new List <Color>()); BorderColor = new SLColor(new List <Color>(), new List <Color>()); NegativeFillColor = new SLColor(new List <Color>(), new List <Color>()); NegativeBorderColor = new SLColor(new List <Color>(), new List <Color>()); AxisColor = new SLColor(new List <Color>(), new List <Color>()); switch (DataBar) { case SLConditionalFormatDataBarValues.Blue: FillColor.Color = Color.FromArgb(0xFF, 0x63, 0x8E, 0xC6); BorderColor.Color = Color.FromArgb(0xFF, 0x63, 0x8E, 0xC6); break; case SLConditionalFormatDataBarValues.Green: FillColor.Color = Color.FromArgb(0xFF, 0x63, 0xC3, 0x84); BorderColor.Color = Color.FromArgb(0xFF, 0x63, 0xC3, 0x84); break; case SLConditionalFormatDataBarValues.Red: FillColor.Color = Color.FromArgb(0xFF, 0xFF, 0x55, 0x5A); BorderColor.Color = Color.FromArgb(0xFF, 0xFF, 0x55, 0x5A); break; case SLConditionalFormatDataBarValues.Orange: FillColor.Color = Color.FromArgb(0xFF, 0xFF, 0xB6, 0x28); BorderColor.Color = Color.FromArgb(0xFF, 0xFF, 0xB6, 0x28); break; case SLConditionalFormatDataBarValues.LightBlue: FillColor.Color = Color.FromArgb(0xFF, 0x00, 0x8A, 0xEF); BorderColor.Color = Color.FromArgb(0xFF, 0x00, 0x8A, 0xEF); break; case SLConditionalFormatDataBarValues.Purple: FillColor.Color = Color.FromArgb(0xFF, 0xD6, 0x00, 0x7B); BorderColor.Color = Color.FromArgb(0xFF, 0xD6, 0x00, 0x7B); break; } NegativeFillColor.Color = Color.FromArgb(0xFF, 0xFF, 0x00, 0x00); NegativeBorderColor.Color = Color.FromArgb(0xFF, 0xFF, 0x00, 0x00); AxisColor.Color = Color.FromArgb(0xFF, 0x00, 0x00, 0x00); if (Is2010Default) { vMinimumType = SLConditionalFormatAutoMinMaxValues.Automatic; MinimumValue = string.Empty; vMaximumType = SLConditionalFormatAutoMinMaxValues.Automatic; MaximumValue = string.Empty; MinLength = 0; MaxLength = 100; } else { vMinimumType = SLConditionalFormatAutoMinMaxValues.Value; MinimumValue = string.Empty; vMaximumType = SLConditionalFormatAutoMinMaxValues.Value; MaximumValue = string.Empty; MinLength = 10; MaxLength = 90; } ShowBarOnly = false; bBorder = false; bGradient = false; vDirection = X14.DataBarDirectionValues.Context; bNegativeBarColorSameAsPositive = false; bNegativeBarBorderColorSameAsPositive = true; vAxisPosition = X14.DataBarAxisPositionValues.Automatic; }