Features

Formulas

Formulas

FlexSheet supports nearly 100 formulas and auto-completion.

Features

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.

using Microsoft.AspNetCore.Mvc;

namespace FlexSheetExplorer.Controllers
{
    public partial class FlexSheetController : Controller
    {
        public ActionResult Formulas()
        {
            return View();
        }
    }
}
@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>

}