Completed
Last Updated: 30 Nov 2023 16:38 by ADMIN
Release R1 2020
ADMIN
Svetoslav
Created on: 27 Nov 2015 17:05
Category: Spreadsheet
Type: Feature Request
15
Spreadsheet: Implement hiding and unhiding of sheets
The sheet selector should hide sheets when their visibility is set to hidden or very hidden. The context menu of the sheet selector should contain Hide and Unhide options that allow to hide a sheet or unhide one of the hidden sheets.
11 comments
ADMIN
Alexander
Posted on: 30 Nov 2023 16:38

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

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.

Markus
Posted on: 29 Nov 2023 11:57

Hi Alexander,

thanks a lot for your effort.

Of course, client side hiding would be also an option. But I don't see a way to find out if a sheet (in Excel file) is hidden or not. If I would have that option somehow, I could use the logic of course.

Unfortunately, our Excel files are generated and dynamic, so I cannot rely on sheet namings, etc.

If you know a way, would be glad to see. Otherwise it seems we need to hope for the linked feature request.

Thanks and best regards,

Markus

ADMIN
Alexander
Posted on: 28 Nov 2023 15:05

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:

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:

I hope this proves helpful.

Kind Regards,
Alexander
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.

Markus
Posted on: 24 Nov 2023 10:01

Ah, okay, I see I am on the wrong track perhaps.

I have Telerik.UI.for.AspNet.Core and Telerik.Web.Spreadsheet.

@(
Html.Kendo().Spreadsheet()
.Name("xls-spreadsheet")
.HtmlAttributes(new { @class = "spreadsheet" })
.Sheetsbar(true)
.Toolbar(false)
.Events(e => e
.Render("onRender")
)
)

And then I load a file by

spreadsheet.fromFile(blob);

finally.

Any chances there?

 

My backend code is then like this and there I would like to configure to hide hidden sheets

ADMIN
Stenly
Posted on: 24 Nov 2023 09:40

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

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.

Markus
Posted on: 24 Nov 2023 06:50
Is this feature implemented now? Is there an example available? I want to hide hidden sheets basically.
ADMIN
Tanya
Posted on: 15 Jun 2017 14:24
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
Praveen
Posted on: 14 Jun 2017 21:24
Hi Tanya, is this feature implemented ? Can you please provide a sample.
ADMIN
Tanya
Posted on: 14 Jun 2016 12:51
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
Chetan
Posted on: 14 Jun 2016 04:29
We would need this feature too,
as we have some raw sheet which do not want to show to end user in spreadsheet viewer
Please let us know once implemented
Quentin
Posted on: 22 May 2016 14:53
please implement this