Spread for WPF provides support for built-in formulas, custom formulas, custom names, array formulas, and asynchronous functions. Users can insert formulas into cells, evaluate arithmetic expressions, and display the resulting values within cells based on their specific needs and preferences.
To learn more about the available formulas, functions, and operators, refer to the Formula Reference.
For detailed guidance on working with formulas, see the topics listed below.
| Topic | Description |
| Add a Formula Bar | Learn how to add a formula bar to your application. |
| Add Formula to Cell | Learn how to insert and configure formulas in cells. |
| Define Custom Names | Understand how to define and use custom names in a workbook or worksheet. |
| Array Formulas | Learn about creating and applying array formulas. |
| Dynamic Array Formulas | Learn about applying dynamic array formulas. |
| Nested Functions | Explore how to use nested functions within formulas. |
| Circular References | Manage and resolve circular references in formulas. |
| Goal Seek | Understand how to find input values for desired outputs in formulas. |
| External Variables | Understand how to work with external variables in formulas. |
| Auto-Recalculation and Updates | Enable automatic recalculation and updates for formulas. |
| AutoFormat Formulas | Automate formatting for formulas for improved readability. |
| Language Packages | Configure language support for formula functionality. |
