- 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.AddChart
AddChart Method
AddChart(int, int, Type, int, int, int, int, ChartViewType, bool)
Adds the chart control.
Declaration
public SpreadChart AddChart(int row, int column, Type seriesType, int width, int height, int x, int y, ChartViewType viewType, bool showLegend)Public Function AddChart(row As Integer, column As Integer, seriesType As Type, width As Integer, height As Integer, x As Integer, y As Integer, viewType As ChartViewType, showLegend As Boolean) As SpreadChartParameters
| Type | Name | Description |
|---|---|---|
| int | row | The row. |
| int | column | The column. |
| Type | seriesType | Type of the series. |
| int | width | Width of the chart. |
| int | height | Height of the chart. |
| int | x | The X position. |
| int | y | The Y position. |
| ChartViewType | viewType | Type of the view. |
| bool | showLegend | if set to |
Returns
| Type | Description |
|---|---|
| SpreadChart |
AddChart(int, int, Type, int, int, int, int)
Adds the chart control.
Declaration
public SpreadChart AddChart(int row, int column, Type seriesType, int width, int height, int x, int y)Public Function AddChart(row As Integer, column As Integer, seriesType As Type, width As Integer, height As Integer, x As Integer, y As Integer) As SpreadChartParameters
| Type | Name | Description |
|---|---|---|
| int | row | The row. |
| int | column | The column. |
| Type | seriesType | Type of the series. |
| int | width | Width of the chart. |
| int | height | Height of the chart. |
| int | x | The X position. |
| int | y | The Y position. |
Returns
| Type | Description |
|---|---|
| SpreadChart |
AddChart(CellRange[], Type, int, int, int, int, ChartViewType, bool)
Adds a chart to the SheetView. The chart is aligned in the center of the SheetView.
Declaration
public SpreadChart AddChart(CellRange[] cellRanges, Type seriesType, int width, int height, int x, int y, ChartViewType viewType, bool showLegend)Public Function AddChart(cellRanges As CellRange(), seriesType As Type, width As Integer, height As Integer, x As Integer, y As Integer, viewType As ChartViewType, showLegend As Boolean) As SpreadChartParameters
| Type | Name | Description |
|---|---|---|
| CellRange[] | cellRanges | Multiple cell ranges that are used to create data for the chart. |
| Type | seriesType | Indicates which chart type is added. |
| int | width | Width of the chart. |
| int | height | Height of the chart. |
| int | x | The X position. |
| int | y | The Y position. |
| ChartViewType | viewType | Type of the view. |
| bool | showLegend | if set to |
Returns
| Type | Description |
|---|---|
| SpreadChart | The newly created instance of the chart. |
AddChart(CellRange[], Type, int, int, int, int)
Adds a chart to the SheetView. The chart is aligned in the center of the SheetView.
Declaration
public SpreadChart AddChart(CellRange[] cellRanges, Type seriesType, int width, int height, int x, int y)Public Function AddChart(cellRanges As CellRange(), seriesType As Type, width As Integer, height As Integer, x As Integer, y As Integer) As SpreadChartParameters
| Type | Name | Description |
|---|---|---|
| CellRange[] | cellRanges | Multiple cell ranges that are used to create data for the chart. |
| Type | seriesType | Indicates which chart type is added. |
| int | width | Width of the chart. |
| int | height | Height of the chart. |
| int | x | The X position. |
| int | y | The Y position. |
Returns
| Type | Description |
|---|---|
| SpreadChart | The newly created instance of the chart. |
AddChart(CellRange, Type, int, int, int, int, ChartViewType, bool)
Adds the chart control.
Declaration
public SpreadChart AddChart(CellRange cellRange, Type seriesType, int width, int height, int x, int y, ChartViewType viewType, bool showLegend)Public Function AddChart(cellRange As CellRange, seriesType As Type, width As Integer, height As Integer, x As Integer, y As Integer, viewType As ChartViewType, showLegend As Boolean) As SpreadChartParameters
| Type | Name | Description |
|---|---|---|
| CellRange | cellRange | The range of data used in the chart. |
| Type | seriesType | Type of the series. |
| int | width | Width of the chart. |
| int | height | Height of the chart. |
| int | x | The X position. |
| int | y | The Y position. |
| ChartViewType | viewType | Type of the view. |
| bool | showLegend | if set to |
Returns
| Type | Description |
|---|---|
| SpreadChart |
AddChart(CellRange, Type, int, int, int, int)
Adds the chart control.
Declaration
public SpreadChart AddChart(CellRange cellRange, Type seriesType, int width, int height, int x, int y)Public Function AddChart(cellRange As CellRange, seriesType As Type, width As Integer, height As Integer, x As Integer, y As Integer) As SpreadChartParameters
| Type | Name | Description |
|---|---|---|
| CellRange | cellRange | The range of data used in the chart. |
| Type | seriesType | Type of the series. |
| int | width | Width of the chart. |
| int | height | Height of the chart. |
| int | x | The X position. |
| int | y | The Y position. |
Returns
| Type | Description |
|---|---|
| SpreadChart |
- AddChart Method
- AddChart(int, int, Type, int, int, int, int, ChartViewType, bool)
- Declaration
- Parameters
- Returns
- AddChart(int, int, Type, int, int, int, int)
- Declaration
- Parameters
- Returns
- AddChart(CellRange[], Type, int, int, int, int, ChartViewType, bool)
- Declaration
- Parameters
- Returns
- AddChart(CellRange[], Type, int, int, int, int)
- Declaration
- Parameters
- Returns
- AddChart(CellRange, Type, int, int, int, int, ChartViewType, bool)
- Declaration
- Parameters
- Returns
- AddChart(CellRange, Type, int, int, int, int)
- Declaration
- Parameters
- Returns