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
0
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
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
Hi Tony,
The described would be a proper approach in the discussed scenario. Thank you for sharing it.
Regards,
Veselin Tsvetanov
Progress Telerik
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
Hello Tony,
I believe that the easiest way to retrieve the column info for a given Sheet in the Spreadsheet would be the following:
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
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.