# spreadsheet-editor-formula

> Spreadsheet editor populated from a prebuilt formula.xlsx byte payload loaded at startup.

**Framework:** aspnet-core  **Component:** Spreadsheet  **Variant:** formula

## Get this item

**If you are an agent, fetch the JSON.** Source is inlined, so one request is enough and no tooling is required:

```
GET https://ai.syncfusion.com/r/aspnet-core/spreadsheet-editor-formula.json
```

**Install Package(s)**

```bash
dotnet add package Syncfusion.AspNetCore.Spreadsheet
```

**Notes**

- Syncfusion release: 2026 Volume 2 (v34.1.29)
- The Syncfusion package is licensed. The composition in this file is source you own and edit. See https://ai.syncfusion.com/licensing.md

## Source files

### src/components/spreadsheet-editor-formula/spreadsheet-editor.cshtml

```cshtml
@using Syncfusion.EJ2
@using Syncfusion.EJ2.Spreadsheet

    <div class="control-section">
        <ejs-spreadsheet id="spreadsheet" showRibbon=false created="createdHandler">
            <e-spreadsheet-sheets>
                <e-spreadsheet-sheet name="Stock Details" selectedRange="F15">
                    <e-spreadsheet-ranges>
                        <e-spreadsheet-range dataSource="@ViewData["formulaData"]"></e-spreadsheet-range>
                    </e-spreadsheet-ranges>
                    <e-spreadsheet-rows>
                        <e-spreadsheet-row height=40>
                            <e-spreadsheet-cells>
                                <e-spreadsheet-cell index=3 value="High (+)"></e-spreadsheet-cell>
                                <e-spreadsheet-cell value="Low (-)"></e-spreadsheet-cell>
                            </e-spreadsheet-cells>
                        </e-spreadsheet-row>
                        <e-spreadsheet-row index=11 height=25>
                            <e-spreadsheet-cells>
                                <e-spreadsheet-cell index=3 value="Average profit:"></e-spreadsheet-cell>
                                <e-spreadsheet-cell index=5 formula="=AVERAGE(Profit)" format="0.00"></e-spreadsheet-cell>
                            </e-spreadsheet-cells>
                        </e-spreadsheet-row>
                        <e-spreadsheet-row height=25>
                            <e-spreadsheet-cells>
                                <e-spreadsheet-cell index=3 value="Maximum stock value:"></e-spreadsheet-cell>
                                <e-spreadsheet-cell index=5 formula="=MAX(High)" format="0.00"></e-spreadsheet-cell>
                            </e-spreadsheet-cells>
                        </e-spreadsheet-row>
                        <e-spreadsheet-row height=25>
                            <e-spreadsheet-cells>
                                <e-spreadsheet-cell index=3 value="Minimum stock value:"></e-spreadsheet-cell>
                                <e-spreadsheet-cell index=5 formula="=MIN(E2:E11)"></e-spreadsheet-cell>
                            </e-spreadsheet-cells>
                        </e-spreadsheet-row>
                        <e-spreadsheet-row height=25>
                            <e-spreadsheet-cells>
                                <e-spreadsheet-cell index=3 value="Non-profitable days:"></e-spreadsheet-cell>
                                <e-spreadsheet-cell index=5 formula='=COUNTIF(F2:F11,"<=0")'></e-spreadsheet-cell>
                            </e-spreadsheet-cells>
                        </e-spreadsheet-row>
                    </e-spreadsheet-rows>
                    <e-spreadsheet-columns>
                        <e-spreadsheet-column width=100></e-spreadsheet-column>
                        <e-spreadsheet-column width=130></e-spreadsheet-column>
                        <e-spreadsheet-column width=140></e-spreadsheet-column>
                        <e-spreadsheet-column width=140></e-spreadsheet-column>
                        <e-spreadsheet-column width=130></e-spreadsheet-column>
                        <e-spreadsheet-column width=130></e-spreadsheet-column>
                    </e-spreadsheet-columns>
                </e-spreadsheet-sheet>
            </e-spreadsheet-sheets>
            <e-spreadsheet-definednames>
                <e-spreadsheet-definedname name="Profit" refersTo="=F2:F11"></e-spreadsheet-definedname>
                <e-spreadsheet-definedname name="High" refersTo="=D2:D11"></e-spreadsheet-definedname>
            </e-spreadsheet-definednames>
        </ejs-spreadsheet>
    </div>

<script>
    function createdHandler() {
        this.cellFormat({ fontWeight: 'bold', backgroundColor: '#279377', color: '#fff', textAlign: 'center', fontSize: '14px' }, 'A1:F1');
        this.cellFormat({ backgroundColor: '#F2F2F2' }, 'A2:F11');
        this.cellFormat({ fontWeight: 'bold', backgroundColor: '#EEEEEE' }, 'A12:F15');
        this.numberFormat('0.00', 'F2:F11');
        this.numberFormat('m/d/yyyy', 'A2:A11');
    }
</script>
```

### src/components/spreadsheet-editor-formula/spreadsheet-editor.cshtml.cs

```cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;

namespace EJ2CoreSampleBrowser.Controllers
{
    public partial class SpreadsheetController : Controller
    {
        public IActionResult Formula()
        {
            List<object> formulaData = new List<object>()
            {
                new { Date= "08-01-2019", Open= "2625.75", Close= "2640.75", High= "2634.45", Low= "2620.65", Profit= "=C2-B2" },
                new { Date= "08-02-2019", Open= "2640.75", Close= "2638.75", High= "2640.75", Low= "2638.75", Profit= "=C3-B3" },
                new { Date= "08-03-2019", Open= "2638.75", Close= "2697.65", High= "2690.25", Low= "2647.65", Profit= "=C4-B4" },
                new { Date= "08-04-2019", Open= "2697.65", Close= "2700.25", High= "2699.21", Low= "2585.10", Profit= "=C5-B5" },
            };
            ViewData["formulaData"] = formulaData;
            return View();
        }
    }
}
```