GrapeCity.Documents.Excel.IDataBar.AppliesTo

AppliesTo Property

AppliesTo

Gets or sets the cell range to which this data bar conditional formatting rule is applied.

Use this property to read or change the IRange associated with the current data bar rule.

Declaration

IRange AppliesTo { get; set; }

Property AppliesTo As IRange

Property Value

Type	Description
IRange	The IRange to which this data bar rule is applied.

Examples

worksheet.Range["A1:A3"].Value = new object[,] {{10}, {30}, {20}};
IDataBar dataBar = worksheet.Range["A1:A3"].FormatConditions.AddDatabar();
IRange appliesTo = dataBar.AppliesTo;
string address = appliesTo.Address;