Functions

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):

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.

See Also