ConditionalFormatting Class

Represents a conditional format.

Inheritance

object

ConditionalFormatting

Implements

ICollection<IConditionalFormattingRule>

IEnumerable<IConditionalFormattingRule>

IEnumerable

IDeserializationCallback

ISerializeSupport

ICloneable

ISerializable

Namespace: FarPoint.Win.Spread

Assembly: FarPoint.Win.Spread.dll

Syntax

[TypeConverter(typeof(ConditionalFormatting._b))]
public sealed class ConditionalFormatting : SpreadConditionalFormatting, ICollection<IConditionalFormattingRule>, IEnumerable<IConditionalFormattingRule>, IEnumerable, IDeserializationCallback, ISerializeSupport, ICloneable, ISerializable

<TypeConverter(GetType(ConditionalFormatting._b))>
Public NotInheritable Class ConditionalFormatting
    Inherits SpreadConditionalFormatting
    Implements ICollection(Of IConditionalFormattingRule), IEnumerable(Of IConditionalFormattingRule), IEnumerable, IDeserializationCallback, ISerializeSupport, ICloneable, ISerializable

Constructors

Name	Description
ConditionalFormatting(CellRange)	Initializes a new instance of the ConditionalFormatting class.
ConditionalFormatting(CellRange, params IConditionalFormattingRule[])	Initializes a new instance of the ConditionalFormatting class.
ConditionalFormatting(IEnumerable<CellRange>)	Initializes a new instance of the ConditionalFormatting class.
ConditionalFormatting(IEnumerable<CellRange>, params IConditionalFormattingRule[])	Initializes a new instance of the ConditionalFormatting class.

Properties

Name	Description
AverageValue	Gets the average value.
Count	Gets the number of elements contained in the ICollection<T> object.
IsReadOnly	Gets whether the ICollection<T> object is read-only.
Ranges	Gets the ranges that the conditional formatting is applied to.
Rules	Gets the rules.
StandardDeviation	Gets the standard deviation.

Methods

Name	Description
Add(IConditionalFormattingRule)	Adds an item to the ICollection<T> object.
AddRange(IEnumerable<IConditionalFormattingRule>)	Adds the elements of the specified IConditionalFormattingRule collection to the ConditionalFormatting object.
Clear()	Removes all items from the ICollection<T> object.
Contains(IConditionalFormattingRule)	Determines whether the ICollection<T> collection contains a specific value.
CopyTo(IConditionalFormattingRule[], int)	Copies the items to a compatible one-dimensional array, starting at the specified index of the target array.
GetEnumerator()	Returns an enumerator that iterates through the collection.
GetListRules()	Gets the list of rule.
GetValue(int)	Gets the value.
NotifyFormulaChanged(object, FormulaChangedType)	Notifies the ConditionalFormatting object that the formula in the conditional formatting rule has changed.
Remove(IConditionalFormattingRule)	Removes the first occurrence of a specific object from the ICollection<T> collection.