public XSSFIconMultiStateFormatting CreateMultiStateFormatting(IconSet iconSet)
{
// Is it already there?
if (_cfRule.IsSetIconSet() && _cfRule.type == ST_CfType.iconSet)
{
return(MultiStateFormatting as XSSFIconMultiStateFormatting);
}
// Mark it as being an Icon Set
_cfRule.type = (ST_CfType.iconSet);
// Ensure the right element
CT_IconSet icons = null;
if (_cfRule.IsSetIconSet())
{
icons = _cfRule.iconSet;
}
else
{
icons = _cfRule.AddNewIconSet();
}
// Set the type of the icon set
if (iconSet.name != null)
{
ST_IconSetType xIconSet = XmlEnumParser <ST_IconSetType> .ForName(iconSet.name, ST_IconSetType.Item3TrafficLights1);
icons.iconSet = xIconSet;
}
// Add a default set of thresholds
int jump = 100 / iconSet.num;
ST_CfvoType type = (ST_CfvoType)Enum.Parse(typeof(ST_CfvoType), RangeType.PERCENT.name);
for (int i = 0; i < iconSet.num; i++)
{
CT_Cfvo cfvo = icons.AddNewCfvo();
cfvo.type = (type);
cfvo.val = (i * jump).ToString();
}
// Wrap and return
return(new XSSFIconMultiStateFormatting(icons));
}
public XSSFDataBarFormatting CreateDataBarFormatting(XSSFColor color)
{
// Is it already there?
if (_cfRule.IsSetDataBar() && _cfRule.type == ST_CfType.dataBar)
{
return(DataBarFormatting as XSSFDataBarFormatting);
}
// Mark it as being a Data Bar
_cfRule.type = ST_CfType.dataBar;
// Ensure the right element
CT_DataBar bar = null;
if (_cfRule.IsSetDataBar())
{
bar = _cfRule.dataBar;
}
else
{
bar = _cfRule.AddNewDataBar();
}
// Set the color
bar.color = (color.GetCTColor());
// Add the default thresholds
CT_Cfvo min = bar.AddNewCfvo();
min.type = (ST_CfvoType)Enum.Parse(typeof(ST_CfvoType), RangeType.MIN.name);
CT_Cfvo max = bar.AddNewCfvo();
max.type = (ST_CfvoType)Enum.Parse(typeof(ST_CfvoType), RangeType.MAX.name);
// Wrap and return
return(new XSSFDataBarFormatting(bar));
}
protected internal XSSFConditionalFormattingThreshold(CT_Cfvo cfvo)
{
this.cfvo = cfvo;
}
