# spreadsheet-editor-protection

> Spreadsheet editor demonstrating protected worksheets and locked cell editing behavior.

**Framework:** aspnet-core  **Component:** Spreadsheet  **Variant:** protection

## 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-protection.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-protection/spreadsheet-editor.cshtml

```cshtml
@page
@namespace aspnet_core.SpreadsheetEditor.Protection
@model EJ2CoreSampleBrowser.SpreadsheetEditor.Protection.ProtectionModel
@using Syncfusion.EJ2
@using Syncfusion.EJ2.Spreadsheet

    <div class="control-section">
        <ejs-spreadsheet id="spreadsheet" password="spreadsheet" created="createdHandler">
            <e-spreadsheet-sheets>
                <e-spreadsheet-sheet name="EMI Calculator" isProtected="true">
                    <e-spreadsheet-rows>
                        <e-spreadsheet-row height="40">
                            <e-spreadsheet-cells>
                                <e-spreadsheet-cell index="1" value="Loan Calculator"></e-spreadsheet-cell>
                            </e-spreadsheet-cells>
                        </e-spreadsheet-row>
                        <e-spreadsheet-row height="36">
                            <e-spreadsheet-cells>
                                <e-spreadsheet-cell index="1" value="Loan Amount"></e-spreadsheet-cell>
                                <e-spreadsheet-cell index="2" format="$#,##0.00" value="100000"></e-spreadsheet-cell>
                            </e-spreadsheet-cells>
                        </e-spreadsheet-row>
                        <e-spreadsheet-row height="36">
                            <e-spreadsheet-cells>
                                <e-spreadsheet-cell index="1" value="Interest Rate"></e-spreadsheet-cell>
                                <e-spreadsheet-cell index="2" format="0.00%" value="0.08"></e-spreadsheet-cell>
                            </e-spreadsheet-cells>
                        </e-spreadsheet-row>
                        <e-spreadsheet-row height="36">
                            <e-spreadsheet-cells>
                                <e-spreadsheet-cell index="1" value="Period (years)"></e-spreadsheet-cell>
                                <e-spreadsheet-cell index="2" value="1"></e-spreadsheet-cell>
                            </e-spreadsheet-cells>
                        </e-spreadsheet-row>
                    </e-spreadsheet-rows>
                    <e-spreadsheet-columns>
                        <e-spreadsheet-column index="1" width="190"></e-spreadsheet-column>
                        <e-spreadsheet-column width="100"></e-spreadsheet-column>
                    </e-spreadsheet-columns>
                </e-spreadsheet-sheet>
                <e-spreadsheet-sheet name="EMI Schedule" isProtected="true">
                    <e-spreadsheet-ranges>
                        <e-spreadsheet-range dataSource="@Model.ScheduleData" showFieldAsHeader="true"></e-spreadsheet-range>
                    </e-spreadsheet-ranges>
                </e-spreadsheet-sheet>
            </e-spreadsheet-sheets>
        </ejs-spreadsheet>
    </div>

    <script>
        function createdHandler() {
            this.numberFormat('$#,##0.00', 'EMI Schedule!C2:F13');
            this.numberFormat('m/d/yyyy', 'EMI Schedule!B2:B13');
        }
    </script>

```

### src/components/spreadsheet-editor-protection/spreadsheet-editor.cshtml.cs

```cs
using System;
using System.Collections.Generic;
using Microsoft.AspNetCore.Mvc.RazorPages;

namespace EJ2CoreSampleBrowser.SpreadsheetEditor.Protection
{
    public class ProtectionModel : PageModel
    {
        public List<object> ScheduleData { get; set; }

        public void OnGet()
        {
            ScheduleData = new List<object>
            {
                new { Tenure = "1", PaymentDate = "03-04-2025", EMI = "8698.84", Principal = "8032.18", Interest = "666.67", Balance = "91967.82" },
                new { Tenure = "2", PaymentDate = "04-04-2025", EMI = "8698.84", Principal = "8085.72", Interest = "613.12", Balance = "83882.10" },
                new { Tenure = "3", PaymentDate = "05-04-2025", EMI = "8698.84", Principal = "8139.63", Interest = "559.21", Balance = "75742.47" },
            };
        }
    }
}

```
