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