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) |