Hi,

How about copying from excel?

If I want to copy few cells from an excel file into an ultrawebgrid on my ASP.Net page, how can I do it?

I am using Infragistics version 7.2.20072.61

Thanks.

Hello,

The grid supports copying from Excel as well. Make sure that you have ActivationObject enabled, end then simply select cells in Excel, press Ctrl-C, the press Ctrl-V over the grid and the copied cells will be pasted starting from the active cell.

Hey, thanks Alex.

I think the earlier version did not support this functionality.

Anyways, I understood what went wrong. I was not able to do it earlier, because when you click on a cell, it goes into an editing mode. Need to press 'Enter' and then paste.

Got it!

I have one more issue.

As I mentioned earlier, if I click on a cell, it goes to an editable mode. If I paste, then nothing gets pasted.

I have to press 'Enter', which gets me out of the editable mode, then use the scroll keys to navigate to the cell from where I wasnt my pasting to begin, and then hit 'ctrl + V'

Isn't there any other way where, if I click on the cell, it doesn't go to an editable mode, so that I can select a cell and hit 'ctrl + V'?

I got the solution.

Just have to remove this property - CellClickActionDefault="Edit"

May be I got over excited as the copy functioanlity worked :-)

Some people, who dont have a habit of using much keyboard, dont know that we can use Ctrl-V for paste.

Is there any chance we can include the 'Paste' option when we right click on the grid?

hi,

I am using infragistics grid in my application. Where in any browser user cannot select the text in the columns of the Grid with the mouse and copy the text to the clipboard using ctrl+c or copy by right click using mouse. But I need solution to allow user to select text in grid. So can any one give solution for this.

Thanks in advance

Karthick

To limit input to numbers only, you need to drop a WebNumericEdit control on the form and set its ID to the column's EditorControlID property, at the same time column's Type property should be set to ColumnType.Custom.

If you look at the sample, it uses UltraWebMenu, which is opened on the right click over the grid. You need to add the same logic to your application.

Also, what do I need to do if I need to limit my cell text to numeric?

Presently, it accepts alphabets too.

On my web page, when I click on right any cell of my grid, I cannot see any Copy-Paste option.

I only see the web options i.e. the options which I see when I right click on any area of the web page.