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