spreadsheet

2 Answers 84 Views
Spreadsheet wrapper
Top achievements
Rank 1
Iron
asked on 13 Sep 2021, 02:08 AM | edited on 13 Sep 2021, 06:00 AM
How does the Spreadsheet component developed based on VUE use code to hide certain columns or rows

2 Answers, 1 is accepted

Sort by
0
Petar
Telerik team
answered on 13 Sep 2021, 05:55 AM

Hi 三,

The official communication language in our Support service and forums is English. Can you ask your question in English, so we or someone from our community can understand it and help you with your case?

Regards,
Petar
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
Petar
Telerik team
answered on 13 Sep 2021, 06:11 AM

Hi 三,

You can use the hideColumn or hideRow methods of the Spreadsheet. To show hidden row/column you can use the unhideColumn and unhideRow methods.

Here is a StackBlitz example in which the below code is used to hide the first two rows and columns of the loaded document. 

spreadsheet.activeSheet().hideColumn(0);
spreadsheet.activeSheet().hideColumn(1);
spreadsheet.activeSheet().hideRow(0);
spreadsheet.activeSheet().hideRow(1);

You can use the unhideColumn and unhideRow methods in a similar way. 

I hope the above example will help you implement what you need in your application.

Regards,
Petar
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Spreadsheet wrapper
Asked by
Top achievements
Rank 1
Iron
Answers by
Petar
Telerik team
Share this question
or