- 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.AddSparkline
AddSparkline Method
AddSparkline(SheetCellRange, CellRange, SparklineType, ExcelSparklineSetting)
Adds the sparkline.
Declaration
public ExcelSparklineGroup AddSparkline(SheetCellRange data, CellRange location, SparklineType type, ExcelSparklineSetting setting)Public Function AddSparkline(data As SheetCellRange, location As CellRange, type As SparklineType, setting As ExcelSparklineSetting) As ExcelSparklineGroupParameters
| Type | Name | Description |
|---|---|---|
| SheetCellRange | data | The data. |
| CellRange | location | The location. |
| SparklineType | type | The type. |
| ExcelSparklineSetting | setting | The setting. |
Returns
| Type | Description |
|---|---|
| ExcelSparklineGroup |
AddSparkline(SheetCellRange[], CellRange[], SparklineType, ExcelSparklineSetting)
Adds the sparkline.
Declaration
public ExcelSparklineGroup AddSparkline(SheetCellRange[] data, CellRange[] location, SparklineType type, ExcelSparklineSetting setting)Public Function AddSparkline(data As SheetCellRange(), location As CellRange(), type As SparklineType, setting As ExcelSparklineSetting) As ExcelSparklineGroupParameters
| Type | Name | Description |
|---|---|---|
| SheetCellRange[] | data | The data. |
| CellRange[] | location | The location. |
| SparklineType | type | The type. |
| ExcelSparklineSetting | setting | The setting. |
Returns
| Type | Description |
|---|---|
| ExcelSparklineGroup |
AddSparkline(string, string, SparklineType, ExcelSparklineSetting)
Adds the sparkline.
Declaration
public ExcelSparklineGroup AddSparkline(string dataRef, string locationRef, SparklineType type, ExcelSparklineSetting setting)Public Function AddSparkline(dataRef As String, locationRef As String, type As SparklineType, setting As ExcelSparklineSetting) As ExcelSparklineGroupParameters
| Type | Name | Description |
|---|---|---|
| string | dataRef | The data reference. |
| string | locationRef | The location reference. |
| SparklineType | type | The type. |
| ExcelSparklineSetting | setting | The setting. |
Returns
| Type | Description |
|---|---|
| ExcelSparklineGroup |
- AddSparkline Method
- AddSparkline(SheetCellRange, CellRange, SparklineType, ExcelSparklineSetting)
- Declaration
- Parameters
- Returns
- AddSparkline(SheetCellRange[], CellRange[], SparklineType, ExcelSparklineSetting)
- Declaration
- Parameters
- Returns
- AddSparkline(string, string, SparklineType, ExcelSparklineSetting)
- Declaration
- Parameters
- Returns