This example demonstrates how to programmatically use predefined functions in formulas to perform simple or complex calculations over arguments. Set the CellRange.Formula property to a formula. Follow the rules below to create a formula that uses a function.
- Start the formula with the "=" sign, as you usually do when creating formulas.
- Specify the function name.
- Specify the function arguments in parentheses. Arguments can be numbers, text and logical values, cell references and names, or other functions.
Local Copy of this Demo To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer. |
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos |