GrapeCity.Documents.Excel.IFormatConditions

IFormatConditions Interface

Represents the conditional formats associated with a range.

public interface IFormatConditions

Public Interface IFormatConditions

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.

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.