We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Edit operations

How can I do the following in version 3 of the grid?: 1- Copy, cut and paste from one cell to another cell and allowing the pasted value to remain on the grid and to update the underlying data table. Also paste the copied or cut values from the grid to an excel spreadsheet, notepad, etc... 2-Print out the grid (to a printer). 3- Export the grid to an excel spreadsheet. 4- Is there an event raised when a column is moved from one position to another (by clicking and dragging the column) in the grid? Thanks

3 Replies

AD Administrator Syncfusion Team January 12, 2005 03:35 PM UTC

1) Drop and GridDataBoundGrid on a form and set its DataSource. Then ctl+C, ctl+V and ctl+X should copy, paste and cut for use when you select a range of cells. Does this not work for you? (If you try to paste more information than there are rows/columns in your grid, then there is more work to be done as the GridDataBoundGrid does not autoappend new rows and columns. But teh GridControl does. You can handle the grid.ModelPasteCellText to manage this problem in a GridDataBoundGrid.) 2) See this KB. http://64.78.18.34/Support/article.aspx?id=10067 3) Here is a forum thread that has snippets showing how to write CSV or TSV files that excel can read. http://64.78.18.34/Support/Forums/message.aspx?MessageID=3292 If you want to save the grid as an XLS file, then you would have to use our ExcelRW product. 4)There are this.gridDataBoundGrid1.Model.ColsMoved/ColsMoving events.


AA Anthony Avella January 14, 2005 02:15 PM UTC

I do not have the behavior you dewcribe below for item #1. We add the grid control at run time. Is there another way to do this? >1) Drop and GridDataBoundGrid on a form and set its DataSource. Then ctl+C, ctl+V and ctl+X should copy, paste and cut for use when you select a range of cells. Does this not work for you? (If you try to paste more information than there are rows/columns in your grid, then there is more work to be done as the GridDataBoundGrid does not autoappend new rows and columns. But teh GridControl does. You can handle the grid.ModelPasteCellText to manage this problem in a GridDataBoundGrid.) > >2) See this KB. http://64.78.18.34/Support/article.aspx?id=10067 > >3) Here is a forum thread that has snippets showing how to write CSV or TSV files that excel can read. >http://64.78.18.34/Support/Forums/message.aspx?MessageID=3292 >If you want to save the grid as an XLS file, then you would have to use our ExcelRW product. > >4)There are this.gridDataBoundGrid1.Model.ColsMoved/ColsMoving events.


AD Administrator Syncfusion Team January 14, 2005 03:19 PM UTC

This should work right out of the box. Below is a sample showing a grid being created when you click a button, and you can immediately select several cells and copy and paste them. http://www.syncfusion.com/forums/Uploads/GDBG_CopyPaste.zip If it is not working for you, then there is likely something specific in how you are doing things that is interfering with the default behavior. Can you upload a sample that shows the problem or submit a Direct Trac incident with a sample showing the problem?

Loader.
Live Chat Icon For mobile
Up arrow icon