- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.Web.Chart Assembly
-
FarPoint.Web.Spread Assembly
-
FarPoint.Web.Spread
-
Classes
- AlternatingRow
- AlternatingRows
- Appearance
- AppearanceProperty
- AutoFilter
- AutoFilteredColumnEventArgs
- AutoFilteringColumnEventArgs
- AverageConditionalFormattingRule
- Background
- BaseCellType
- BaseDropDownCellType
- BaseFilterItem
- BaseSparkline
- BestFitColumnRule
- BetweenValuesConditionalFormattingRule
- BlankConditionalFormattingRule
- Border
- BorderProperty
- ButtonCellType
- CalendarDropDownStyleInfo
- Cell
- CellTypeConverter
- Cells
- CheckBoxCellType
- ColorFilterItem
- Column
- ColumnFooter
- ColumnHeader
- ColumnHeaderFilterCellType
- ColumnSparklineRenderer
- Columns
- Columns.DefaultColumn
- ComboBoxCellType
- CommandBarInfo
- ConditionalFormat
- ConditionalFormatCollection
- ConditionalFormatInfo
- ConditionalFormatting
- ConditionalFormattingColorValue
- ConditionalFormattingColorValueCollection
- ConditionalFormattingIconRuleSet
- ConditionalFormattingIconValue
- ConditionalFormattingModel
- ConditionalFormattingModelEventArgs
- ConditionalFormattingRule
- ConditionalFormattingRulePropertyChangedEventArgs
- ConditionalFormattingValue
- ConditionalFormattingValueCollection
- ContextMenu
- ContextMenuCollection
- ContextMenuStyle
- CreateButtonEventArgs
- CreateChildViewEventArgs
- CurrencyCellType
- CurrencyCellType.EditModeSettings
- CustomFilterItem
- DataFieldConverter
- DatabarConditionalFormattingRule
- DateTimeCellType
- DateTimeCellType.EditModeSettings
- DefaultFilterItem
- DefaultRowFilter
- DefaultSkins
- DefaultSparklineContainer
- DefaultStyleCollection
- DesignTimeCellTypeConverter
- DoubleCellType
- DoubleCellType.EditModeSettings
- DynamicFilterItem
- EmptyCellType
- ErrorConditionalFormattingRule
- ErrorForm
- ExcelBaseSparkLineRenderer
- ExcelSparkline
- ExcelSparklineGroup
- ExcelSparklineSetting
- ExpressionConsumerFormulaInfo
- ExtraRendererSettings
- FetchGroupTextEventArgs
- FilterBar
- FilterBarCellType
- FilterColumnDefinition
- FilterColumnDefinitionCollection
- FilterCondition
- FilterItemCollection
- FilterItemValue
- FilterItemValueCollection
- FloatingObject
- FormulaConditionalFormattingRule
- FormulaEntry
- FormulaEntryCollection
- FormulaExtender
- FormulaRestrictedException
- FpSpread
- FpSpreadTemplateReplacement
- GeneralCellType
- GroupInfo
- GroupInfoCollection
- GroupingEventArgs
- HideRowFilter
- HierBarInfo
- HighlightConditionalFormattingRule
- HighlightConditionalFormattingStyle
- HyperLinkCellType
- IconFilterItem
- IconSetConditionalFormattingRule
- ImageCellType
- Inset
- IntegerCellType
- IntegerCellType.EditModeSettings
- ItemEventArgs
- ItemEventArgs<T>
- ItemPropertyEventArgs<T>
- ItemTrackedEventArgs
- LabelCellType
- LandscapeRule
- LayoutCell
- LayoutCells
- LayoutColumn
- LayoutColumns
- LayoutRow
- LayoutRows
- LayoutTemplate
- LineSparklineRenderer
- ListBoxCellType
- ListItem
- MeasureIconSizeEventArgs
- MenuItem
- MenuItemClickEventArgs
- MenuItemCollection
- MultiColumnComboBoxCellType
- MultiValuesFilterItem
- NamedStyle
- NamedStyleCollection
- NamedStyleCollectionEventArgs
- PagerInfo
- ParentStyleNameConverter
- PercentCellType
- PrePaintConditionalFormattingRule
- PrePaintResult
- PrePaintTextConditionalFormattingRule
- PrePaintTextResult
- PreviewRowInfo
- PreviewRowTemplateContainer
- PrintAbortEventArgs
- PrintBackgroundEventArgs
- PrintEventArgs
- PrintExternalImageEventArgs
- PrintInfo
- PrintMargin
- PrintPDFEventArgs
- PropertyTrackChangedEventArgs
- RadioButtonListCellType
- RangeElement<T>
- RegExpCellType
- ReloadSheetCellRangeFormulaEventArgs
- Row
- RowEditTemplateContainer
- RowHeader
- Rows
- Rows.DefaultRow
- SaveExcelEventArgs
- ScaleRule
- SheetCorner
- SheetSkin
- SheetStyleProperty
-
SheetView
- Constructors
- Fields
- Properties
-
Methods
- AddChart
- AddColumns
- AddImage
- AddRowToDataSource
- AddRows
- AddSpanCell
- AddSparkline
- AddSquareSparkline
- AddUnboundRows
- AutoFilterColumn
- AutoFilterReset
- ClearConditionalFormating
- ClearConditionalFormatings
- ClearRange
- ClearRowFilter
- ClearSparklineGroupsInRange
- ClearSparklines
- CreateColumnAxisModel
- CreateDataModel
- CreateRowAxisModel
- CreateSelectionModel
- CreateSpanModel
- CreateStyleModel
- ExpandAll
- ExpandRow
- FindChildView
- FirePropertyChanged
- FlushData
- GetCellFromTag
- GetCellType
- GetChildRelation
- GetChildView
- GetChildViewName
- GetChildVisible
- GetClip
- GetClipValue
- GetColumnAllowFilter
- GetColumnAutoText
- GetColumnFromTag
- GetColumnLabel
- GetColumnMerge
- GetColumnSizeable
- GetColumnSortIndicator
- GetColumnVisible
- GetColumnWidth
- GetConditionalFormatting
- GetCustomName
- GetDataKey
- GetDefaultEditor
- GetDefaultRenderer
- GetDropDownFilterItems
- GetEditor
- GetExpression
- GetFormatter
- GetFormula
- GetGroupFooterInfo
- GetGroupInfo
- GetModelColumnFromViewColumn
- GetModelRowFromViewRow
- GetNote
- GetRenderer
- GetRowAutoText
- GetRowExpandable
- GetRowFromTag
- GetRowHeight
- GetRowLabel
- GetRowMerge
- GetRowSizeable
- GetRowVisible
- GetSelections
- GetSpanCell
- GetSparkline
- GetStyleInfo
- GetTag
- GetText
- GetUnboundValue
- GetValidConditionalFormat
- GetValue
- GetViewColumnFromModelColumn
- GetViewRowFromModelRow
- GroupSparkline
- InitPropArray
- InitStyle
- InvalidateRowFilter
- IsColumnBound
- IsRowBound
- IsRowExpanded
- LoadFormulas
- LoadTextFile
- LoadViewState
- MoveColumn
- MoveRow
- OnAddColumnFooterRows
- OnAddColumnHeaderRows
- OnAddColumns
- OnAddRowHeaderColumns
- OnAddRows
- OnDataModelChanged
- OnRemoveColumnFooterRows
- OnRemoveColumnHeaderRows
- OnRemoveColumns
- OnRemoveRowHeaderColumns
- OnRemoveRows
- Open
- OpenExcel
- Recalculate
- RecalculateAll
- RemoveColumns
- RemoveRows
- RemoveSpanCell
- Reset
- ResetViewColumnIndexes
- ResetViewRowIndexes
- Save
- SaveHtml
- SaveTextFile
- SaveTextFileRange
- SaveViewState
- SetChildVisible
- SetClip
- SetClipValue
- SetColumnLabel
- SetColumnMerge
- SetColumnSizeable
- SetColumnSortIndicator
- SetColumnVisible
- SetColumnWidth
- SetConditionalFormatting
- SetExpression
- SetFormula
- SetModelDataColumn
- SetNote
- SetRowExpandable
- SetRowHeight
- SetRowLabel
- SetRowMerge
- SetRowSizeable
- SetRowVisible
- SetStyleInfo
- SetTag
- SetText
- SetValue
- ShouldSerializePrintInfo
- Sort
- SortColumns
- SortRows
- ToString
- UngroupSparkline
- SheetViewCollection
- SheetViewStateEventArgs
- SmartPaperRule
- SmartPrintRule
- SmartPrintRulesCollection
- SortInfo
- Sparkline
- SparklineModelUpdateEventArgs
- SpreadCommandEventArgs
- SpreadControlBuilder
- SpreadDataSource
- SpreadDataSourceView
- SpreadFontStyle
- SpreadImage
- SpreadImageCollection
- SpreadImageCollectionEditor
- SpreadImageRender
- SpreadSparklineRenderes
- StateList<T>
- StateManaged
- StyleInfo
- StyleNameConverter
- StyleRowFilter
- TabInfo
- TagCloudCellType
- TextCellType
- TextConditionalFormattingRule
- ThreeColorScaleConditionalFormattingRule
- TimePeriodConditionalFormattingRule
- TitleInfo
- Top10FilterItem
- TopRankedValuesConditionalFormattingRule
- TouchInfo
- TouchStrip
- TouchStripCollection
- TouchStripItem
- TouchStripItemClickEventArgs
- TouchStripItemCollection
- TwoColorScaleConditionalFormattingRule
- UnaryComparisonConditionalFormattingRule
- UniqueOrDuplicatedConditionalFormattingRule
- ValidatorCollection
- WinLossSparklineRenderer
- WorksheetLayoutCell
- WorksheetLayoutCells
- WorksheetTemplate
- YearMonthFormat
- Structs
- Enums
- Interfaces
- Delegates
-
Classes
- FarPoint.Web.Spread.Chart
- FarPoint.Web.Spread.Data
- FarPoint.Web.Spread.Editor
- FarPoint.Web.Spread.Model
- FarPoint.Web.Spread.Renderer
-
FarPoint.Web.Spread
- FarPoint.Web.Spread.Extender Assembly
FarPoint.Web.Spread.SheetView.SetConditionalFormatting
SetConditionalFormatting Method
SetConditionalFormatting(int, int, params IConditionalFormattingRule[])
Sets conditional formatting for a specified cell on the sheet based on specified rules.
Declaration
public void SetConditionalFormatting(int row, int column, params IConditionalFormattingRule[] rules)Public Sub SetConditionalFormatting(row As Integer, column As Integer, ParamArray rules As IConditionalFormattingRule())Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Starting row index |
| int | column | Starting column index |
| IConditionalFormattingRule[] | rules | The specified rules to apply for a specified cell |
SetConditionalFormatting(int, int, bool, params IConditionalFormattingRule[])
Sets conditional formatting for a specified cell on the sheet based on specified rules.
Declaration
public void SetConditionalFormatting(int row, int column, bool combinable, params IConditionalFormattingRule[] rules)Public Sub SetConditionalFormatting(row As Integer, column As Integer, combinable As Boolean, ParamArray rules As IConditionalFormattingRule())Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Starting row index |
| int | column | Starting column index |
| bool | combinable | Rule(s) can be merged into an existing conditional format if they affect the same cell range(s). |
| IConditionalFormattingRule[] | rules | The specified rules to apply for a specified cell |
SetConditionalFormatting(int, int, int, int, params IConditionalFormattingRule[])
Sets conditional formatting for a specified range of cells on the sheet based on specified rules.
Declaration
public void SetConditionalFormatting(int row, int column, int rowCount, int columnCount, params IConditionalFormattingRule[] rules)Public Sub SetConditionalFormatting(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, ParamArray rules As IConditionalFormattingRule())Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Starting row index |
| int | column | Starting column index |
| int | rowCount | Number of rows |
| int | columnCount | Number of columns |
| IConditionalFormattingRule[] | rules | The specified rules to apply for a specified range of cells |
SetConditionalFormatting(int, int, int, int, bool, params IConditionalFormattingRule[])
Sets conditional formatting for a specified range of cells on the sheet based on specified rules.
Declaration
public void SetConditionalFormatting(int row, int column, int rowCount, int columnCount, bool combinable, params IConditionalFormattingRule[] rules)Public Sub SetConditionalFormatting(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, combinable As Boolean, ParamArray rules As IConditionalFormattingRule())Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Starting row index |
| int | column | Starting column index |
| int | rowCount | Number of rows |
| int | columnCount | Number of columns |
| bool | combinable | Rule(s) can be merged into an existing conditional format if they affect the same cell range(s). |
| IConditionalFormattingRule[] | rules | The specified rules to apply for a specified range of cells |
SetConditionalFormatting(CellRange[], params IConditionalFormattingRule[])
Sets conditional formatting for specified ranges of cells on the sheet based on specified rules.
Declaration
public void SetConditionalFormatting(CellRange[] cellRanges, params IConditionalFormattingRule[] rules)Public Sub SetConditionalFormatting(cellRanges As CellRange(), ParamArray rules As IConditionalFormattingRule())Parameters
| Type | Name | Description |
|---|---|---|
| CellRange[] | cellRanges | The cell ranges |
| IConditionalFormattingRule[] | rules | The specified rules to apply for a specified range of cells |
SetConditionalFormatting(CellRange[], bool, params IConditionalFormattingRule[])
Sets conditional formatting for specified ranges of cells on the sheet based on specified rules.
Declaration
public void SetConditionalFormatting(CellRange[] cellRanges, bool combinable, params IConditionalFormattingRule[] rules)Public Sub SetConditionalFormatting(cellRanges As CellRange(), combinable As Boolean, ParamArray rules As IConditionalFormattingRule())Parameters
| Type | Name | Description |
|---|---|---|
| CellRange[] | cellRanges | The cell ranges |
| bool | combinable | Rule(s) can be merged into an existing conditional format if they affect the same cell range(s). |
| IConditionalFormattingRule[] | rules | The specified rules to apply for a specified range of cells |
SetConditionalFormatting(params ConditionalFormatting[])
Sets conditional formatting for the sheet.
Declaration
public void SetConditionalFormatting(params ConditionalFormatting[] cfs)Public Sub SetConditionalFormatting(ParamArray cfs As ConditionalFormatting())Parameters
| Type | Name | Description |
|---|---|---|
| ConditionalFormatting[] | cfs | The conditional formatting |
- SetConditionalFormatting Method
- SetConditionalFormatting(int, int, params IConditionalFormattingRule[])
- Declaration
- Parameters
- SetConditionalFormatting(int, int, bool, params IConditionalFormattingRule[])
- Declaration
- Parameters
- SetConditionalFormatting(int, int, int, int, params IConditionalFormattingRule[])
- Declaration
- Parameters
- SetConditionalFormatting(int, int, int, int, bool, params IConditionalFormattingRule[])
- Declaration
- Parameters
- SetConditionalFormatting(CellRange[], params IConditionalFormattingRule[])
- Declaration
- Parameters
- SetConditionalFormatting(CellRange[], bool, params IConditionalFormattingRule[])
- Declaration
- Parameters
- SetConditionalFormatting(params ConditionalFormatting[])
- Declaration
- Parameters