How to make a WinForms Spreadsheet (SfSpreadsheet) as read only?

1 min read

Protection

To make Spreadsheet as read only, you need to protect both Workbook and Worksheet using Protect and ProtectSheet method respectively, like below code example.

Spreadsheet.Protect(true, true,"");
Spreadsheet.ProtectSheet(Spreadsheet.ActiveSheet, "");

Samples:

WPF

WinForms

UWP

Reference link: Worksheet Management in Windows Forms Spreadsheet

Did you find this information helpful?

Yes

Comments (0)

How to make a WinForms Spreadsheet (SfSpreadsheet) as read only?

Protection

Access denied