1. #1
    Ext User
    Join Date
    Mar 2008
    Posts
    1
    Vote Rating
    0
    Macloud is on a distinguished road

      0  

    Default Grid copy/paste, editable tree grid

    Grid copy/paste, editable tree grid


    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.

  2. #2
    Ext User
    Join Date
    Jul 2007
    Location
    Florida
    Posts
    9,996
    Vote Rating
    5
    mjlecomte will become famous soon enough mjlecomte will become famous soon enough

      0  

    Default


    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.

  3. #3
    Sencha User Surinder singh's Avatar
    Join Date
    May 2009
    Location
    India
    Posts
    38
    Vote Rating
    0
    Surinder singh is on a distinguished road

      0  

    Default Here is Excell grid

    Here is Excell grid


    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.
    Attached Files

  4. #4
    Ext User
    Join Date
    Mar 2010
    Posts
    2
    Vote Rating
    0
    nikojudo is on a distinguished road

      0  

    Default in button

    in button


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

    my code

    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

  5. #5
    Sencha User Surinder singh's Avatar
    Join Date
    May 2009
    Location
    India
    Posts
    38
    Vote Rating
    0
    Surinder singh is on a distinguished road

      0  

    Default


    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


    Quote Originally Posted by nikojudo View Post
    Hi, I have one problem implementing the method pasteFromClipBoard() in button,

    my code

    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

  6. #6
    Ext User
    Join Date
    Mar 2010
    Posts
    2
    Vote Rating
    0
    nikojudo is on a distinguished road

      0  

    Default


    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.

  7. #7
    Sencha User Surinder singh's Avatar
    Join Date
    May 2009
    Location
    India
    Posts
    38
    Vote Rating
    0
    Surinder singh is on a distinguished road

      0  

    Default


    sorry i dont know what u said

  8. #8
    Ext User
    Join Date
    Apr 2008
    Posts
    40
    Vote Rating
    0
    psambhus is on a distinguished road

      0  

    Default


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

    Thanks,
    Haresh

  9. #9
    Sencha User Surinder singh's Avatar
    Join Date
    May 2009
    Location
    India
    Posts
    38
    Vote Rating
    0
    Surinder singh is on a distinguished road

      0  

    Default you can test it as follow

    you can test it as follow


    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

  10. #10