Work with selection to paste to

[Paul]

Hi,

I thought I'd ask on here first, but I am struggling to find any nice way to paste into the grid selected cells. 

 I am using multiple cell selection:

 

.Selectable(selectable => selectable.Enabled(true)
                .Mode(GridSelectionMode.Multiple)
                .Type(GridSelectionType.Cell))

I am anticipating I need to manually handle the paste event by registering for the paste event.

    $(function () {

        $("#weldgrid").bind("paste", function (e) {

        var pastedText = undefined;
            if (window.clipboardData && window.clipboardData.getData) {
                pastedText = window.clipboardData.getData('Text');
            } else if (e.clipboardData && e.clipboardData.getData) {
                pastedText = e.clipboardData.getData('text/plain');
            }

    // TODO:  Process input for tab/newlines

   // iterate through selected cells
   // write associated value to each one

    }
}

 

I've come across this thread already which went dead after one response.

http://www.telerik.com/forums/copy-and-paste-rows-in-kendo-ui-asp-net-mvc-grid

For me the demo does not work and the API Docs in IE11 are all over the place.  I am struggling to find my way around the layout/structure of the pages.

Now my question is, how can I nicely iterate through each cell in the range and set the value?

I can see that:

var grid = $("#grid").data("kendoGrid");
            var currentSelection = grid.select();

            currentSelection.each(function () {
    // $(this) is the selected cell
}

 

Thanks

Andez

 

 

[Alex Gyoshev]

Hello Paul,

As the thread noted, pasting in the grid is not supported and is achieved via custom code. I'm afraid that we do not have any other examples on how to implement this.

Regards,
Alex Gyoshev
Telerik

[Paul]

That's a shame.

Is anything planned for a Grid with this functionality?

I've heard some talk saying this is more Spreadsheet behaviour.  Can we expect it in the Grid in future?  I would hope for it - given we get copy paste in standard Telerik Grid for WinForms and WPF.  Would be a very desirable feature.

Cheers

Paul

[Atanas Georgiev]

Hello Paul,

We do not have immediate plans to include built in behavior for pasting in the grid. We will appreciate if you submit your ideas as feature requests at our UserVoice portal - this way the community would be able to evaluate it and we will consider them for future releases. Thank you in advance.

You may also want to take a look at our Roadmap for Q3 2015, which announces the expected introduction of Spreadsheet (Beta version) widget.

Regards,
Atanas Georgiev
Telerik