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