:: Forum >> Version 2 >>

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 
cratext = [];
        var 
cols this.getSelectedColumns();
        var 
rows this.getSelectedRows();
        if (
this.getCurrentSelection() == "row"){
            
cols = [];
            var 
count this.getColumnCount();
            var 
indices this.getColumnIndices();
            for (
c=0c<countc++){
                
cols[c] = indices ? indices[c] : c;
            }
        }
        for (
r=0r<rows.lengthr++){
            
= [];
            for (
c=0c<cols.lengthc++){
                
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

Post a reply:

Text:
Name:

Back to support forum

Forum search