Functions

Jan 11, 2021

The DevExpress WinForms Spreadsheet control supports over 400 Excel compatible functions designed to address a broad range of usage scenarios. You can use basic mathematical functions to aggregate data within a spreadsheet or create complex formulas with statistical, engineering, and financial functions for advanced data analysis.

Below is the list of supported functions (grouped by category):

Mathematical and Trigonometry Functions
Statistical Functions
Date and Time Functions
Text Functions
Financial Functions
Logical Functions
Lookup and Reference Functions
Engineering Functions
Information Functions
Compatibility Functions
Database Functions
Web Functions
User-Defined Functions (UDF)
Real-Time Data (RTD) Function

The SpreadsheetControl.Options.Behavior.FunctionNameCulture property specifies whether to localize function names or use only English names in your application.

The FunctionWrapper class allows you to replace a built-in function with a custom function.