GrapeCity.Documents.Excel.IFormatColor

IFormatColor Interface

Represents a format color item, such as a color scale threshold color, a data bar color, a data bar axis color, a negative data bar fill color or border color, or a sparkline color.

Use this interface to read or modify format colors exposed by APIs such as AxisColor, BarColor, Color, BorderColor, FormatColor, SeriesColor, and Color. It also provides access to palette-based, theme-based, and tint-adjusted settings for that format color item.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IFormatColor

Public Interface IFormatColor

Examples

worksheet.Range["A1:A3"].Value = new object[,] {{-10}, {0}, {20}};
IDataBar dataBar = worksheet.Range["A1:A3"].FormatConditions.AddDatabar();
IFormatColor axisColor = dataBar.AxisColor;
axisColor.Color = Color.Blue;

Properties

Name	Description
Color	Gets or sets the Color value for this format color item. Use this property to read the current Color value from an IFormatColor object obtained from a formatting API such as AxisColor, BarColor, FormatColor, or Color.
ColorIndex	Gets or sets the color index for this format color item in the current color palette.
ThemeColor	Gets or sets the ThemeColor constant used by this format color item.
TintAndShade	Gets or sets the tint and shade adjustment applied to this format color item. The value represents the tint and shade adjustment applied to the format color. A value from -1 (darkest) to 1 (lightest) is supported, and 0 is neutral.