- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.PDF Assembly
- FarPoint.Win Assembly
- FarPoint.Win.Chart Assembly
-
FarPoint.Win.Spread Assembly
-
FarPoint.Win.Spread
-
Classes
- Action
- ActionMap
- ActiveSheetChangingEventArgs
- AdvancedSearchDialog
- AdvanceEventArgs
- AlternatingRow
- AlternatingRows
- AnimatedDefaultFocusIndicatorRenderer
- AnnotationModeEventArgs
- Appearance
- AppearanceActionBase
- AppearanceStyleCollection
- AppearanceStyleInfo
- ApplyEventArgs
- AutoFilteredColumnEventArgs
- AutoFilteringColumnEventArgs
- AutoSortedColumnEventArgs
- AutoSortingColumnEventArgs
- AverageConditionalFormattingRule
- BaseDataValidator
- BaseFilterItem
- BaseSparkline
- BeforeRightClickEventArgs
- BeforeSettingPropertyValueEventArgs
- BeforeShowContextMenuEventArgs
- BestFitColumnRule
- BetweenValuesConditionalFormattingRule
- BlankConditionalFormattingRule
- CalculateExceptionEventArgs
- Cell
- CellClickEventArgs
- CellErrorTextChangedEventArgs
- CellFooter
- CellInfo
- CellInfoRange
- CellPadding
- Cells
- CellsEditorForm
- CellStyleNotify
- CellTouchStrip
- CellValidateInfoNeededEventArgs
- CellValueCommitErrorArgs
- ChangeEventArgs
- CharFormatValidator
- ChartTouchStrip
- ChildControlEventArgs
- ChildViewCreatedEventArgs
- ChildWorkbookCreatedEventArgs
- CircularCellChangedEventArgs
- CircularFormulaEventArgs
- CircularFormulaEventInfo
- ClipboardPastedEventArgs
- ClipboardPastingEventArgs
- ColorFilterItem
- Column
- ColumnClipInfo
- ColumnClipInfoRange
- ColumnFooter
- ColumnHeader
- Columns
- Columns.DefaultColumn
- ColumnSparklineRenderer
- ColumnTouchStrip
- ColumnViewportWidthChangedEventArgs
- ColumnWidthChangedEventArgs
- ColumnWidthChangeExtents
- ColumnWidthChangingEventArgs
- CombinedStyleInfo
- CompareCellValidator
- CompareStringValidator
- CompareValueBaseValidator
- CompareValueValidator
- ComplexSortInfo
- ConditionalFormat
- ConditionalFormatting
- ConditionalFormattingChangedEventArgs
- ConditionalFormattingColorValue
- ConditionalFormattingColorValueCollection
- ConditionalFormattingIconRuleSet
- ConditionalFormattingIconSetIndex
- ConditionalFormattingIconValue
- ConditionalFormattingModel
- ConditionalFormattingModelEventArgs
- ConditionalFormattingRule
- ConditionalFormattingRulePropertyChangedEventArgs
- ConditionalFormattingValue
- ConditionalFormattingValueCollection
- ConditionalStyleInfo
- ConditionalStyleItem
- ConditionalStyleItemCollection
- CustomFillSeriesList
- CustomFilterItem
- CustomFocusIndicatorRenderer
- CustomIconContainer
- CustomImageInfo
- CustomNameChangedEventArgs
- DataAddNewException
- DatabarConditionalFormattingRule
- DataColumnConfigureEventArgs
- DataFieldConverter
- DataValidationManager
- DefaultErrorIconRenderer
- DefaultFilterItem
- DefaultFocusIndicatorRenderer
- DefaultGroupFooter
- DefaultGroupFooterCollection
- DefaultNoteIndicatorRenderer
- DefaultRangeGroupModel
- DefaultRowFilter
- DefaultScrollBarRenderer
- DefaultSelectionRenderer
- DefaultSkins
- DefaultSparklineContainer
- DefaultSpreadSkins
- DefaultStyleCollection
- DelegateResolveEventArgs
- DialogCharEventArgs
- DialogKeyEventArgs
- DocumentPropertiesForm
- DragDropBlockCompletedEventArgs
- DragDropBlockEventArgs
- DragFillBlockCompletedEventArgs
- DragFillBlockEventArgs
- DragMoveCompletedEventArgs
- DragMoveCompletingEventArgs
- DragMoveEventArgs
- DynamicFilterItem
- DynamicStyleInfo
- DynamicStyleInfoContext
- EditErrorEventArgs
- EditingFocusIndicatorRenderer
- EditModeStartingEventArgs
- EditorNotifyEventArgs
- EncodingValidator
- EnhancedFocusIndicatorRenderer
- EnhancedInterfaceRenderer
- EnhancedScrollBarRenderer
- EnterCellEventArgs
- ErrorConditionalFormattingRule
- ErrorEventArgs
- EventNameConverter
- ExcelBaseSparkLineRenderer
- ExcelSparkline
- ExcelSparklineGroup
- ExcelSparklineSetting
- ExcludeListValidator
- ExpandEventArgs
- ExtraRendererSettings
- FilterBar
- FilterBarEventArgs
- FilterBarHitTestInformation
- FilterColumnDefinition
- FilterColumnDefinitionCollection
- FilterCondition
- FilterItemCollection
- FilterItemValue
- FilterItemValueCollection
- FlatFocusIndicatorRenderer
- FlatInterfaceRenderer
- FlatScrollBarRenderer
- FlatSelectionRenderer
- FocusProcess
- FormatCells
- FormulaConditionalFormattingRule
- FormulaTextBox
- FpBaseStatusBarElement
- FpHorizontalScrollBar
- FpScrollBar
- FpScrollBarButton
- FpScrollBarButtonBackwardHome
- FpScrollBarButtonBackwardLine
- FpScrollBarButtonBackwardPage
- FpScrollBarButtonClickEventArgs
- FpScrollBarButtonCollection
- FpScrollBarButtonForwardEnd
- FpScrollBarButtonForwardLine
- FpScrollBarButtonForwardPage
- FpScrollBarComboThumb
- FpScrollBarGripper
- FpScrollBarThumb
- FpScrollBarTrack
- FpScrollBarTrackBackward
- FpScrollBarTrackForward
-
FpSpread
- Constructors
- Events
-
Methods
- AddControl
- AddCustomFunction
- AddNewSheetView
- AddViewport
- AsWorkbook
- Attach
- CancelAnnotationMode
- CancelCellEditing
- ClearCustomFunctions
- CreateAccessibilityInstance
- CreateTableStyle
- Dispose
- GetActionMap
- GetActiveColumnViewportIndex
- GetActiveRowViewportIndex
- GetCellFromPixel
- GetCellRectangle
- GetColumnHeaderRectangle
- GetColumnPageBreaks
- GetColumnRangeGroupHeight
- GetColumnSplitBarRectangle
- GetColumnSplitBoxRectangle
- GetColumnViewportCount
- GetColumnViewportIndexFromX
- GetCursor
- GetCustomFunction
- GetCustomFunctionEnumerator
- GetExcelSheetNames
- GetFilterBarHeaderRectangle
- GetFilterBarRectangle
- GetHorizontalScrollBarRectangle
- GetInputMap
- GetInputMapWhenChildHasFocus
- GetInputMapWhenShapeHasFocus
- GetMaximumCellOverflowWidth
- GetOwnerPrintColumnPageBreaks
- GetOwnerPrintInfo
- GetOwnerPrintPageCount
- GetOwnerPrintRowPageBreaks
- GetPrintPageCount
- GetPrintPreview
- GetRootWorkbook
- GetRowHeaderRectangle
- GetRowPageBreaks
- GetRowRangeGroupWidth
- GetRowSplitBarRectangle
- GetRowSplitBoxRectangle
- GetRowViewportCount
- GetRowViewportIndexFromY
- GetSheetFromTag
- GetSheetTabRectangle
- GetTabSplitBoxRectangle
- GetTabStripRectangle
- GetVerticalScrollBarRectangle
- GetViewportBottomRow
- GetViewportLeftColumn
- GetViewportPreferredHeight
- GetViewportPreferredWidth
- GetViewportRectangle
- GetViewportRightColumn
- GetViewportTopRow
- GoalSeek
- HideDependents
- HideDragFillPopup
- HidePrecedents
- HideTouchKeyboard
- HitTest
- IsCellInView
- IsExcelFile
- IsExcelStream
- IsInputChar
- IsInputKey
- IsSpreadSSFile
- IsSpreadXmlFile
- LoadFormulas
- LoadXmlInputMapFile
- LoadXmlInputMapFileWhenChildHasFocus
- LoadXmlInputMapFileWhenShapeHasFocus
- OnActiveSheetChanged
- OnActiveSheetChanging
- OnActiveSpreadViewChanged
- OnActiveSpreadViewChanging
- OnAdvance
- OnAllowUserToTouchZoomChanged
- OnAnnotationModeEnding
- OnAnnotationModeStarting
- OnAutoFilteredColumn
- OnAutoFilteringColumn
- OnAutoScrollWhenKeyboardShowingChanged
- OnAutoSortedColumn
- OnAutoSortingColumn
- OnBoundaryFeedbackModeChanged
- OnButtonClicked
- OnCellClick
- OnCellDoubleClick
- OnCellValidateInfoNeeded
- OnChange
- OnChildControlActivated
- OnChildControlDeactivated
- OnChildViewCreated
- OnChildWorkbookCreated
- OnCircularFormulaFpSpread
- OnClientSizeChanged
- OnClipboardChanged
- OnClipboardChanging
- OnClipboardPasted
- OnClipboardPasting
- OnColumnDragMove
- OnColumnDragMoveCompleted
- OnColumnDragMoveCompleting
- OnColumnViewportWidthChanged
- OnColumnWidthChanged
- OnColumnWidthChanging
- OnComboCloseUp
- OnComboDropDown
- OnComboSelChange
- OnDataColumnConfigure
- OnDialogChar
- OnDialogKey
- OnDoubleClick
- OnDragDropBlock
- OnDragDropBlockCompleted
- OnDragFillBlock
- OnDragFillBlockCompleted
- OnEditChange
- OnEditError
- OnEditModeOff
- OnEditModeOn
- OnEditModeStarting
- OnEditorFocused
- OnEnabledChanged
- OnEnterCell
- OnError
- OnExpand
- OnFilterBarClick
- OnFilterBarDoubleClick
- OnGotFocus
- OnGrouped
- OnGrouping
- OnHandleCreated
- OnHandleDestroyed
- OnHeaderIndicatorPositionAdjustingChanged
- OnHelpRequested
- OnHyperLinkClicked
- OnImeModeChanged
- OnInputScopeChanged
- OnKeyDown
- OnKeyPress
- OnKeyUp
- OnLeaveCell
- OnLeftChange
- OnLostFocus
- OnMouseDown
- OnMouseEnter
- OnMouseLeave
- OnMouseMove
- OnMouseUp
- OnMouseWheel
- OnPaint
- OnPaintBackground
- OnPaintGrayArea
- OnPaintGroupBarBackground
- OnPaintTabStrip
- OnPaintTabStripButton
- OnPaintTabStripTab
- OnPanningModeChanged
- OnPreviewKeyDown
- OnPreviewRowFetch
- OnPrintAbort
- OnPrintBackground
- OnPrintCancelled
- OnPrintDocument
- OnPrintHeaderFooterArea
- OnPrintMessageBox
- OnPrintPreviewShowing
- OnRangeGroupStateChanged
- OnRangeGroupStateChanging
- OnResize
- OnResizeZeroIndicatorChanged
- OnRightToLeftChanged
- OnRowDragMove
- OnRowDragMoveCompleted
- OnRowDragMoveCompleting
- OnRowHeightChanged
- OnRowHeightChanging
- OnRowViewportHeightChanged
- OnScrollTipFetch
- OnSearchDialogClosing
- OnSelectionChanged
- OnSelectionChanging
- OnShapeActivated
- OnShapeDeactivated
- OnSheetDragMoved
- OnSheetDragMoving
- OnSheetTabClick
- OnSheetTabDoubleClick
- OnShowGrippersInEditingStatusChanged
- OnSizeChanged
- OnSorted
- OnSorting
- OnSubEditorClosed
- OnSubEditorOpening
- OnTapToAddSelectionChanged
- OnTextTipFetch
- OnTopChange
- OnTouchDropDownScaleChanged
- OnTouchSelectionGripperBackColorChanged
- OnTouchSelectionGripperLineColorChanged
- OnTouchSelectionGripperThicknessChanged
- OnTouchStripOpening
- OnTouchZoomSnapDistanceChanged
- OnUngrouped
- OnUseOptimizedSelectionForTouchChanged
- OnUserFormulaEntered
- OnUserZooming
- OnValidating
- OnVisibleChanged
- Open
- OpenExcel
- OpenSpreadFile
- OwnerPrintDraw
- PerformLayout
- PreProcessMessage
- PrintSheet
- ProcessCmdKey
- ProcessDialogChar
- ProcessDialogKey
- ProcessKeyPreview
- RemoveControl
- RemoveCustomFunction
- RemoveViewport
- Reset
- ResetCellNoteIndicatorRenderer
- ResetFocusRenderer
- ResumeLayout
- Save
- SaveExcel
- SaveXmlInputMapFile
- SaveXmlInputMapFileWhenChildHasFocus
- SaveXmlInputMapFileWhenShapeHasFocus
- ScaleControl
- ScaleCore
- Search
- SearchHeaders
- SearchWithDialog
- SearchWithDialogAdvanced
- Select
- SetActionMap
- SetActiveViewport
- SetCursor
- SetInputMap
- SetInputMapWhenChildHasFocus
- SetInputMapWhenShapeHasFocus
- SetInsertSheetImage
- SetMaximumCellOverflowWidth
- SetPrintInfo
- SetPrintPreview
- SetProtect
- SetToolTip
- SetViewportLeftColumn
- SetViewportPreferredHeight
- SetViewportPreferredWidth
- SetViewportTopRow
- ShouldSerializeGroupBarText
- ShouldSerializeNamedStyles
- ShouldSerializeSaveNamedStyles
- ShowActiveCell
- ShowCell
- ShowCellValidatorsForm
- ShowCollectionEditor
- ShowColumn
- ShowDataValidationForm
- ShowDependents
- ShowEditForm
- ShowInputMapEditor
- ShowListCustomNameForm
- ShowPageSetup
- ShowPrecedents
- ShowRow
- ShowShape
- ShowTouchKeyboard
- StartAnnotationMode
- StartCellEditing
- StartCropping
- StartInkNotation
- StopAnnotationMode
- StopCellEditing
- SuspendLayout
- TriggerVolatileCells
- WndProc
- Properties
- FpStatusBarAverageElement
- FpStatusBarCountElement
- FpStatusBarElementCollection
- FpStatusBarMaxElement
- FpStatusBarMinElement
- FpStatusBarNumericalCountElement
- FpStatusBarRangeStatusElement
- FpStatusBarRangeStatusFormatElement
- FpStatusBarSumElement
- FpStatusBarTextElement
- FpVerticalScrollBar
- GetCustomIconEventArgs
- GradientInterfaceRenderer
- GradientSelectionRenderer
- GridLine
- GroupBarInfo
- GroupInfo
- GroupInfoCollection
- GroupingEventArgs
- HeaderHitTestInformation
- HideRowFilter
- HighlightConditionalFormattingRule
- HighlightConditionalFormattingStyle
- HitTestInformation
- HyperLinkClickedEventArgs
- HyperlinkForm
- IconFilterItem
- IconNotify
- IconSetConditionalFormattingRule
- ImageFocusIndicatorRenderer
- IncludeListValidator
- InputMap
- InvalidFileFormatException
- ItemEventArgs
- ItemTrackedEventArgs
- KeystrokeFactory
- LandscapeRule
- LeaveCellEventArgs
- LeftChangeEventArgs
- LineNotify
- LineSparklineRenderer
- MarqueeFocusIndicatorRenderer
- MessageBoxNotify
- ModelessForm
- MultiValuesFilterItem
- NameBox
- NamedAppearanceStyleInfo
- NamedObjectCollection<T>
- NamedStyle
- NamedStyleCollection
- NamedStyleCollectionEventArgs
- NoteEventArgs
- OwnerPrintInfo
- PaintGrayAreaEventArgs
- PaintGroupBarBackgroundEventArgs
- PaintTabStripButtonEventArgs
- PaintTabStripEventArgs
- PaintTabStripTabEventArgs
- PairChar
- PairCharValidator
- ParentStyleNameConverter
- PrePaintConditionalFormattingRule
- PrePaintResult
- PrePaintTextConditionalFormattingRule
- PrePaintTextResult
- PreviewRowFetchEventArgs
- PreviewRowInfo
- PrintAbortEventArgs
- PrintBackgroundEventArgs
- PrintCancelledEventArgs
- PrintDocumentEventArgs
- PrintHeaderFooterAreaEventArgs
- PrintInfo
- PrintMargin
- PrintMessageBoxEventArgs
- PrintPreviewShowingEventArgs
- PropertyTrackChangedEventArgs
- QueryAccessibleObjectValueEventArgs
- QueryValueEventArgs
- RangeElement<T>
- RangeGroupHitTestInformation
- RangeGroupInfo
- RangeGroupInfoEventArgs
- RangeGroupModelEventArgs
- RangeGroupStateChangedEventArgs
- RangeGroupStateChangingEventArgs
- RangeValidator
- RecentItemsEventArgs<T>
- RegularExpressionValidator
- ReloadSheetCellRangeFormulaEventArgs
- RequiredFieldValidator
- RequiredTypeValidator
- ResolveActionEventArgs
- ResolveCustomControlEventArgs
- Row
- RowClipInfo
- RowClipInfoRange
- RowErrorTextChangedEventArgs
- RowHeader
- RowHeightChangedEventArgs
- RowHeightChangeExtents
- RowHeightChangingEventArgs
- Rows
- Rows.DefaultRow
- RowTouchStrip
- RowViewportHeightChangedEventArgs
- SaveNamedStyleCollection
- ScaleRule
- ScrollingContentInfo
- ScrollTipFetchEventArgs
- SearchDialog
- SelectionChangedEventArgs
- SelectionChangingEventArgs
- ShapeTouchStrip
- SheetCorner
- SheetDragMovedEventArgs
- SheetDragMovingEventArgs
- SheetSkin
- SheetSkinsForm
- SheetStyleProperty
- SheetTab
- SheetTabClickEventArgs
- SheetTabDoubleClickEventArgs
- SheetView
- SheetView.DocumentModels
- SheetView.MultipleColumnMovingException
- SheetView.MultipleRowMovingException
- SheetView.SaveAutoSortColumns
- SheetViewCollection
- SheetViewEventArgs
- SheetViewPropertyChangeEventArgs
- SmartPaperRule
- SmartPrintRule
- SmartPrintRulesCollection
- SolidFocusIndicatorRenderer
- SortArgs
- SortedEventArgs
- SortInfo
- SortingEventArgs
- SoundNotify
- Sparkline
- SparklineInfo
- SparklineModelUpdateEventArgs
- SpreadActions
- SpreadContextMenuStrip
- SpreadFontStyle
- SpreadHScrollBar
- SpreadSkin
- SpreadSkinsForm
- SpreadSparklineRenderes
- SpreadTouchStrip
- SpreadView
- SpreadVScrollBar
- StatusBarDefaultSkin
- StatusBarElementChangeArgs
- StatusBarSkin
- StickyNoteEventArgs
- StyleInfo
- StyleRowFilter
- SubEditorClosedEventArgs
- SubEditorOpeningEventArgs
- SurrogateCharValidator
- TableBorder
- TableElementStyle
- TablePropertyChangedEventArgs
- TablePropertyChangingEventArgs
- TableStyle
- TableStyleCollection
- TableStyleCollectionChangedEventArgs
- TableView
- TableViewClipboardInfo
- TableViewColumn
- TableViewColumnCollection
- TabStrip
- TabStripButtonClickEventArgs
- TabStripHitTestInformation
- TextConditionalFormattingRule
- TextLengthValidator
- TextTipFetchEventArgs
- ThreeColorScaleConditionalFormattingRule
- ThreeStateIconNotify
- TimePeriodConditionalFormattingRule
- TipAppearance
- TipNotify
- TitlebarHitTestInformation
- TitleInfo
- Top10FilterItem
- TopChangeEventArgs
- TopRankedValuesConditionalFormattingRule
- TouchStripButton
- TouchStripOpeningEventArgs
- TriangleNoteIndicatorRenderer
- TwoColorScaleConditionalFormattingRule
- UnaryComparisonConditionalFormattingRule
- UniqueOrDuplicatedConditionalFormattingRule
- UserFormulaEnteredEventArgs
- UserSpecifiedFilterItem
- ValidateActionBase
- ValidateActionCollection
- ValidateActionContext
- ValueProcess
- ViewportHitTestInformation
- WinLossSparklineRenderer
- ZoomEventArgs
- ZoomSliderStatusBarElement
- ZoomStatusBarElement
- Delegates
- Enums
- Interfaces
- Structs
-
Classes
- FarPoint.Win.Spread.CellType
- FarPoint.Win.Spread.Chart
- FarPoint.Win.Spread.Data
- FarPoint.Win.Spread.Dialogs
- FarPoint.Win.Spread.DrawingSpace
- FarPoint.Win.Spread.Model
- FarPoint.Win.Spread.UndoRedo
- FarPoint.Win.Spread.Visualization
-
FarPoint.Win.Spread
- GrapeCity.CalcEngine Assembly
- GrapeCity.Spreadsheet Assembly
- GrapeCity.Spreadsheet.WinForms.Ribbon Assembly
- GrapeCity.Win.PluginInputMan Assembly
FarPoint.Win.Spread.FpSpread.AddCustomFunction
AddCustomFunction Method
AddCustomFunction(Function)
Adds a user-defined custom function (GrapeCity.CalcEngine.Function object) to the model for use in formulas.
Declaration
public void AddCustomFunction(Function function)Public Sub AddCustomFunction([function] As [Function])Parameters
| Type | Name | Description |
|---|---|---|
| Function | function | The Function object of the custom function to add. |