[]
        
(Showing Draft Content)

GrapeCity.Spreadsheet.IFormatConditions

IFormatConditions Interface

Represents the collection of conditional formats for a single range.

Namespace: GrapeCity.Spreadsheet
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public interface IFormatConditions
Public Interface IFormatConditions

Properties

Name Description
Count

Gets the number of format conditions.

this[int]

Gets the IFormatCondition object at the specified index.

Methods

Name Description
Add(ContainsOperator, string)

Adds a new conditional format.

Add(FormatConditionType, FormatConditionOperator, string, string, ContainsOperator, TimePeriods)

Adds a new conditional format.

Add(TimePeriods)

Adds a new conditional format.

AddAboveAverage()

Returns a new IAboveAverage object representing a conditional formatting rule for the specified range.

AddColorScale(int)

Returns a new IColorScale object representing a conditional formatting rule that uses gradations in cell colors to indicate relative differences in the values of cells included in a selected range.

AddDatabar()

Returns a Databar object representing a data bar conditional formatting rule for the specified range.

AddIconSetCondition()

Returns a new IIconSetCondition object which represents an icon set conditional formatting rule for the specified range.

AddTop10()

Returns a ITop10 object representing a conditional formatting rule for the specified range.

AddUniqueValues()

Returns a new IUniqueValues object representing a conditional formatting rule for the specified range.

Delete()

Deletes all format conditions.