Drag and drop Issues

[Marc]

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

 

 

[Dimitar]

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

[Marc]

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.

[Dimitar]

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

[Marc]

Hi Dimitar

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

Thanks

Marc

[Dimitar]

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