GrapeCity.Documents.Excel.IDataBarBorder

IDataBarBorder Interface

Represents the border of the data bars specified by a conditional formatting rule.

An IDataBarBorder object is used to configure whether a data bar shows a border and, if so, the border color and border type. Use BarBorder to obtain this interface from a data bar conditional formatting rule.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IDataBarBorder

Public Interface IDataBarBorder

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{1}, {2}, {3}, {4}, {5}};
IDataBar dataBar = worksheet.Range["A1:A5"].FormatConditions.AddDatabar();
IDataBarBorder border = dataBar.BarBorder;
border.Type = DataBarBorderType.Solid;
border.Color.Color = Color.Red;

Properties

Name	Description
Color	Gets an object that specifies the border color of data bars in a conditional formatting rule. Use the returned IFormatColor object to read or modify the border color for the current data bar rule.
Type	Gets the border type for data bars specified by a conditional formatting rule. The returned value indicates whether the data bar border is disabled or displayed as a solid border.

Name

Description

Color

Gets an object that specifies the border color of data bars in a conditional formatting rule.

Use the returned IFormatColor object to read or modify the border color for the current data bar rule.

Type

Gets the border type for data bars specified by a conditional formatting rule.

The returned value indicates whether the data bar border is disabled or displayed as a solid border.