hiding columns problem

6 posts, 1 answers
  1. Tony
    Tony avatar
    20 posts
    Member since:
    Dec 2011

    Posted 31 Jan 2019 Link to this post

    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

  2.
  3. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1241 posts

    Posted 04 Feb 2019 Link to this post

    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.
  5. Tony
    Tony avatar
    20 posts
    Member since:
    Dec 2011

    Posted 04 Feb 2019 in reply to Veselin Tsvetanov Link to this post

    Thank you Veselin.

     

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

  7. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1241 posts

    Posted 06 Feb 2019 Link to this post

    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.
  8.
  9. Tony
    Tony avatar
    20 posts
    Member since:
    Dec 2011

    Posted 07 Feb 2019 in reply to Veselin Tsvetanov Link to this post

    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?

  11. Answer
    Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1241 posts

    Posted 11 Feb 2019 Link to this post

    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.
Back to Top