Exemplo n.º 1
0
        internal SLDataBar Clone()
        {
            var db = new SLDataBar();

            db.Is2010                               = Is2010;
            db.MinimumType                          = MinimumType;
            db.MinimumValue                         = MinimumValue;
            db.MaximumType                          = MaximumType;
            db.MaximumValue                         = MaximumValue;
            db.Color                                = Color.Clone();
            db.BorderColor                          = BorderColor.Clone();
            db.NegativeFillColor                    = NegativeFillColor.Clone();
            db.NegativeBorderColor                  = NegativeBorderColor.Clone();
            db.AxisColor                            = AxisColor.Clone();
            db.MinLength                            = MinLength;
            db.MaxLength                            = MaxLength;
            db.ShowValue                            = ShowValue;
            db.Border                               = Border;
            db.Gradient                             = Gradient;
            db.Direction                            = Direction;
            db.NegativeBarColorSameAsPositive       = NegativeBarColorSameAsPositive;
            db.NegativeBarBorderColorSameAsPositive = NegativeBarBorderColorSameAsPositive;
            db.AxisPosition                         = AxisPosition;

            return(db);
        }
        internal SLDataBar2010 Clone()
        {
            var db = new SLDataBar2010();

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

            return(db);
        }
Exemplo n.º 3
0
        internal SLDataBar2010 ToDataBar2010()
        {
            var db = new SLDataBar2010();

            switch (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 = MinimumValue;
                break;

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

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

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

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

            switch (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 = MaximumValue;
                break;

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

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

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

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

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

            return(db);
        }