Features

Formulas

Formulas

FlexSheet supports nearly 100 formulas and auto-completion.

Features

Introduction
Data Binding
Sorting
Filtering
Format Cells
Multiple Headers
Cell Merging
Drag & Drop
Auto Filling
Frozen Cells
Formulas
Custom Function
Table
Excel I/O
Server Load
Remote Load/Save
Excel Service
Excel Html Entities
Calculation Precision

Formulas

FlexSheet supports nearly 100 formulas and auto-completion. Our formula operations were built to align with Microsoft Excel, including operations for aggregation, mathematics, logic and text.

1. Positive/Negative Numbers
  • Basic Operators
  • Math
  • Logical
  • Text
  • Aggregate
  • Date
  • Lookup & Reference
  • Financial
  • Summary
1
2
3
4
5
6
7
8
9
10
11
12
using Microsoft.AspNetCore.Mvc;
  
namespace FlexSheetExplorer.Controllers
{
    public partial class FlexSheetController : Controller
    {
        public ActionResult Formulas()
        {
            return View();
        }
    }
}
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
@section Scripts{<script type="text/javascript" src="~/Scripts/flexSheet/formulas.js"></script>}
<div>
    <div class="copy">
<h3>@Html.Raw(FlexSheetRes.Formulas_Text2)</h3>
  
<p>@Html.Raw(FlexSheetRes.Formulas_Text0)</p>
  
    </div>
    <div>
        <c1-flex-sheet id="formulaSheet" class="flexSheet">
            <c1-unbound-sheet name="Basic Operators" row-count="35" 
                              column-count="8"></c1-unbound-sheet>
            <c1-unbound-sheet name="Math" row-count="90"
                              column-count="8"></c1-unbound-sheet>
            <c1-unbound-sheet name="Logical" row-count="30"
                              column-count="8"></c1-unbound-sheet>
            <c1-unbound-sheet name="Text" row-count="80"
                              column-count="8"></c1-unbound-sheet>
            <c1-unbound-sheet name="Aggregate" row-count="170"
                              column-count="8"></c1-unbound-sheet>
            <c1-unbound-sheet name="Date" row-count="60"
                              column-count="9"></c1-unbound-sheet>
            <c1-unbound-sheet name="Lookup & Reference" row-count="55"
                              column-count="10"></c1-unbound-sheet>
            <c1-unbound-sheet name="Financial" row-count="20"
                              column-count="8"></c1-unbound-sheet>
            <c1-unbound-sheet name="Summary" row-count="20"
                              column-count="8"></c1-unbound-sheet>
        </c1-flex-sheet>
    </div>
</div>
@section Summary{
<p>@Html.Raw(FlexSheetRes.Formulas_Text1)</p>
  
}