internal void FromColorScale(X14.ColorScale cs)
{
SetAllNull();
SLConditionalFormattingValueObject2010 cfvo;
SLColor clr;
using (var oxr = OpenXmlReader.Create(cs))
{
while (oxr.Read())
{
if (oxr.ElementType == typeof(X14.ConditionalFormattingValueObject))
{
cfvo = new SLConditionalFormattingValueObject2010();
cfvo.FromConditionalFormattingValueObject(
(X14.ConditionalFormattingValueObject)oxr.LoadCurrentElement());
Cfvos.Add(cfvo);
}
else if (oxr.ElementType == typeof(X14.Color))
{
clr = new SLColor(new List <Color>(), new List <Color>());
clr.FromExcel2010Color((X14.Color)oxr.LoadCurrentElement());
Colors.Add(clr);
}
}
}
}
internal void FromColorScale(ColorScale cs)
{
SetAllNull();
SLConditionalFormatValueObject cfvo;
SLColor clr;
using (var oxr = OpenXmlReader.Create(cs))
{
while (oxr.Read())
{
if (oxr.ElementType == typeof(ConditionalFormatValueObject))
{
cfvo = new SLConditionalFormatValueObject();
cfvo.FromConditionalFormatValueObject((ConditionalFormatValueObject)oxr.LoadCurrentElement());
Cfvos.Add(cfvo);
}
else if (oxr.ElementType == typeof(Color))
{
clr = new SLColor(new List <System.Drawing.Color>(), new List <System.Drawing.Color>());
clr.FromSpreadsheetColor((Color)oxr.LoadCurrentElement());
Colors.Add(clr);
}
}
}
}
private void SetAllNull()
{
Is2010 = false;
MinimumType = SLConditionalFormatAutoMinMaxValues.Percentile;
MinimumValue = string.Empty;
MaximumType = SLConditionalFormatAutoMinMaxValues.Percentile;
MaximumValue = string.Empty;
Color = new SLColor(new List <Color>(), new List <Color>());
BorderColor = new SLColor(new List <Color>(), new List <Color>());
NegativeFillColor = new SLColor(new List <Color>(), new List <Color>());
NegativeBorderColor = new SLColor(new List <Color>(), new List <Color>());
AxisColor = new SLColor(new List <Color>(), new List <Color>());
MinLength = 10;
MaxLength = 90;
ShowValue = true;
}
private void SetAllNull()
{
Cfvo1 = new SLConditionalFormattingValueObject2010();
Cfvo2 = new SLConditionalFormattingValueObject2010();
FillColor = new SLColor(new List <Color>(), new List <Color>());
BorderColor = new SLColor(new List <Color>(), new List <Color>());
NegativeFillColor = new SLColor(new List <Color>(), new List <Color>());
NegativeBorderColor = new SLColor(new List <Color>(), new List <Color>());
AxisColor = new SLColor(new List <Color>(), new List <Color>());
MinLength = 10;
MaxLength = 90;
ShowValue = true;
Border = false;
Gradient = true;
Direction = X14.DataBarDirectionValues.Context;
NegativeBarColorSameAsPositive = false;
NegativeBarBorderColorSameAsPositive = true;
AxisPosition = X14.DataBarAxisPositionValues.Automatic;
}
private void SetAllNull()
{
clrTabColor = new SLColor(listThemeColors, listIndexedColors);
HasTabColor = false;
ApplyStyles = false;
SummaryBelow = false;
SummaryRight = false;
ShowOutlineSymbols = true;
AutoPageBreaks = true;
FitToPage = false;
SyncHorizontal = false;
SyncVertical = false;
SyncReference = string.Empty;
TransitionEvaluation = false;
TransitionEntry = false;
Published = true;
CodeName = string.Empty;
FilterMode = false;
EnableFormatConditionsCalculation = true;
}
private void InitialiseDataBarOptions(SLConditionalFormatDataBarValues DataBar, bool Is2010Default)
{
Is2010 = Is2010Default;
FillColor = new SLColor(new List <Color>(), new List <Color>());
BorderColor = new SLColor(new List <Color>(), new List <Color>());
NegativeFillColor = new SLColor(new List <Color>(), new List <Color>());
NegativeBorderColor = new SLColor(new List <Color>(), new List <Color>());
AxisColor = new SLColor(new List <Color>(), new List <Color>());
switch (DataBar)
{
case SLConditionalFormatDataBarValues.Blue:
FillColor.Color = Color.FromArgb(0xFF, 0x63, 0x8E, 0xC6);
BorderColor.Color = Color.FromArgb(0xFF, 0x63, 0x8E, 0xC6);
break;
case SLConditionalFormatDataBarValues.Green:
FillColor.Color = Color.FromArgb(0xFF, 0x63, 0xC3, 0x84);
BorderColor.Color = Color.FromArgb(0xFF, 0x63, 0xC3, 0x84);
break;
case SLConditionalFormatDataBarValues.Red:
FillColor.Color = Color.FromArgb(0xFF, 0xFF, 0x55, 0x5A);
BorderColor.Color = Color.FromArgb(0xFF, 0xFF, 0x55, 0x5A);
break;
case SLConditionalFormatDataBarValues.Orange:
FillColor.Color = Color.FromArgb(0xFF, 0xFF, 0xB6, 0x28);
BorderColor.Color = Color.FromArgb(0xFF, 0xFF, 0xB6, 0x28);
break;
case SLConditionalFormatDataBarValues.LightBlue:
FillColor.Color = Color.FromArgb(0xFF, 0x00, 0x8A, 0xEF);
BorderColor.Color = Color.FromArgb(0xFF, 0x00, 0x8A, 0xEF);
break;
case SLConditionalFormatDataBarValues.Purple:
FillColor.Color = Color.FromArgb(0xFF, 0xD6, 0x00, 0x7B);
BorderColor.Color = Color.FromArgb(0xFF, 0xD6, 0x00, 0x7B);
break;
}
NegativeFillColor.Color = Color.FromArgb(0xFF, 0xFF, 0x00, 0x00);
NegativeBorderColor.Color = Color.FromArgb(0xFF, 0xFF, 0x00, 0x00);
AxisColor.Color = Color.FromArgb(0xFF, 0x00, 0x00, 0x00);
if (Is2010Default)
{
vMinimumType = SLConditionalFormatAutoMinMaxValues.Automatic;
MinimumValue = string.Empty;
vMaximumType = SLConditionalFormatAutoMinMaxValues.Automatic;
MaximumValue = string.Empty;
MinLength = 0;
MaxLength = 100;
}
else
{
vMinimumType = SLConditionalFormatAutoMinMaxValues.Value;
MinimumValue = string.Empty;
vMaximumType = SLConditionalFormatAutoMinMaxValues.Value;
MaximumValue = string.Empty;
MinLength = 10;
MaxLength = 90;
}
ShowBarOnly = false;
bBorder = false;
bGradient = false;
vDirection = X14.DataBarDirectionValues.Context;
bNegativeBarColorSameAsPositive = false;
bNegativeBarBorderColorSameAsPositive = true;
vAxisPosition = X14.DataBarAxisPositionValues.Automatic;
}
