private void InitialiseDataBarOptions(SLConditionalFormatDataBarValues DataBar, bool Is2010Default)
        {
            this.Is2010 = Is2010Default;

            this.FillColor           = new SLColor(new List <System.Drawing.Color>(), new List <System.Drawing.Color>());
            this.BorderColor         = new SLColor(new List <System.Drawing.Color>(), new List <System.Drawing.Color>());
            this.NegativeFillColor   = new SLColor(new List <System.Drawing.Color>(), new List <System.Drawing.Color>());
            this.NegativeBorderColor = new SLColor(new List <System.Drawing.Color>(), new List <System.Drawing.Color>());
            this.AxisColor           = new SLColor(new List <System.Drawing.Color>(), new List <System.Drawing.Color>());

            switch (DataBar)
            {
            case SLConditionalFormatDataBarValues.Blue:
                this.FillColor.Color   = System.Drawing.Color.FromArgb(0xFF, 0x63, 0x8E, 0xC6);
                this.BorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0x63, 0x8E, 0xC6);
                break;

            case SLConditionalFormatDataBarValues.Green:
                this.FillColor.Color   = System.Drawing.Color.FromArgb(0xFF, 0x63, 0xC3, 0x84);
                this.BorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0x63, 0xC3, 0x84);
                break;

            case SLConditionalFormatDataBarValues.Red:
                this.FillColor.Color   = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0x55, 0x5A);
                this.BorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0x55, 0x5A);
                break;

            case SLConditionalFormatDataBarValues.Orange:
                this.FillColor.Color   = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0xB6, 0x28);
                this.BorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0xB6, 0x28);
                break;

            case SLConditionalFormatDataBarValues.LightBlue:
                this.FillColor.Color   = System.Drawing.Color.FromArgb(0xFF, 0x00, 0x8A, 0xEF);
                this.BorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0x00, 0x8A, 0xEF);
                break;

            case SLConditionalFormatDataBarValues.Purple:
                this.FillColor.Color   = System.Drawing.Color.FromArgb(0xFF, 0xD6, 0x00, 0x7B);
                this.BorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0xD6, 0x00, 0x7B);
                break;
            }

            this.NegativeFillColor.Color   = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0x00, 0x00);
            this.NegativeBorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0x00, 0x00);
            this.AxisColor.Color           = System.Drawing.Color.FromArgb(0xFF, 0x00, 0x00, 0x00);

            if (Is2010Default)
            {
                this.vMinimumType = SLConditionalFormatAutoMinMaxValues.Automatic;
                this.MinimumValue = string.Empty;
                this.vMaximumType = SLConditionalFormatAutoMinMaxValues.Automatic;
                this.MaximumValue = string.Empty;
                this.MinLength    = 0;
                this.MaxLength    = 100;
            }
            else
            {
                this.vMinimumType = SLConditionalFormatAutoMinMaxValues.Value;
                this.MinimumValue = string.Empty;
                this.vMaximumType = SLConditionalFormatAutoMinMaxValues.Value;
                this.MaximumValue = string.Empty;
                this.MinLength    = 10;
                this.MaxLength    = 90;
            }

            this.ShowBarOnly = false;
            this.bBorder     = false;
            this.bGradient   = false;
            this.vDirection  = X14.DataBarDirectionValues.Context;
            this.bNegativeBarColorSameAsPositive       = false;
            this.bNegativeBarBorderColorSameAsPositive = true;
            this.vAxisPosition = X14.DataBarAxisPositionValues.Automatic;
        }
        private void InitialiseDataBarOptions(SLConditionalFormatDataBarValues DataBar, bool Is2010Default)
        {
            this.Is2010 = Is2010Default;

            this.FillColor = new SLColor(new List<System.Drawing.Color>(), new List<System.Drawing.Color>());
            this.BorderColor = new SLColor(new List<System.Drawing.Color>(), new List<System.Drawing.Color>());
            this.NegativeFillColor = new SLColor(new List<System.Drawing.Color>(), new List<System.Drawing.Color>());
            this.NegativeBorderColor = new SLColor(new List<System.Drawing.Color>(), new List<System.Drawing.Color>());
            this.AxisColor = new SLColor(new List<System.Drawing.Color>(), new List<System.Drawing.Color>());

            switch (DataBar)
            {
                case SLConditionalFormatDataBarValues.Blue:
                    this.FillColor.Color = System.Drawing.Color.FromArgb(0xFF, 0x63, 0x8E, 0xC6);
                    this.BorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0x63, 0x8E, 0xC6);
                    break;
                case SLConditionalFormatDataBarValues.Green:
                    this.FillColor.Color = System.Drawing.Color.FromArgb(0xFF, 0x63, 0xC3, 0x84);
                    this.BorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0x63, 0xC3, 0x84);
                    break;
                case SLConditionalFormatDataBarValues.Red:
                    this.FillColor.Color = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0x55, 0x5A);
                    this.BorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0x55, 0x5A);
                    break;
                case SLConditionalFormatDataBarValues.Orange:
                    this.FillColor.Color = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0xB6, 0x28);
                    this.BorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0xB6, 0x28);
                    break;
                case SLConditionalFormatDataBarValues.LightBlue:
                    this.FillColor.Color = System.Drawing.Color.FromArgb(0xFF, 0x00, 0x8A, 0xEF);
                    this.BorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0x00, 0x8A, 0xEF);
                    break;
                case SLConditionalFormatDataBarValues.Purple:
                    this.FillColor.Color = System.Drawing.Color.FromArgb(0xFF, 0xD6, 0x00, 0x7B);
                    this.BorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0xD6, 0x00, 0x7B);
                    break;
            }

            this.NegativeFillColor.Color = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0x00, 0x00);
            this.NegativeBorderColor.Color = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0x00, 0x00);
            this.AxisColor.Color = System.Drawing.Color.FromArgb(0xFF, 0x00, 0x00, 0x00);

            if (Is2010Default)
            {
                this.vMinimumType = SLConditionalFormatAutoMinMaxValues.Automatic;
                this.MinimumValue = string.Empty;
                this.vMaximumType = SLConditionalFormatAutoMinMaxValues.Automatic;
                this.MaximumValue = string.Empty;
                this.MinLength = 0;
                this.MaxLength = 100;
            }
            else
            {
                this.vMinimumType = SLConditionalFormatAutoMinMaxValues.Value;
                this.MinimumValue = string.Empty;
                this.vMaximumType = SLConditionalFormatAutoMinMaxValues.Value;
                this.MaximumValue = string.Empty;
                this.MinLength = 10;
                this.MaxLength = 90;
            }

            this.ShowBarOnly = false;
            this.bBorder = false;
            this.bGradient = false;
            this.vDirection = X14.DataBarDirectionValues.Context;
            this.bNegativeBarColorSameAsPositive = false;
            this.bNegativeBarBorderColorSameAsPositive = true;
            this.vAxisPosition = X14.DataBarAxisPositionValues.Automatic;
        }