This sample demonstrates the analysis of a company's stock value for a certain period with formula and named range feature.
DEMO
DOCUMENTATION
SOURCE
The Spreadsheet component provides a built-in calculation library that supports most commonly used
formulas.
In this demo, a formula is specified to a cell using the formula property. The ranges are specified
using its name and its defined using definedNames property.
Key Features
- Built-in formulas - Perform calculations using a comprehensive set of Excel-compatible formulas and functions for mathematical, statistical, logical, text, and date operations.
- Named ranges - Define meaningful names for cell ranges and use them in formulas to improve readability and simplify maintenance.
- Automatic recalculation - Automatically updates formula results whenever dependent cell values change, ensuring calculations remain accurate.
- Custom formulas - Create and use user-defined formulas to support application-specific calculation requirements.
Learn how to apply built-in formulas and named ranges to perform spreadsheet calculations, as demonstrated in this sample.
Documentation Links
More Resource