[]
        
(Showing Draft Content)

GrapeCity.Documents.Excel.IFormatConditions

IFormatConditions Interface

Represents the conditional formats associated with a range.

Namespace: GrapeCity.Documents.Excel
Assembly: DS.Documents.Excel.dll
Syntax
public interface IFormatConditions
Public Interface IFormatConditions

Properties

Name Description
Count

Returns a value that represents the number of objects in the collection.

this[int]

Returns the conditional format specified by the zero-based index.

Methods

Name Description
Add(FormatConditionType, FormatConditionOperator, object, object)

Adds a new conditional format.

AddAboveAverage()

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

AddColorScale(ColorScaleType)

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 IDataBar 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 conditional formats associated with the represented range.

FromJson(string)

Generates the conditional formats from the json string.

ToJson()

Generates a json string from the conditional formats.