GrapeCity.Documents.Excel.INegativeBarFormat

INegativeBarFormat Interface

Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.

Use this interface to configure how negative values are displayed in a data bar rule, including whether their fill and border use dedicated colors or the same colors as positive data bars.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface INegativeBarFormat

Public Interface INegativeBarFormat

Examples

worksheet.Range["A1:A4"].Value = new object[,] {{-10}, {-5}, {0}, {20}};
IDataBar dataBar = worksheet.Range["A1:A4"].FormatConditions.AddDatabar();
INegativeBarFormat negativeBarFormat = dataBar.NegativeBarFormat;
negativeBarFormat.ColorType = DataBarNegativeColorType.Color;
negativeBarFormat.BorderColorType = DataBarNegativeColorType.SameAsPositive;

Properties

Name	Description
BorderColor	Gets a FormatColor object that you can use to specify the border color for negative data bars. Use the returned IFormatColor object to customize the dedicated border color when BorderColorType is set to Color.
BorderColorType	Gets or sets whether to use the same border color as positive data bars. This property returns a DataBarNegativeColorType value that indicates whether negative data bars use the same border color as positive data bars or use the color specified by BorderColor.
Color	Gets a FormatColor object that you can use to specify the fill color for negative data bars. Use the returned IFormatColor object to customize the dedicated fill color when ColorType is set to Color.
ColorType	Gets or sets whether to use the same fill color as positive data bars.