ConditionalFormattingModel Class

Represents the conditional formatting model for a sheet.

Inheritance

object

ConditionalFormattingModel

Implements

IConditionalFormattingModel

ICollection<ConditionalFormatting>

IEnumerable<ConditionalFormatting>

IOptimizedFilterConditionalFormattingModel

Namespace: FarPoint.Web.Spread

Assembly: FarPoint.Web.Spread.dll

Syntax

public class ConditionalFormattingModel : IConditionalFormattingModel, ICollection<ConditionalFormatting>, IEnumerable<ConditionalFormatting>, IEnumerable, IRangeSupport, ISerializeSupport, ISerializable, IOptimizedFilterConditionalFormattingModel

Public Class ConditionalFormattingModel
    Implements IConditionalFormattingModel, ICollection(Of ConditionalFormatting), IEnumerable(Of ConditionalFormatting), IEnumerable, IRangeSupport, ISerializeSupport, ISerializable, IOptimizedFilterConditionalFormattingModel

Constructors

Name	Description
ConditionalFormattingModel()	Initializes a new instance of the ConditionalFormattingModel class.
ConditionalFormattingModel(SheetView)	Initializes a new instance of the ConditionalFormattingModel class.
ConditionalFormattingModel(SerializationInfo, StreamingContext)	Initializes a new instance of the ConditionalFormattingModel class.

Properties

Name	Description
Count	Gets the number of elements contained in the ICollection<T>.
IsReadOnly	Gets a value that indicates whether the ICollection<T> is read-only.
this[int]	Gets the ConditionalFormatting at the specified index.

Methods

Name	Description
Add(ConditionalFormatting)	Adds an item to the ICollection<T>.
AddColumns(int, int)	Adds columns of cells after the specified column.
AddRows(int, int)	Adds rows of cells after the specified row.
AdjustSplittingConditionalFormattings()	Adjusts the ConditionalFormatting model when there are some ConditionalFormattings objects that need to be split.
Clear()	Removes all items from the ICollection<T>.
Clear(int, int, int, int)	Removes all of the contents from the cells in the specified range of cells.
Contains(ConditionalFormatting)	Determines whether the ICollection<T> contains a specific value.
Copy(int, int, int, int, int, int)	Copies a range of cells and pastes it into a range of cells at the specified location.
CopyTo(ConditionalFormatting[], int)	Copies to an array.
Find(int, int, int, int)	Finds all conditional formatting that takes effect in the specified cell range.
FindRules(int, int)	Finds all rules which take effect in the specified cell.
GetEnumerator()	Returns an enumerator that iterates through the collection.
Move(int, int, int, int, int, int)	Moves a range of cells and pastes it into a range of cells at the specified location.
OnChanged(ConditionalFormattingModelEventArgs)	Returns information about the event that was raised.
Remove(ConditionalFormatting)	Removes the first occurrence of a specific object from the ICollection<T>.
RemoveColumns(int, int)	Removes columns from the specified starting position.
RemoveRows(int, int)	Removes rows from the specified starting position.
Swap(int, int, int, int, int, int)	Swaps a range of cells from one specified location to another.

Events

Name	Description
Changed	Occurs when the user makes a change to the model that affects the conditional formatting of cells of the sheet.