Spreadsheet Functions

• Sep 19, 2023

The DevExpress Spreadsheet Document API 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
• Real-Time Data Function

See Also

How to: Use Functions and Nested Functions in Formulas