Multi-cell paste

[nitroamos]

One feature that has been very important for us and colleagues I've spoken with is the ability to do a multi-line paste, and Smartclient's current capability in this is not great (i.e., a separate pop-up window). The reason is because users need to fill in a ListGrid and data is often coming from things like an xlsx or text file they can copy from. It's tedious and error prone to expect them to copy/paste one cell at a time.

I'd be happy for Isomorphic to vet and integrate functionality like this:

    pasteTextFromClipboard: function(e) {
        var selection = this.selection.getSelectedCells();
        if (selection.length != 1) {
            return true;
        }

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

        var rowSep = null;
        var colSep = null;
        if(pastedText.indexOf(String.fromCharCode(13)) != -1){
            rowSep = String.fromCharCode(13);
            colSep = String.fromCharCode(9);
        } else {
            rowSep = /\r?\n/;
            colSep = ",";
        }
        var lines = pastedText.split(rowSep);

        var r = selection[0][0];
        var c = selection[0][1];
        for(var i=0; i<lines.length; i++){
            if(r >= this.getTotalRows()){
                break;
            }

            var cols = lines[i].split(colSep);
            for(var j=0; j<cols.length; j++) {
                var col = c+j;
                var fieldName = this.getFieldName(col);
                if(!fieldName){
                    break;
                }
                this.setEditValue(r, col, cols[j]);
                this.validateCell(r,fieldName);
            }
            var record = this.getRecord(r);
            this.markRecordChanged(record);
            r++;
        }
        this.endEditing();
        return false;
    },
            draw: function(){
                this.Super("draw", arguments);
                var listGrid = this;
                var lgDiv = this.getContentElement();
                if(lgDiv == null){
                    console.log("lgDiv is null!");
                    return;
                }
                lgDiv.onpaste = function(e) {
                    return listGrid.pasteTextFromClipboard(e);
                };
            }

[Isomorphic]

Since some browsers under some circumstances reject or restrict attempts to access the clipboard, we opt for the pop-up dialog approach shown in the sample. It does not require one cell at a time entry.

Feel free to take the approach above if you prefer to deal with browser issues.