[]
        
(Showing Draft Content)

FarPoint.Win.Spread.IConditionalFormatSupport

IConditionalFormatSupport Interface

Interface that supports conditional formatting of cells on a sheet.

Namespace: FarPoint.Win.Spread
Assembly: FarPoint.Win.Spread.dll
Syntax
public interface IConditionalFormatSupport
Public Interface IConditionalFormatSupport

Methods

Name Description
ClearConditionalFormats(int, int)

Removes all of the conditional formats from the cell at the specified row and column.

ConditionalFormatInvalidateCell(int, int)

Invalidates the conditional format cell that is specified.

ConditionalFormatInvalidateColumn(int)

Invalidates the conditional format cell that is specified.

ConditionalFormatInvalidateRow(int)

Invalidates the conditional format cell that is specified.

ConditionalFormatIsRowUsed(int)

Determines whether the specified row has a conditional format set.

ConditionalFormatNextNonEmptyColumnInRow(int, int)

Gets the next non-empty column in the specified row after the specified column that contains a conditional format.

GetCellConditionalFormats(ref int, ref int, bool)

Gets a conditional format for the next cell after the cell at the specified row and column.

GetColumnConditionalFormats(ref int, bool)

Gets a conditional format for the next column after the specified column.

GetConditionalFormats(int, int)

Gets a conditional format from the cell at the specified row and column.

GetConditionalFormats(ref int, ref int, bool)

Gets a conditional format for the next cell after the cell at the specified row and column.

GetRowConditionalFormats(ref int, bool)

Gets a conditional format for the next row after the specified row.

GetValidConditionalFormat(int, int, object, ISheetDataModel)

Gets the style for the first condition that is satisfied from the list of conditional formats for the cell at the specified row and column.

SetConditionalFormat(int, int, NamedStyle, ComparisonOperator, Expression, Expression)

Sets a parameterized conditional format for the cell at the specified row and column.

SetConditionalFormat(int, int, NamedStyle, ComparisonOperator, string)

Sets a parameterized conditional format for the cell at the specified row and column.

SetConditionalFormat(int, int, NamedStyle, ComparisonOperator, string, string)

Sets a parameterized conditional format for the cell at the specified row and column.

SetFormulaConditionalFormat(int, int, NamedStyle, string)

Sets a formula conditional format for the cell at the specified row and column.