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.