We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Filter/Search not working in Protected sheet

I have a Spreadsheet control which is using the Protected Sheet option to limit which cells users can edit. (see example below)

The problem is that when I set the Sheet to protected it seems to break the Filter/Sort window

I would expect it to look like the below (this is how it looks with Protection disabled)

What is odd is that I can still Filter/Order with the Context Menu when the Sheet is protected - just not through the UI screen.

Is there any way to enable the Filter/Order By window while keeping the functionality of Read Only

4 Replies

JS Janakiraman Sakthivel Syncfusion Team March 15, 2023 11:49 PM UTC

Hi Louis Miles.

We are validating your reported query and we will update you with further details on March 17th, 2023. We appreciate your patience until then.


Janakiraman S.

LM Louis Miles March 20, 2023 04:02 PM UTC

Was there any update on this query?

VR Vasanth Ravi Syncfusion Team March 21, 2023 02:43 PM UTC

Hi Louis,


As per Excel behavior, when the sheet is protected, the control restricts the user's ability to filter the data by making it read-only. On Excel, the filter pop-up will not be displayed, and even in the context menu, the filter option is disabled. That was the behavior.


Same as in a spreadsheet, when the sheet is protected, the control restricts displaying the filter pop-up. But upon validating, we noticed there is an issue with the context menu filter option. As per Excel, the context menu filter option should also be disabled.

Therefore, we have confirmed this as an issue "Need to disable the filter option on Context Menu while the sheet is protectedand logged a bug report, and it will be available in our upcoming April 5th , 2023 patch release. You can track the status of the issue via the feedback link below.

Feedback link for tracking purpose: https://www.syncfusion.com/feedback/42258/need-to-disable-the-filter-option-on-context-menu-while-the-sheet-is-protected

You will be informed regarding this once the fix is published.


Disclaimer: "Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works re prioritization."

VR Vasanth Ravi Syncfusion Team April 7, 2023 12:51 PM UTC

Hi Louis,

We are glad to announce that our weekly patch release (21.1.38) is rolled out. And we have included the fix for the reported issue " Need to disable the filter option on Context Menu while the sheet is protected" in this release. So, kindly upgrade your package versions to the latest to avail of these changes (21.1.38). 

NuGet Link:  https://www.nuget.org/packages/Syncfusion.EJ2.Spreadsheet.AspNet.Core/

Script Link : https://cdn.syncfusion.com/ej2/21.1.38/dist/ej2.min.js

CSS Link : https://cdn.syncfusion.com/ej2/21.1.38/material.css

Feedback Link:  https://www.syncfusion.com/feedback/42258/need-to-disable-the-filter-option-on-context-menu-while-the-sheet-is-protected

Get back to us if you need further assistance regarding.

Live Chat Icon For mobile
Up arrow icon