PDA

View Full Version : Excel Copy Down Functionality In Grid



dfox-lemans
28 Feb 2013, 10:29 AM
I have been given a requirement to include some "Excel like" spreadsheet functionality within an Ext Grid component. I need to be able to do two things:

1. Apply "Excel Style" copy down functionality -- ie. Click on a cell or select several cells and then grab the bottom right corner of the selection and drag it down to copy those cell values into the rows that are dragged over

2. Add ability to select a range of cells and Copy/Paste values

I have seen the following items:
1. http://enterprisesheets.com -- this has a nice implementation of the features I need, but has the problem of being overkill for my application and it is written in Ext 3.4 and it is closed source

2. http://www.extjs4spreadsheet.com -- this does a lot of what I need but does not provide the copy down functionality.

I guess what I am looking for is someone in the community to guide to some extensions that will do what I need or can make some suggestions as to how I can efficiently extend the grid panel and associated selectionmodel to accomplish this myself.

I appreciate any suggestions/guidance you can provide.

jsakalos
28 Feb 2013, 1:00 PM
I think that you can get much better response if you ask on a public forum because only premium users can post here on premium support. Also, on this forum I haven't seen anything that could provide you some suggestions.

If you want I can move this thread to a public forum of your choice.

dfox-lemans
28 Feb 2013, 1:02 PM
Thanks for the suggestion jsakalos. Could you move it into the Ext: Q&A forum. Thanks.