Grid copy/paste, editable tree grid

[Macloud]

Is there any way to have following features in extjs?
1) Ability to select range of cells and copy/paste data to excel
2) Have nested rows in editable grid (I see similar funtionality in Column Tree, but it is readonly, is it?)
Like it is done in http://www.nitobi.com/products/compl.../asp/treedata/

We have liceses for both extjs and nitobi and have to use nitobi because of those two features, and it s*cks compared to extjs.

[mjlecomte]

I believe there are extensions near both of your requests available.

"Anything is possible"...you may have to provide some of your own code though or get / hire someone to help you.

[Surinder singh]

Hi,

Here is the excel grid by which user can select cells like Excel sheet, and copy paste To/From excel sheet to extjs grid. More important it does not use any flash to copy data to clipboard.I have tested it in Firefox 3.0.10, IE6, Safari 3.2.2.but there is some bug on mouse selection in Safari, i am working on it.

Extract the zip, copy the files as structure given in it.

[nikojudo]

Hi, I have one problem implementing the method pasteFromClipBoard() in button,

my code

var grid = new Ext.grid.EditorPasteCopyGridPanel({
        store: store,
        cm: cm,
        renderTo: 'editor-grid',
        width:600,
        height:300,
        autoExpandColumn:'common',
        title:'Edit Plants?',
        frame:true,
        plugins:checkColumn,  
        tbar: [{
            text: 'Paste from Excell',
            handler : function(){
    //console.debug(this);
 
       grid.pasteFromClipBoard();
    
            }
        }]
    });

works with ctrl-v but does not work from a button

help me please,

Excuse my english, I speak spanish. Thanks

[Surinder singh]

Hi,

actually there is no direct way to get the content from clipboard(as per my knowledge), so in this grid we can get the clipboard data by ctrl+v method only, as function

pasteFromClipBoard:function(){
var hiddentextarea = this.getHiddenTextArea();
hiddentextarea.dom.value ="";
hiddentextarea.focus();
},

shows that, we are only changing the focused element on ctrl+v event, and there is no code written for fetching the clipboard data. when user press the ctrl+v his clipboard data directly pasted to the hidden textarea, from where we get the content for our grid uses.

now u can see that this function cannot be used by any other button/Event

Sorry for that

Hi, I have one problem implementing the method pasteFromClipBoard() in button,

my code

var grid = new Ext.grid.EditorPasteCopyGridPanel({
        store: store,
        cm: cm,
        renderTo: 'editor-grid',
        width:600,
        height:300,
        autoExpandColumn:'common',
        title:'Edit Plants?',
        frame:true,
        plugins:checkColumn,  
        tbar: [{
            text: 'Paste from Excell',
            handler : function(){
    //console.debug(this);
 
       grid.pasteFromClipBoard();
    
            }
        }]
    });

works with ctrl-v but does not work from a button

help me please,

Excuse my english, I speak spanish. Thanks

[nikojudo]

Gracias por contestar, igual es un magnifico control.

Thanks.

Sorry, I said that although one can not use a button, I have been very useful this control, Thanks for posting.

[Surinder singh]

sorry i dont know what u said

[psambhus]

Hi, Could you provide some working proto of it, if possible?

Thanks,
Haresh

[Surinder singh]

Hi,

You can test the grid as follow

1. download excell-grid_1.3.zip
3. download ext 3.*
2. extract excell-grid_1.3.zip and copy files as per directory structure given in it under ext folder
3. now go your localhost as http://localhost/ext/examples/excel-grid/
4. Or simple open the ext/examples/excel-grid/index.html
You will see the out put

if you are getting any issue/bug email me at surindersingh83_ece@yahoo.com

[wm003]

This is awesome! Thanks a lot for sharing