Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]ASP.NET WebForms Controls
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Web
  [Expand]DevExpress.Web.ASPxGauges
  [Expand]DevExpress.Web.ASPxGauges.Base
  [Expand]DevExpress.Web.ASPxGauges.Scripts
  [Expand]DevExpress.Web.ASPxHtmlEditor
  [Expand]DevExpress.Web.ASPxHtmlEditor.Localization
  [Expand]DevExpress.Web.ASPxHtmlEditor.Scripts
  [Expand]DevExpress.Web.ASPxPivotGrid
  [Expand]DevExpress.Web.ASPxPivotGrid.Data
  [Expand]DevExpress.Web.ASPxPivotGrid.HtmlControls
  [Expand]DevExpress.Web.ASPxPivotGrid.Scripts
  [Expand]DevExpress.Web.ASPxRichEdit
  [Expand]DevExpress.Web.ASPxRichEdit.Localization
  [Expand]DevExpress.Web.ASPxRichEdit.Scripts
  [Expand]DevExpress.Web.ASPxScheduler
  [Expand]DevExpress.Web.ASPxScheduler.Commands.Dialogs
  [Expand]DevExpress.Web.ASPxScheduler.Controls
  [Expand]DevExpress.Web.ASPxScheduler.Dialogs
  [Expand]DevExpress.Web.ASPxScheduler.Drawing
  [Expand]DevExpress.Web.ASPxScheduler.Localization
  [Expand]DevExpress.Web.ASPxScheduler.Reporting
  [Expand]DevExpress.Web.ASPxScheduler.Scripts
  [Expand]DevExpress.Web.ASPxSpellChecker
  [Expand]DevExpress.Web.ASPxSpellChecker.Localization
  [Expand]DevExpress.Web.ASPxSpellChecker.Scripts
  [Collapse]DevExpress.Web.ASPxSpreadsheet
   [Collapse]ASPxSpreadsheet Class
     ASPxSpreadsheet Members
     ASPxSpreadsheet Constructor
    [Expand]ASPxSpreadsheet Properties
    [Expand]ASPxSpreadsheet Events
    [Collapse]ASPxSpreadsheet Methods
      AddImage Method
      Close Method
      CreateDefaultRibbonTabs Method
      GetCurrentDocumentPath Method
      GetImageDirectory Method
      GetWorkDirectory Method
      IsInternalServiceCallback Method
      New Method
     [Expand]Open Method
      RaiseDocumentSelectorCloudProviderRequest Method
      RaiseDocumentSelectorFileUploading Method
      RaiseDocumentSelectorFolderCreating Method
      RaiseDocumentSelectorItemCopying Method
      RaiseDocumentSelectorItemDeleting Method
      RaiseDocumentSelectorItemMoving Method
      RaiseDocumentSelectorItemRenaming Method
      RegisterGlobalCustomFunction Method
      Save Method
     [Expand]SaveCopy Method
   [Expand]ASPxSpreadsheetLoadingPanelSettings Class
   [Expand]ASPxSpreadsheetSettingsBase Class
    InitializeDocumentEventHandler Delegate
    SaveFileDialogDisplaySectionMode Enumeration
   [Expand]SpreadsheetClientSideEvents Class
   [Expand]SpreadsheetDialogFormSettings Class
   [Expand]SpreadsheetDialogSettings Class
   [Expand]SpreadsheetDocumentSelectorCommonSettings Class
   [Expand]SpreadsheetDocumentSelectorSettings Class
   [Expand]SpreadsheetFileManagerCommonSettings Class
   [Expand]SpreadsheetFileManagerEditingSettings Class
   [Expand]SpreadsheetFileManagerFoldersSettings Class
   [Expand]SpreadsheetFileManagerUploadSettings Class
   [Expand]SpreadsheetFileManagerValidationSettings Class
   [Expand]SpreadsheetFormsSettings Class
   [Expand]SpreadsheetFormulaAutoCompeteStyles Class
   [Expand]SpreadsheetFormulaBarButtonImageProperties Class
   [Expand]SpreadsheetFormulaBarButtonSectionStyles Class
   [Expand]SpreadsheetFormulaBarStyles Class
   [Expand]SpreadsheetImages Class
   [Expand]SpreadsheetInitializeDocumentEventArgs Class
   [Expand]SpreadsheetInsertLinkDialogSettings Class
   [Expand]SpreadsheetInsertPictureDialogSettings Class
   [Expand]SpreadsheetRibbonContextTabCategoryCollection Class
    SpreadsheetRibbonMode Enumeration
   [Expand]SpreadsheetRibbonTabCollection Class
   [Expand]SpreadsheetSaveFileDialogSettings Class
   [Expand]WorksheetDisplayArea Class
  [Expand]DevExpress.Web.ASPxSpreadsheet.Localization
  [Expand]DevExpress.Web.ASPxSpreadsheet.Scripts
  [Expand]DevExpress.Web.ASPxTreeList
  [Expand]DevExpress.Web.ASPxTreeList.Internal
  [Expand]DevExpress.Web.ASPxTreeList.Localization
  [Expand]DevExpress.Web.ASPxTreeList.Scripts
  [Expand]DevExpress.Web.Captcha
  [Expand]DevExpress.Web.Data
  [Expand]DevExpress.Web.Internal
  [Expand]DevExpress.Web.Localization
  [Expand]DevExpress.Web.Mvc
  [Expand]DevExpress.Web.Mvc.BinderSettings
  [Expand]DevExpress.Web.Mvc.Controllers
  [Expand]DevExpress.Web.MVC.Scripts
  [Expand]DevExpress.Web.Mvc.UI
  [Expand]DevExpress.Web.Office
  [Expand]DevExpress.Web.Office.Internal
  [Expand]DevExpress.Web.Rendering
  [Expand]DevExpress.Web.Scripts
  [Expand]DevExpress.XtraCharts.Web
  [Expand]DevExpress.XtraCharts.Web.Designer
  [Expand]DevExpress.XtraCharts.Web.Scripts
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

ASPxSpreadsheet.RegisterGlobalCustomFunction Method

Registers the specified global custom function.

Namespace:DevExpress.Web.ASPxSpreadsheet
Assembly:DevExpress.Web.ASPxSpreadsheet.v17.2.dll

Expanded Syntax

Parameters

customFunction
Type: ICustomFunction
An object that supports the DevExpress.Spreadsheet.Functions.ICustomFunction interface.

Expanded Remarks

To create a custom function:

  • Create a class that implements the DevExpress.Spreadsheet.Functions.ICustomFunction interface and performs the required calculations.
  • Register the function using the RegisterGlobalCustomFunction static method - pass an instance of your function-implementation class as the method's parameter.

It is recommended that you register custom functions only once at the application level. The following code illustrates how this can be done in the Global.asax file's Application_Start method.

To see the complete implementation of a custom function, refer to the Global Custom Functions online demo.

Expanded See Also

How would you rate this topic?​​​​​​​