The DevExpress WPF 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.