public DataBarFormatting CreateDataBarFormatting() { if (data_bar != null) { return(data_bar); } // Convert, Setup and return ConditionType = (CONDITION_TYPE_DATA_BAR); data_bar = new DataBarFormatting(); return(data_bar); }
private HSSFDataBarFormatting GetDataBarFormatting(bool create) { CFRule12Record cfRule12Record = GetCFRule12Record(create); DataBarFormatting databarFormatting = cfRule12Record.DataBarFormatting; if (databarFormatting != null) { return(new HSSFDataBarFormatting(cfRule12Record, sheet)); } else if (create) { databarFormatting = cfRule12Record.CreateDataBarFormatting(); return(new HSSFDataBarFormatting(cfRule12Record, sheet)); } else { return(null); } }
/// <summary> /// Creates a new Data Bar formatting /// </summary> /// <param name="sheet"></param> /// <param name="color"></param> /// <returns></returns> public static CFRule12Record Create(HSSFSheet sheet, ExtendedColorR color) { CFRule12Record r = new CFRule12Record(CONDITION_TYPE_DATA_BAR, ComparisonOperator.NO_COMPARISON); DataBarFormatting dbf = r.CreateDataBarFormatting(); dbf.Color = color; dbf.PercentMin = (byte)0; dbf.PercentMax = (byte)100; DataBarThreshold min = new DataBarThreshold(); min.SetType(RangeType.MIN.id); dbf.ThresholdMin = min; DataBarThreshold max = new DataBarThreshold(); max.SetType(RangeType.MAX.id); dbf.ThresholdMax = max; return(r); }
protected internal HSSFDataBarFormatting(CFRule12Record cfRule12Record, HSSFSheet sheet) { this.sheet = sheet; this.cfRule12Record = cfRule12Record; this.databarFormatting = this.cfRule12Record.DataBarFormatting; }
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); } }