Class ConditionalFormattingRuleCollection

Inheritance

System.Object

ConditionalFormattingRuleCollection

Namespace: DRIT.Spreadsheet.ConditionalFormatting

Assembly: DRIT.Spreadsheet.dll

Syntax

public class ConditionalFormattingRuleCollection : IEnumerable<ConditionalFormattingRule>

Properties

Item[Int32]

Declaration

public ConditionalFormattingRule this[int index] { get; }

Parameters

Type	Name	Description
System.Int32	index

Property Value

Type	Description
ConditionalFormattingRule

Methods

Add(ConditionalFormattingRule)

Declaration

public void Add(ConditionalFormattingRule item)

Parameters

Type	Name	Description
ConditionalFormattingRule	item

AddAboveAverage(Boolean)

Declaration

public AboveAverageFormattingRule AddAboveAverage(bool aboveAverage)

Parameters

Type	Name	Description
System.Boolean	aboveAverage

Returns

Type	Description
AboveAverageFormattingRule

AddCellValue(ConditionalFormattingOperator, Double[])

Declaration

public CellIsFormattingRule AddCellValue(ConditionalFormattingOperator conditionalFormattingOperator, params double[] values)

Parameters

Type	Name	Description
ConditionalFormattingOperator	conditionalFormattingOperator
System.Double[]	values

Returns

Type	Description
CellIsFormattingRule

AddDataBar(SpreadsheetColor)

Declaration

public DataBarFormattingRule AddDataBar(SpreadsheetColor color)

Parameters

Type	Name	Description
SpreadsheetColor	color

Returns

Type	Description
DataBarFormattingRule

AddDatesOccurring(TimePeriod)

Declaration

public DatesOccurringFormattingRule AddDatesOccurring(TimePeriod timePeriod)

Parameters

Type	Name	Description
TimePeriod	timePeriod

Returns

Type	Description
DatesOccurringFormattingRule

AddDuplicateValues()

Declaration

public DuplicateValuesFormattingRule AddDuplicateValues()

Returns

Type	Description
DuplicateValuesFormattingRule

AddExpression()

Declaration

public ExpressionFormattingRule AddExpression()

Returns

Type	Description
ExpressionFormattingRule

AddExpression(String)

Declaration

public ExpressionFormattingRule AddExpression(string formula1)

Parameters

Type	Name	Description
System.String	formula1

Returns

Type	Description
ExpressionFormattingRule

AddIconSet(IconSetType)

Declaration

public IconSetFormattingRule AddIconSet(IconSetType type)

Parameters

Type	Name	Description
IconSetType	type

Returns

Type	Description
IconSetFormattingRule

AddSpecificText(SpecificTextFormattingRuleType, String)

Declaration

public SpecificTextFormattingRule AddSpecificText(SpecificTextFormattingRuleType textOperator, string value)

Parameters

Type	Name	Description
SpecificTextFormattingRuleType	textOperator
System.String	value

Returns

Type	Description
SpecificTextFormattingRule

AddThreeColorScale(SpreadsheetColor, SpreadsheetColor, SpreadsheetColor)

Declaration

public ThreeColorScaleFormattingRule AddThreeColorScale(SpreadsheetColor minColor, SpreadsheetColor midColor, SpreadsheetColor maxColor)

Parameters

Type	Name	Description
SpreadsheetColor	minColor
SpreadsheetColor	midColor
SpreadsheetColor	maxColor

Returns

Type	Description
ThreeColorScaleFormattingRule

AddTimePeriod()

Declaration

public DatesOccurringFormattingRule AddTimePeriod()

Returns

Type	Description
DatesOccurringFormattingRule

AddTop10(Int32)

Declaration

public Top10FormattingRule AddTop10(int rank)

Parameters

Type	Name	Description
System.Int32	rank

Returns

Type	Description
Top10FormattingRule

AddTwoColorScale(SpreadsheetColor, SpreadsheetColor)

Declaration

public TwoColorScaleFormattingRule AddTwoColorScale(SpreadsheetColor minColor, SpreadsheetColor maxColor)

Parameters

Type	Name	Description
SpreadsheetColor	minColor
SpreadsheetColor	maxColor

Returns

Type	Description
TwoColorScaleFormattingRule

AddUniqueValues()

Declaration

public UniqueValuesFormattingRule AddUniqueValues()

Returns

Type	Description
UniqueValuesFormattingRule

GetEnumerator()

Declaration

public IEnumerator<ConditionalFormattingRule> GetEnumerator()

Returns

Type	Description
IEnumerator<ConditionalFormattingRule>