Features

数式

数式

FlexSheetは、約100の数式と自動補完をサポートしています。

機能

数式

FlexSheetは、約100の数式と自動補完をサポートしています。数式演算はMicrosoft Excelとの整合性を考慮して作成されており、集計、数学計算、論理、およびテキストを処理できます。

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>

}