| Name | Description | |
|---|---|---|
 | AppliesTo | Returns a IRange object specifying the cell range to which the formatting rule is applied. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| AxisColor | Returns the color of the axis for cells with conditional formatting as data bars. |
| AxisPosition | Gets or sets the position of the axis of the data bars specified by a conditional formatting rule. |
| BarBorder | Returns an object that specifies the border of a data bar. |
| BarColor | Returns a FormatColor object that you can use to modify the color of the bars in a data bar conditional format. |
| BarFillType | Gets or sets how a data bar is filled with color. |
| Borders | Returns a IBorders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format). (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| DateOperator | Gets or sets the date operator used in the format condition. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| Direction | Gets or sets the direction the databar is displayed. |
| Font | Returns a IFont object that represents the font of the specified object. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| Formula1 | Returns the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| Formula2 | Returns the value or expression associated with the second part of a conditional format or data validation. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| Interior | Returns an IInterior object that represents the interior of the specified object. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| MaxPoint | Returns a IConditionValue object that specifies how the longest bar is evaluated for a data bar conditional format. |
| MinPoint | Returns a IConditionValue object that specifies how the shortest bar is evaluated for a data bar conditional format. |
| NegativeBarFormat | Returns the INegativeBarFormat object associated with a data bar conditional formatting rule. |
| NumberFormat | Gets or sets the number format applied to a cell if the conditional formatting rule evaluates to true. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| Operator | Returns a FormatConditionOperator value that represents the operator for the conditional format. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| PercentMax | Gets or sets an integer value that specifies the length of the longest data bar as a percentage of cell width. |
| PercentMin | Gets or sets an integer value that specifies the length of the shortest data bar as a percentage of cell width. |
| Priority | Gets or sets the priority value of the conditional formatting rule. The priority determines the order of evaluation when multiple conditional formatting rules exist in a worksheet. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| ShowValue | Gets or sets a Boolean value that specifies if the value in the cell is displayed if the data bar conditional format is applied to the range. |
| StopIfTrue | Gets or sets a System.Boolean value that determines if additional formatting rules on the cell should be evaluated if the current rule evaluates to true. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| Text | Gets or sets a System.String value specifying the text string used by the conditional formatting rule. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| TextOperator | Gets or sets one of the constants of the ContainsOperator enumeration, specifying the text search performed by the conditional formatting rule. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| Type | Gets a FormatConditionType value that represents the format condition type. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
IDatabar Interface Members
In This Topic
The following tables list the members exposed by IDatabar.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | Delete | Deletes this conditional format. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| Modify | Modifies an existing conditional format. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| ModifyAppliesToRange | Modifies an existing text conditional format. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| SetFirstPriority | Sets the priority value for this conditional formatting rule to "1" so that it will be evaluated before all other rules on the worksheet. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
| SetLastPriority | Sets the evaluation order for this conditional formatting rule so it is evaluated after all other rules on the worksheet. (Inherited from GrapeCity.Spreadsheet.IFormatCondition) |
See Also