Example of Formula in ASP.NET Core Spreadsheet Control

Spreadsheet
Formula

This sample demonstrates the analysis of a company's stock value for a certain period with formula and named range feature.

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAY
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
DateOpenCloseHighLowProfit
8/1/20192625.752640.752634.452620.6515.00
8/2/20192640.752638.752640.752638.75-2.00
8/3/20192638.752697.652690.252647.6558.90
8/4/20192697.652700.252699.212585.12.60
8/5/20192700.252730.252727.652704.9530.00
8/6/20192730.252725.252727.452725.67-5.00
8/7/20192725.252778.752770.452730.653.50
8/8/20192778.752800.672790.272780.7821.92
8/9/20192800.672840.82838.782827.7840.13
8/10/20192840.82865.352863.32850.224.55
Average profit:23.96
Maximum stock value:2863.30
Minimum stock value:2585.1
Non-profitable days:2
=COUNTIF(F2:F11,"<=0")

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.

Transform your ASP.NET Core web apps today with Syncfusion® ASP.NET Core components
85+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE
opens in a new tab