# spreadsheet-editor-freeze-pane

> Spreadsheet editor demonstrating frozen rows and columns while scrolling through worksheet data.

**Framework:** aspnet-core  **Component:** Spreadsheet  **Variant:** freeze-pane

## 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-freeze-pane.json
```

**Install Package(s)**

```bash
dotnet add package Syncfusion.AspNetCore.Spreadsheet
```

**Notes**

- Syncfusion release: 2026 Volume 3 (v35.1.37)
- 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-freeze-pane/spreadsheet-editor.cshtml

```cshtml
@page
@namespace aspnet_core.SpreadsheetEditor.FreezePane
@model EJ2CoreSampleBrowser.SpreadsheetEditor.FreezePane.FreezePaneModel
@using Syncfusion.EJ2
@using Syncfusion.EJ2.Spreadsheet

    <div class="control-section">
        <ejs-spreadsheet id="spreadsheet" created="createdHandler">
            <e-spreadsheet-sheets>
                <e-spreadsheet-sheet name="Monthly Salary" frozenRows="2" frozenColumns="2" selectedRange="C1">
                    <e-spreadsheet-ranges>
                        <e-spreadsheet-range dataSource="@Model.DataSource" startCell="A2"></e-spreadsheet-range>
                    </e-spreadsheet-ranges>
                </e-spreadsheet-sheet>
            </e-spreadsheet-sheets>
        </ejs-spreadsheet>
    </div>

    <script>
        function createdHandler() {
            this.merge('A1:B1');
            this.cellFormat({ backgroundColor: '#4e4ee6', color: '#fff' }, 'A1:P2');
            this.numberFormat('$#,##0.00', 'C2:P10');
        }
    </script>

```

### src/components/spreadsheet-editor-freeze-pane/spreadsheet-editor.cshtml.cs

```cs
using System;
using System.Collections.Generic;
using Microsoft.AspNetCore.Mvc.RazorPages;

namespace EJ2CoreSampleBrowser.SpreadsheetEditor.FreezePane
{
    public class FreezePaneModel : PageModel
    {
        public List<object> DataSource { get; set; }

        public void OnGet()
        {
            // 8 months of salary data with two pay components (current/revised)
            // and a total column. The first 2 rows and 2 columns are frozen.
            DataSource = new List<object>();
            for (int m = 1; m <= 8; m++)
            {
                DataSource.Add(new
                {
                    Month = "Month " + m,
                    BasicSalary = 1500 + m * 25,
                    RevisedBasicSalary = 1575 + m * 25,
                    DA = 200,
                    RevisedDA = 220,
                    HRA = 500,
                    RevisedHRA = 575,
                    Conveyance = 150,
                    RevisedConveyance = 165,
                    Medical = 125,
                    RevisedMedical = 140,
                    Special = 100,
                    RevisedSpecial = 115,
                    TotalGross = "=SUM(C3,E3,G3,I3,K3,M3)",
                    RevisedTotal = "=SUM(D3,F3,H3,J3,L3,N3)",
                });
            }
        }
    }
}

```
