hiding columns problem

[Tony]

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

[Veselin Tsvetanov]

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

[Tony]

Thank you Veselin.

 

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

[Veselin Tsvetanov]

Hi Tony,

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

Regards,
Veselin Tsvetanov
Progress Telerik

[Tony]

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?

[Veselin Tsvetanov]

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