This is a migrated thread and some comments may be shown as answers.

hiding columns problem

5 Answers 64 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Tony
Top achievements
Rank 1
Tony asked on 31 Jan 2019, 03:01 PM

I have a spreadsheet with the first 2 columns frozen.

 

I want to hide the non-frozen columns but when I do this the first column A is repeated in the non-frozen column section.

See the example dojo and image attached - click the "Hide non frozen columns" button to see the problem

 

Thanks

Tony

5 Answers, 1 is accepted

Sort by
0
Veselin Tsvetanov
Telerik team
answered on 04 Feb 2019, 11:24 AM
Hi Tony,

I am afraid that the observed is a bug in the Spreadsheet functionality. Here you could find the GitHub item on that, where you could track the bug status. As a small token of gratitude for the reported, I have updated your Telerik points.

Please, note that at this stage I won't be able to provide you with a viable workaround of the discussed. Therefore, I would suggest you to keep tracking the GitHub issue and update the Kendo version as soon as the fix has been made available.

Regards,
Veselin Tsvetanov
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Tony
Top achievements
Rank 1
answered on 04 Feb 2019, 01:19 PM

Thank you Veselin.

 

My workaround is to un-freeze the frozen columns which then removes the odd-behaviour.

0
Veselin Tsvetanov
Telerik team
answered on 06 Feb 2019, 09:09 AM
Hi Tony,

The described would be a proper approach in the discussed scenario. Thank you for sharing it.

Regards,
Veselin Tsvetanov
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Tony
Top achievements
Rank 1
answered on 07 Feb 2019, 04:44 PM

In order to implement my workaround I need to be able to determine for each column its visibility property, i.e. hidden/not hidden.

Is there a sheet columns collection with visible property or similar I could use?

0
Accepted
Veselin Tsvetanov
Telerik team
answered on 11 Feb 2019, 01:36 PM
Hello Tony,

I believe that the easiest way to retrieve the column info for a given Sheet in the Spreadsheet would be the following:
var spread = $('#spreadsheet').getKendoSpreadsheet();
var sheet = spread.activeSheet();
var sheetAsJson = sheet.toJSON();
var columns = sheetAsJson.columns;

Those columns that are hidden will have a numeric value set for their hidden field and their width will be 0. That numeric value will be equal to the width of the column, when it is visible (not hidden).

Regards,
Veselin Tsvetanov
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Spreadsheet
Asked by
Tony
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Tony
Top achievements
Rank 1
Share this question
or