Drag and drop Issues

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

    Posted 18 Jul 2017 Link to this post

    I have a cell with the text "Buy X for, get Y for: Buy 1 for, get 1 for x".

    When I drag and drop this cell, the spreadsheet manipulates the text inside it and increments the last number by 1.

    The result is 

    Buy X for, get Y for: Buy 1 for, get 2 for x
    Buy X for, get Y for: Buy 1 for, get 3 for x
    Buy X for, get Y for: Buy 1 for, get 4 for x
    Buy X for, get Y for: Buy 1 for, get 5 for x

    The field type is string so this cannot be correct.

    Please investigate and let me know

     

     

  2. Dimitar
    Admin
    Dimitar avatar
    796 posts

    Posted 19 Jul 2017 Link to this post

    Hello Marc,

    The described behavior is implemented according to Excel and is expected. If you perform the same test there, you will notice that the numbers are also incremented.

    Currently, there is a known issue in the Kendo UI Spreadsheet, which does not increment a cell text that starts with a number. You can find more information and start tracking the progress that we make on this from this GitHub issue.

    Regards,
    Dimitar
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 19 Jul 2017 in reply to Dimitar Link to this post

    Hi Dimitar,

    This isn't the same behaviour as Excel. I have tested in Excel and if a cell is type text then it will not increment any number.

    Please check this again.

  4. Dimitar
    Admin
    Dimitar avatar
    796 posts

    Posted 20 Jul 2017 Link to this post

    Hello Mark,

    I apologize for misleading you.

    I have researched this further and I have updated the GitHub issue with the possible autofill number incrementation scenarios. You can review it and leave a comment there if I have missed any specific case. 

    Regards,
    Dimitar
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  5. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 20 Jul 2017 in reply to Dimitar Link to this post

    Hi Dimitar

    Not a problem at all - currently is there any workaround?

    Thanks

    Marc

  6. Dimitar
    Admin
    Dimitar avatar
    796 posts

    Posted 21 Jul 2017 Link to this post

    Hello Marc,

    I am afraid there is no viable workaround which I can suggest at the moment. We will leave a comment below the GitHub issue if a temporary solution is found before we fix this in a official Kendo UI release.

    Regards,
    Dimitar
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top