[Solved] Re: Excel objects in silverlight 4.0

[Rishi]

Hi

I have a requirement to build or Embed an excel object on a  Silverlight Page.. that would actually allow the users to perform all the excel features especially the copy values by dragging.

I didn't find anything similar to that... but thought I can use the Grid to replicate some of the features as required, is there a property of a way-how to copy a single cell value over to a list of  cells similar to the excel drag for copying.. ?

Thanks

[Yavor Georgiev]

Hello Rishi,

 You can use the built-in copy/paste functionality in RadGridView. All you need to do is to set the ClipboardPasteMode property like so:

<telerik:RadGridView ... ClipboardPasteMode="Default, AllSelectedCells" />

or:

myGrid.ClipboardPasteMode = GridViewClipboardPasteMode.Default | GridViewClipboardPasteMode.AllSelectedCells;

This way when you paste a single cell, but have selected multiple cells, their values will be replaced with the value of the pasted cell. You can read more about RadGridView's copy/paste functionality here.

All the best,
Yavor Georgiev
the Telerik team

[Rishi]

Hi Yavor

Thanks for your quick response,Telerik RadGrid has very good features in fact, I tried a couple of them and am quite impressed, I actually wanted to achieve something similar to an excel interface with the grid, my users wanted to have a drag to copy feature of excel, please let me know if you already have such a feature available? I was thinking of a work around by making use of the mouse enter events to get a similar effect but I can't get the exact thing not even close actually :) ..
One quick question is it possible to embed an excel object similar to that of the  excel in Google docs and allow users to use the piece as required and then save it back... but the number of columns would always be fixed with locked headers etc?

Any thoughts are greatly appreciated.

Thanks

[Yavor Georgiev]

Hello Rishi,

 It seems that your scenario relies on closer integration with Excel. This article explains how to use COM Interop to communicate with Excel from within Silverlight. Unfortunately we do not currently support 'drag to copy', but will investigate this feature and determine whether to include it in a future release.

Greetings,
Yavor Georgiev
the Telerik team