This sample demonstrates the analysis of a company's stock value for a certain period with formula and named range feature.
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. More information about formula and named range support can be found in this documentation section.