ASPxSpreadsheet.RegisterGlobalCustomFunction(ICustomFunction) Method

Registers the specified global custom function.

Namespace: DevExpress.Web.ASPxSpreadsheet

Assembly: DevExpress.Web.ASPxSpreadsheet.v23.2.dll

NuGet Package: DevExpress.Web.Office

Declaration

C#

public static void RegisterGlobalCustomFunction(
    ICustomFunction customFunction
)

VB.NET

Public Shared Sub RegisterGlobalCustomFunction(
    customFunction As ICustomFunction
)

Parameters

Name	Type	Description
customFunction	ICustomFunction	An object that supports the ICustomFunction interface.

Remarks

To create a custom function:

• Create a class that implements the ICustomFunction interface and performs the required calculations.
• Register the function using the static RegisterGlobalCustomFunction 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.

C#

void Application_Start(object sender, EventArgs e) {
    ...
    ASPxSpreadsheet.RegisterGlobalCustomFunction(new DiscountFunction());
    ...
}

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