Click or drag to resize

Spire.Xls.Core.Spreadsheet.ConditionalFormatting Namespace

Classes
Class Description
Public class Average
Describe the Average conditional formatting rule. This conditional formatting rule highlights cells that are above or below the average for all values in the range.
Public class DataBarBorder
Represents the border of the data bars specified by a conditional formatting rule.
Public class NegativeBarFormat
Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.
Public class TopBottom
Describe the TopBottom conditional formatting rule. This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
Enumerations
Enumeration Description
Public enumeration DataBarAxisPosition
Specifies the axis position for a range of cells with conditional formatting as data bars.
Public enumeration DataBarBorderType
Specifies the border of a data bar.
Public enumeration DataBarFillType
Specifies how a data bar is filled with color.
Public enumeration DataBarNegativeColorType
Specifies whether to use the same border and fill color as postive data bars.
Public enumeration TextDirectionType
Represents text reading order.
Public enumeration TimePeriodType
Used in a FormatConditionType.TimePeriod conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied.