public IconMultiStateFormatting CreateMultiStateFormatting() { if (multistate != null) { return(multistate); } // Convert, Setup and return ConditionType = (CONDITION_TYPE_ICON_SET); multistate = new IconMultiStateFormatting(); return(multistate); }
/// <summary> /// Creates a new Icon Set / Multi-State formatting /// </summary> /// <param name="sheet"></param> /// <param name="iconSet"></param> /// <returns></returns> public static CFRule12Record Create(HSSFSheet sheet, IconSet iconSet) { Threshold[] ts = new Threshold[iconSet.num]; for (int i = 0; i < ts.Length; i++) { ts[i] = new IconMultiStateThreshold(); } CFRule12Record r = new CFRule12Record(CONDITION_TYPE_ICON_SET, ComparisonOperator.NO_COMPARISON); IconMultiStateFormatting imf = r.CreateMultiStateFormatting(); imf.IconSet = iconSet; imf.Thresholds = ts; return(r); }
private HSSFIconMultiStateFormatting GetMultiStateFormatting(bool create) { CFRule12Record cfRule12Record = GetCFRule12Record(create); IconMultiStateFormatting iconFormatting = cfRule12Record.MultiStateFormatting; if (iconFormatting != null) { return(new HSSFIconMultiStateFormatting(cfRule12Record, sheet)); } else if (create) { iconFormatting = cfRule12Record.CreateMultiStateFormatting(); return(new HSSFIconMultiStateFormatting(cfRule12Record, sheet)); } else { return(null); } }
protected internal HSSFIconMultiStateFormatting(CFRule12Record cfRule12Record, HSSFSheet sheet) { this.sheet = sheet; this.cfRule12Record = cfRule12Record; this.iconFormatting = this.cfRule12Record.MultiStateFormatting; }
public CFRule12Record(RecordInputStream in1) { futureHeader = new FtrHeader(in1); ConditionType = ((byte)in1.ReadByte()); ComparisonOperation = ((byte)in1.ReadByte()); int field_3_formula1_len = in1.ReadUShort(); int field_4_formula2_len = in1.ReadUShort(); ext_formatting_length = in1.ReadInt(); ext_formatting_data = new byte[0]; if (ext_formatting_length == 0) { // 2 bytes reserved in1.ReadUShort(); } else { int len = ReadFormatOptions(in1); if (len < ext_formatting_length) { ext_formatting_data = new byte[ext_formatting_length - len]; in1.ReadFully(ext_formatting_data); } } Formula1 = (Formula.Read(field_3_formula1_len, in1)); Formula2 = (Formula.Read(field_4_formula2_len, in1)); int formula_scale_len = in1.ReadUShort(); formula_scale = Formula.Read(formula_scale_len, in1); ext_opts = (byte)in1.ReadByte(); priority = in1.ReadUShort(); template_type = in1.ReadUShort(); template_param_length = (byte)in1.ReadByte(); if (template_param_length == 0 || template_param_length == 16) { template_params = new byte[template_param_length]; in1.ReadFully(template_params); } else { //logger.Log(POILogger.WARN, "CF Rule v12 template params length should be 0 or 16, found " + template_param_length); in1.ReadRemainder(); } byte type = ConditionType; if (type == CONDITION_TYPE_COLOR_SCALE) { color_gradient = new ColorGradientFormatting(in1); } else if (type == CONDITION_TYPE_DATA_BAR) { data_bar = new DataBarFormatting(in1); } else if (type == CONDITION_TYPE_FILTER) { filter_data = in1.ReadRemainder(); } else if (type == CONDITION_TYPE_ICON_SET) { multistate = new IconMultiStateFormatting(in1); } }