Spreadsheet Functions
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