Unplanned
Last Updated: 25 Feb 2026 16:51 by ADMIN
Roy
Created on: 12 Jun 2024 10:09
Category: Spreadsheet
Type: Feature Request
12
Honor protected (ReadOnly) worksheet and workbook

Please add support for protected worksheets and protected workbooks.

2 comments
ADMIN
Ivan Danchev
Posted on: 25 Feb 2026 16:51

Doug,

The version in which the behavior changes is 12.0.0. I checked the changes we have for that version and they are related to removing obsolete parameters of the nested components, e.g., Adaptive (the Toolbar is internally used by the Spreadsheet): https://www.telerik.com/blazor-ui/documentation/upgrade/breaking-changes/12-0-0 

Regards,
Ivan Danchev
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Doug
Posted on: 18 Feb 2026 22:56

I used to have a way around this using the code below when I was on version 7. In version 13 this no longer works and yet I see no reference to the spreadsheet component in the version history. Something obviously changed and now I have no way of marking cells as read only like I did in v7. This way wasn't great but it was the only solution I could find that worked to mark the first row as read only:

            for (var i = 1; i <= Constants.SpreadsheetRows - 1; i++)
            {
                for (int j = 0; j < columnTitles.Count; j++)
                {
                    worksheet.Cells[i, j].SetIsLocked(false);
                }
            }
            worksheet.Protect("pwd", WorksheetProtectionOptions.Default);