Hi Markus,

I am afraid that at this point, there is no built-in setting for explicitly gathering the hidden state directly from the pre-existing Excel file. What I can personally do is forward this subject matter to our management team to assess whether or not it can be included in our roadmap.

And to further make sure that your feedback is not left unaddressed. I can personally add a statement in the previously linked feedback item to keep you posted.

Since this item is particularly within the realm of the Telerik UI for WPF suite, I would personally encourage you to be proactive in the linked feedback item from our previous discussion. This will help preserve the logged feedback items in a more product-oriented manner.

Kind Regards,
Alexander
Progress Telerik

Hi Markus,

In terms of the Telerik UI for ASP.NET Core Spreadsheet component incarnation, I am afraid there are currently no built-in API configurations for deliberately toggling the visibility options for a particular sheet.

We have a public feedback item for the inclusion of such a configuration that can be found here:

• Feedback Portal Item - for which I noticed that you have placed your vote already.

However, a possible recommendation to alter the visible state of a given sheet would be to a client-side JavaScript interventional logic by explicitly using both the .hide() and .show() methods.

For the purposes of the demonstration, I have created a proof-of-concept sample that tackles a sheet's visibility by utilizing the Switch component and exploiting its Change event to perform client-side manipulation.

Here is an example:

@(Html.Kendo().Switch()
            .Name("switch")
            .Messages(c => c.Checked("Hide Sheet").Unchecked("Show Sheet"))
            .HtmlAttributes(new {style = "width:15%;"})
            .Events(events => events.Change("onCheck"))
)

<script>
    function onCheck(e){
          if(e.checked){
            $(".k-spreadsheet-sheets-items").find('li').eq(1).hide() // Hide the second sheet.
          }
          else{
            
            $(".k-spreadsheet-sheets-items").find('li').eq(1).show() // Show the second sheet.
          }
    }
</script>    

Here is a Telerik REPL for ASP.NET Core example for you to experiment with further that showcases the aforementioned implementation:

• Telerik REPL for ASP.NET Core Example

I hope this proves helpful.

Kind Regards,
Alexander
Progress Telerik

Hello Markus,

This feature was introduced with the 2020 R1 version of the Telerik UI for WPF. 

To hide a sheet in the UI, right-click on a sheet, in order to show the context menu and click on the Hide option.

To hide a sheet via code, the Hide method (and its overloads) of the Sheets/Worksheets property of the Workbook of RadSpreadsheet instance can be utilized.

Regards,
Stenly
Progress Telerik

Hi Praveen,

The feature is still not implemented. Its current status is Approved and when the functionality is ready, this status will be changed to Completed.
 
Since it is not supported, we don't have an example with similar functionality.

Regards,
Tanya

Hi Chetan,

Following this item guarantees that you will receive notifications for any status changes on it. As I can see, you have already subscribed to it and will get an email when we start working on the feature.

Regards,
Tanya