:: Forum >>

2.25.2 copy via ctrl-c contents of my grid into excel

How would I do the following: Just upgraded to 2.5.2 and want to do the following (ie copy all rows and cells in a grid via Ctrl-C and paste into Excel.

In the history notes on this site it states the following:

The grid now supports clipboard copy/paste - copy selected cells/rows with Ctrl-C and paste into another application (Excel, Word etc.)

is there a chunk of code on how to do this.

thanks.

jeff

Jeff C
Thursday, September 4, 2008
By default the grid copies the current selection (rows or cells, depending on the selection mode). You can change the default behavior if you overwrite the getSelectedText method (/source/lib/grid/control.js, line 469)

obj.getSelectedText = function(){
        var c, r, a, text = [];
        var cols = this.getSelectedColumns();
        var rows = this.getSelectedRows();
        if (this.getCurrentSelection() == "row"){
            cols = [];
            var count = this.getColumnCount();
            var indices = this.getColumnIndices();
            for (c=0; c<count; c++){
                cols[c] = indices ? indices[c] : c;
            }
        }
        for (r=0; r<rows.length; r++){
            a = [];
            for (c=0; c<cols.length; c++){
                a[c] = this.getCellText(cols[c], rows[r]);
            }
            text[r] = a.join("\t");
        }
        return text.join("\r\n");
    };
Alex (ActiveWidgets)
Friday, September 5, 2008
Thanks alex. perfect.
Jeff c
Thursday, October 2, 2008

This topic is archived.


Back to support forum

Forum search