Spreadsheet Import

6 posts, 1 answers
  1. Marc
    Marc avatar
    79 posts
    Member since:
    Sep 2016

    Posted 25 Nov 2016 Link to this post

    After importing data from an Excel file into the Kendo spreadsheet, all the alignment is off (by the width of the "row number column").

     

     

     

     

  2. Marc
    Marc avatar
    79 posts
    Member since:
    Sep 2016

    Posted 25 Nov 2016 in reply to Marc Link to this post

    Please note - this only happens when the number of columns is quite larger - I have around 50, and the spreadsheet has a lot of horizontal scrolling to see all the columns. I guess when importing, and working out the location of the 'cells', it does not account for the width of the column which shows the row number.
  3. Stefan
    Admin
    Stefan avatar
    361 posts

    Posted 28 Nov 2016 Link to this post

    Hello Marc,

    This is not a known issue and it was not reproduced in my testing scenarios.

    Could you please check if the issue still occurs when the file is imported using our demo example:

    http://demos.telerik.com/kendo-ui/spreadsheet/server-side-import-export

    - If the issue occurs there also, please send us the Excel file so we can test it on our side.

    - If the issue does not occur in the demo, I can assume that it occurs because of a custom logic which we are overlooking at this moment. Sending a runnable example will help to locate the issue and provide a suggestion best suited for it.

    Regards,
    Stefan
    Telerik by Progress
    Kendo UI is ready for Visual Studio 2017 RC! Learn more.
  4. Marc
    Marc avatar
    79 posts
    Member since:
    Sep 2016

    Posted 29 Nov 2016 in reply to Stefan Link to this post

    Hi Stefan,

    As I mentioned in the second post on this thread - this only happens when the number of columns is quite large. I believe it has tobe enough columns to force the component to render the horizontal scrollbar.

    Marc

  5. Answer
    Stefan
    Admin
    Stefan avatar
    361 posts

    Posted 30 Nov 2016 Link to this post

    Hello Marc,

    I did import a file with 90 columns using the provided demo example and it is working as expected.

    Could you please confirm that importing the file using the demo is causing a misalignment again or not. This will help us determine if there is anything specific with the data in the file, or with the custom implementation of the Spreadsheet.

    I will be expecting the additional information to continue with the investigation.

    Regards,
    Stefan
    Telerik by Progress
    Kendo UI is ready for Visual Studio 2017 RC! Learn more.
  6. Marc
    Marc avatar
    79 posts
    Member since:
    Sep 2016

    Posted 13 Jan in reply to Stefan Link to this post

    Hi Stefan,

    Thanks for your help with this matter. I did some debugging and it turns out it is an issue with my code, not yours.

    Thanks again!

    Marc

Back to Top