Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Global Custom Functions

  • UndoRedo
    Undo

    Undo
    po

  • Paste
    CutCopy
    Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Wrap TextMerge Cellspo
    Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po

  • Insert
    po
    Delete
    po
    Format
    po
    Cells

    Cells
    po
  • AutoSumpoFillpoClearpo

    Sort & Filterpo
    Find
    Editing

    Editing
    po

  • Format as Table
    Styles

    Styles
    po

  • Margins
    po
    Orientation
    po
    Size
    po
    dialogboxlauncherPage Setup

    Page Setuppo
  • dialogboxlauncherPrint

    Print
    po

  • Editing View
    Reading View
    Document Views

    Document Viewspo
  • Show

    Show
    po

  • Full Screen
    View

    View
    po

  • Freeze Panespo
    Window

    Window
    po
  • Properties

    Properties
    po
  • Convert to Range
    Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Modify Style
    Table Style Options

    Table Style Optionspo

  • Subtotals
    po
    Grand Totalspo
    Report Layoutpo

    Blank Rowspo
    Layout

    Layout
    po
  • PivotTable Style Options

    PivotTable Style Optionspo
 

The DevExpress ASP.NET Spreadsheet control (ASPxSpreadsheet) provides the capability to create your own custom functions. Custom functions are available for spreadsheet calculations and can be used in cell formulas in the same manner as built-in functions. A custom function executes a server custom code that performs the required calculation and returns the result.

Custom functions supported by the Spreadsheet are global - they can be accessed from all spreadsheet documents opened on the server. To create a custom function, implement the CustomFunction interface and register the function using the RegisterGlobalCustomFunction static method. It is recommended to register custom functions only once at the application level. The following demo code illustrates how this can be done in the Global.asax file's Application_Start method.

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

In this demo, the DiscountFunction custom function is defined. It is used in the C7 cell to calculate a discount based on the order's Quantity (C5) and Unit Price (C4) values. In the calculation, different discount rates are used depending on the total number of items in the order.


See Also:
Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxSpreadsheetDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxSpreadsheetDemos

Your Next Great ASP.NET App Starts Here

Get started today and download your 30-day trial of ASP.NET Controls and Libraries (includes 30 days of free technical support).
All demos ship with full source code and are included in the DevExpress ASP.NET distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress ASP.NET Controls and Libraries ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at info@devexpress.com or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.