internal SLDataBar2010 Clone()
        {
            SLDataBar2010 db = new SLDataBar2010();

            db.Cfvo1                                = this.Cfvo1.Clone();
            db.Cfvo2                                = this.Cfvo2.Clone();
            db.FillColor                            = this.FillColor.Clone();
            db.BorderColor                          = this.BorderColor.Clone();
            db.NegativeFillColor                    = this.NegativeFillColor.Clone();
            db.NegativeBorderColor                  = this.NegativeBorderColor.Clone();
            db.AxisColor                            = this.AxisColor.Clone();
            db.MinLength                            = this.MinLength;
            db.MaxLength                            = this.MaxLength;
            db.ShowValue                            = this.ShowValue;
            db.Border                               = this.Border;
            db.Gradient                             = this.Gradient;
            db.Direction                            = this.Direction;
            db.NegativeBarColorSameAsPositive       = this.NegativeBarColorSameAsPositive;
            db.NegativeBarBorderColorSameAsPositive = this.NegativeBarBorderColorSameAsPositive;
            db.AxisPosition                         = this.AxisPosition;

            return(db);
        }
        internal SLDataBar2010 ToDataBar2010()
        {
            SLDataBar2010 db = new SLDataBar2010();

            switch (this.MinimumType)
            {
            case SLConditionalFormatAutoMinMaxValues.Automatic:
                db.Cfvo1.Type    = X14.ConditionalFormattingValueObjectTypeValues.AutoMin;
                db.Cfvo1.Formula = string.Empty;
                break;

            case SLConditionalFormatAutoMinMaxValues.Formula:
                db.Cfvo1.Type    = X14.ConditionalFormattingValueObjectTypeValues.Formula;
                db.Cfvo1.Formula = this.MinimumValue;
                break;

            case SLConditionalFormatAutoMinMaxValues.Number:
                db.Cfvo1.Type    = X14.ConditionalFormattingValueObjectTypeValues.Numeric;
                db.Cfvo1.Formula = this.MinimumValue;
                break;

            case SLConditionalFormatAutoMinMaxValues.Percent:
                db.Cfvo1.Type    = X14.ConditionalFormattingValueObjectTypeValues.Percent;
                db.Cfvo1.Formula = this.MinimumValue;
                break;

            case SLConditionalFormatAutoMinMaxValues.Percentile:
                db.Cfvo1.Type    = X14.ConditionalFormattingValueObjectTypeValues.Percentile;
                db.Cfvo1.Formula = this.MinimumValue;
                break;

            case SLConditionalFormatAutoMinMaxValues.Value:
                db.Cfvo1.Type    = X14.ConditionalFormattingValueObjectTypeValues.Min;
                db.Cfvo1.Formula = string.Empty;
                break;
            }

            switch (this.MaximumType)
            {
            case SLConditionalFormatAutoMinMaxValues.Automatic:
                db.Cfvo2.Type    = X14.ConditionalFormattingValueObjectTypeValues.AutoMax;
                db.Cfvo2.Formula = string.Empty;
                break;

            case SLConditionalFormatAutoMinMaxValues.Formula:
                db.Cfvo2.Type    = X14.ConditionalFormattingValueObjectTypeValues.Formula;
                db.Cfvo2.Formula = this.MaximumValue;
                break;

            case SLConditionalFormatAutoMinMaxValues.Number:
                db.Cfvo2.Type    = X14.ConditionalFormattingValueObjectTypeValues.Numeric;
                db.Cfvo2.Formula = this.MaximumValue;
                break;

            case SLConditionalFormatAutoMinMaxValues.Percent:
                db.Cfvo2.Type    = X14.ConditionalFormattingValueObjectTypeValues.Percent;
                db.Cfvo2.Formula = this.MaximumValue;
                break;

            case SLConditionalFormatAutoMinMaxValues.Percentile:
                db.Cfvo2.Type    = X14.ConditionalFormattingValueObjectTypeValues.Percentile;
                db.Cfvo2.Formula = this.MaximumValue;
                break;

            case SLConditionalFormatAutoMinMaxValues.Value:
                db.Cfvo2.Type    = X14.ConditionalFormattingValueObjectTypeValues.Max;
                db.Cfvo2.Formula = string.Empty;
                break;
            }

            db.FillColor           = this.Color.Clone();
            db.BorderColor         = this.BorderColor.Clone();
            db.NegativeFillColor   = this.NegativeFillColor.Clone();
            db.NegativeBorderColor = this.NegativeBorderColor.Clone();
            db.AxisColor           = this.AxisColor.Clone();
            db.MinLength           = this.MinLength;
            db.MaxLength           = this.MaxLength;
            db.ShowValue           = this.ShowValue;
            db.Border    = this.Border;
            db.Gradient  = this.Gradient;
            db.Direction = this.Direction;
            db.NegativeBarColorSameAsPositive       = this.NegativeBarColorSameAsPositive;
            db.NegativeBarBorderColorSameAsPositive = this.NegativeBarBorderColorSameAsPositive;
            db.AxisPosition = this.AxisPosition;

            return(db);
        }