Collection class for objects which derive from .
Inheritance
object
Implements
- IEnumerable<ConditionBase>
- IEnumerable
Properties
Section titled "Properties"Count
Section titled "Count"Returns the total number of items in the collection.
public int Count { get; }this[int]
Section titled "this[int]"Indexer
public ConditionBase this[int index] { get; }Methods
Section titled "Methods"AddAverageCondition(string, FormatConditionAboveBelow)
Section titled "AddAverageCondition(string, FormatConditionAboveBelow)"Adds a new instance to this collection.
public AverageConditionalFormat AddAverageCondition(string regionAddress, FormatConditionAboveBelow aboveBelow = FormatConditionAboveBelow.AboveAverage)Parameters
- regionAddress:
string - aboveBelow:
FormatConditionAboveBelow
Returns any
AddBlanksCondition(string)
Section titled "AddBlanksCondition(string)"Adds a new instance to this collection.
public BlanksConditionalFormat AddBlanksCondition(string regionAddress)Parameters
- regionAddress:
string
Returns any
AddColorScaleCondition(string, ColorScaleType)
Section titled "AddColorScaleCondition(string, ColorScaleType)"Adds a new instance to this collection.
public ColorScaleConditionalFormat AddColorScaleCondition(string regionAddress, ColorScaleType colorScaleType)Parameters
- regionAddress:
string - colorScaleType:
ColorScaleType
Returns any
AddDataBarCondition(string)
Section titled "AddDataBarCondition(string)"Adds a new instance to this collection.
public DataBarConditionalFormat AddDataBarCondition(string regionAddress)Parameters
- regionAddress:
string
Returns any
AddDateTimeCondition(string, FormatConditionTimePeriod)
Section titled "AddDateTimeCondition(string, FormatConditionTimePeriod)"Adds a new instance to this collection.
public DateTimeConditionalFormat AddDateTimeCondition(string regionAddress, FormatConditionTimePeriod dateOperator = FormatConditionTimePeriod.Today)Parameters
- regionAddress:
string - dateOperator:
FormatConditionTimePeriod
Returns any
AddDuplicateCondition(string)
Section titled "AddDuplicateCondition(string)"Adds a new instance to this collection, configured as a duplicate value condition.
public DuplicateConditionalFormat AddDuplicateCondition(string regionAddress)Parameters
- regionAddress:
string
Returns any
AddErrorsCondition(string)
Section titled "AddErrorsCondition(string)"Adds a new instance to this collection.
public ErrorsConditionalFormat AddErrorsCondition(string regionAddress)Parameters
- regionAddress:
string
Returns any
AddFormulaCondition(string, string, CellReferenceMode?)
Section titled "AddFormulaCondition(string, string, CellReferenceMode?)"Adds a new instance to this collection.
public FormulaConditionalFormat AddFormulaCondition(string regionAddress, string formula, CellReferenceMode? cellReferenceMode = null)Parameters
- regionAddress:
string - formula:
string - cellReferenceMode:
CellReferenceMode?
Returns any
AddIconSetCondition(string, FormatConditionIconSet)
Section titled "AddIconSetCondition(string, FormatConditionIconSet)"Adds a new instance to this collection.
public IconSetConditionalFormat AddIconSetCondition(string regionAddress, FormatConditionIconSet iconSet = FormatConditionIconSet.IconSet3TrafficLights1)Parameters
- regionAddress:
string - iconSet:
FormatConditionIconSet
Returns any
AddNoBlanksCondition(string)
Section titled "AddNoBlanksCondition(string)"Adds a new instance to this collection.
public NoBlanksConditionalFormat AddNoBlanksCondition(string regionAddress)Parameters
- regionAddress:
string
Returns any
AddNoErrorsCondition(string)
Section titled "AddNoErrorsCondition(string)"Adds a new instance to this collection.
public NoErrorsConditionalFormat AddNoErrorsCondition(string regionAddress)Parameters
- regionAddress:
string
Returns any
AddOperatorCondition(string, FormatConditionOperator)
Section titled "AddOperatorCondition(string, FormatConditionOperator)"Adds a new instance to this collection.
public OperatorConditionalFormat AddOperatorCondition(string regionAddress, FormatConditionOperator conditionOperator = FormatConditionOperator.Equal)Parameters
- regionAddress:
string - conditionOperator:
FormatConditionOperator
Returns any
AddRankCondition(string, FormatConditionTopBottom, int)
Section titled "AddRankCondition(string, FormatConditionTopBottom, int)"Adds a new instance to this collection.
public RankConditionalFormat AddRankCondition(string regionAddress, FormatConditionTopBottom topBottom = FormatConditionTopBottom.Top, int rank = 10)Parameters
- regionAddress:
string - topBottom:
FormatConditionTopBottom - rank:
int
Returns any
AddTextCondition(string, string, FormatConditionTextOperator)
Section titled "AddTextCondition(string, string, FormatConditionTextOperator)"Adds a new instance to this collection.
public TextOperatorConditionalFormat AddTextCondition(string regionAddress, string text = null, FormatConditionTextOperator textOperator = FormatConditionTextOperator.BeginsWith)Parameters
- regionAddress:
string - text:
string - textOperator:
FormatConditionTextOperator
Returns any
AddUniqueCondition(string)
Section titled "AddUniqueCondition(string)"Adds a new instance to this collection, configured as a unique value condition.
public UniqueConditionalFormat AddUniqueCondition(string regionAddress)Parameters
- regionAddress:
string
Returns any
Clear()
Section titled "Clear()"Removes all items from the collection.
public void Clear()Returns any
Contains(ConditionBase)
Section titled "Contains(ConditionBase)"Returns true if the collection contains the condition
public bool Contains(ConditionBase condition)Parameters
- condition:
ConditionBase
Returns any
GetEnumerator()
Section titled "GetEnumerator()"Returns an enumerator for the items in the collection.
public IEnumerator<ConditionBase> GetEnumerator()Returns any
IndexOf(ConditionBase)
Section titled "IndexOf(ConditionBase)"Gets the index of the item in the collection
public int IndexOf(ConditionBase condition)Parameters
- condition:
ConditionBase
Returns any
Remove(ConditionBase)
Section titled "Remove(ConditionBase)"Removes an item from the collection
public bool Remove(ConditionBase condition)Parameters
- condition:
ConditionBase
Returns any
RemoveAt(int)
Section titled "RemoveAt(int)"Removes an item from the collection at a specifoed index
public void RemoveAt(int index)Parameters
- index:
int