public XSSFColorScaleFormatting CreateColorScaleFormatting()
{
// Is it already there?
if (_cfRule.IsSetColorScale() && _cfRule.type == ST_CfType.colorScale)
{
return(ColorScaleFormatting as XSSFColorScaleFormatting);
}
// Mark it as being a Color Scale
_cfRule.type = (ST_CfType.colorScale);
// Ensure the right element
CT_ColorScale scale = null;
if (_cfRule.IsSetColorScale())
{
scale = _cfRule.colorScale;
}
else
{
scale = _cfRule.AddNewColorScale();
}
// Add a default set of thresholds and colors
if (scale.SizeOfCfvoArray() == 0)
{
CT_Cfvo cfvo;
cfvo = scale.AddNewCfvo();
cfvo.type = (ST_CfvoType)Enum.Parse(typeof(ST_CfvoType), RangeType.MIN.name);
cfvo = scale.AddNewCfvo();
cfvo.type = (ST_CfvoType)Enum.Parse(typeof(ST_CfvoType), RangeType.PERCENTILE.name);
cfvo.val = ("50");
cfvo = scale.AddNewCfvo();
cfvo.type = (ST_CfvoType)Enum.Parse(typeof(ST_CfvoType), RangeType.MAX.name);
for (int i = 0; i < 3; i++)
{
scale.AddNewColor();
}
}
// Wrap and return
return(new XSSFColorScaleFormatting(scale));
}
public IConditionalFormattingThreshold CreateThreshold()
{
return(new XSSFConditionalFormattingThreshold(_scale.AddNewCfvo()));
}
