/// <summary>
/// Creates a new Color Scale / Color Gradient formatting
/// </summary>
/// <param name="sheet"></param>
/// <returns></returns>
public static CFRule12Record CreateColorScale(HSSFSheet sheet)
{
int numPoints = 3;
ExtendedColorR[] colors = new ExtendedColorR[numPoints];
ColorGradientThreshold[] ts = new ColorGradientThreshold[numPoints];
for (int i = 0; i < ts.Length; i++)
{
ts[i] = new ColorGradientThreshold();
colors[i] = new ExtendedColorR();
}
CFRule12Record r = new CFRule12Record(CONDITION_TYPE_COLOR_SCALE,
ComparisonOperator.NO_COMPARISON);
ColorGradientFormatting cgf = r.CreateColorGradientFormatting();
cgf.NumControlPoints = (/*setter*/ numPoints);
cgf.Thresholds = (/*setter*/ ts);
cgf.Colors = (/*setter*/ colors);
return(r);
}
public Object Clone()
{
ExtendedColor exc = new ExtendedColor();
exc.type = type;
exc.tint = tint;
if (type == TYPE_INDEXED)
{
exc.colorIndex = colorIndex;
}
else if (type == TYPE_RGB)
{
exc.rgba = new byte[4];
Array.Copy(rgba, 0, exc.rgba, 0, 4);
}
else if (type == TYPE_THEMED)
{
exc.themeIndex = themeIndex;
}
return(exc);
}
/// <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);
}
