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);
}
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);
}