RadGridView multiple cell select like Excel

[Manas]

Anyone have any information about how we can implement a template which allows the selection of multiple cells?

If coordinates are available, I assume that it wouldn't be terribly difficult to implement the multi-cell selection like Excel by creating a rectangle based on the cell coordinates from the onClick and onRelease events.  Is there any code available that already does this?  can someone confirm whether the grid understands or holds coordinates?

[Kalin Milanov]

Hi Manas,

As you have probably noticed the grid supports only single cell selection and the corresponding visual states to indicate that are commented in the template. However we are currently nor supporting multi cell or ranged selection and therefore there is no example or sample code for this feature.

Multi cell selection is on our TODO list but it will not be possible to implement prior to Q2. Unfortunately you will not be able to achieve this functionality with the current version of the grid.

I apologize for any inconvenience this might cause.

Regards,
Kalin Milanov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Dan]

From the sound of it this feature is/was planned in the Q3 release.

Is this still the case?

I downloaded and installed the Q3 beta and am not sure how to implement this if it is supported.

Can you tell me if it is in the beta, and if so how to implement it.

If it is not in the beta is it going to be in the actual release?

Thanks

[Milan]

Hello Dan,

Unfortunately the Multiple Cell Selection feature will not be included in the Q3 release. We will try to introduce it in Q1 2010.

Greetings,
Milan
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Dan]

Bummer we were comparing infragistics and telerik and the telerik product seems to have better documentation and more functionality overall.
But the multiple cell selection was a must have feature.

Any time frame when there might be a build with this feature. If at all possible I would much rather purchase telerik's product instead of infragistics. Our company has used telerik in the past and been satisfied.

thanks

[Milan]

Hi Dan,

First, let me thank you for your interest in our Silverlight product line.

Recently we have received many requests for this feature and we will do our best to implement it by the end of this year. Still, there is high probability that the feature will be postponed until Q1 2010(February/March 2010).

Thank you once again.

Regards,
Milan
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Priyanka Lingegowda]

Hi Milan,

We are really looking for this functionality in the Q1. Telerik has better features than the infragistics but the cell selection in the major miss. Could you please let us know if this is available in the Q1 ?

[Milan]

Hello Priyanka Lingegowda,

We will be unable to include this feature in Q1 but we are working on this feature and we expect to introduced it with the first service pack for Q1.  I hope we will be able to introduce it in time for you to take advantage of this feature. 

Sincerely yours,
Milan
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Syed Danish]

Hi Milan,

I was waiting for the 2010 Q1 release and this is released. As told earlier by you that this release might have the feature of multiple column select support.
I have a list of requirements please let me know if you have the control satisfiying my requirements:

1) User can add column by clicking right mouse same as Excel (runtime)
2) User can add row clicking right mouse same as Excel (runtime)
3) User can select multiple columns and group them (runtime)
4) User can select multiple rows and group them (runtime)
5) User can add formula at runtime

In simple words my requirement are same as that of the Excel grid.


Thanks and Regards,
Syed Danish

[Milan]

Hi Syed Danish,

The Cell Selection feature is still on schedule and if all goes according to plan we will be able to introduce it with Q1 SP1. 

Let me go straight to the questions:

1) Can be done using custom code
2) Can be done using custom code
3) Most probably column selection will not be available in Q1 SP1 but it will added in a future version 
4) Multiple row selection is already available but the ability to group selected items is not available 
5) Such support is not built-in but there are many way to achieve similar functionality. This blog post reveals one possible approach.

Do not hesitate to write if you need more information.

Kind regards,
Milan
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Dhileep Kumar Sampath]

Hi Milan,
           Is that multiple cell selection feature is available now?

Regards,
Dhileep

[Pavel Pavlov]

Hi Dhileep Kumar Sampath,

Yes,
You may have a look at it at this online example.

Kind regards,
Pavel Pavlov
the Telerik team

[Dhileep Kumar Sampath]

Hi Pavel Pavlov,

Thanks for your quick response. Can you tell me
a) in which release this feature is made available and
b) setting only the SelectionMode to Multiple will enable both for Columns and Rows?

Regards,
Dhileep

[Milan]

Hi Dhileep Kumar Sampath,

Cell selection was introduced with our Q2 release. The SelectionMode property dictates if multiple or single items can be selected while the SelectionUnit property determines what units are select - cells or rows. Currently we only support two unit mode called Cell or FullRow. While in Cell selection mode you will be able to select cells only. When the mode is FullRow you will be able to select rows only. 

Kind regards,
Milan
the Telerik team

[Amara]

Hi Milan,

Is the multiple cell selection feature available in Q2 for silverlight 3?

and Could you point me to the demo for the same?

Thank you.

[Vlad]

Hello,

 Generally all new features are added only for Silverlight 4 (including this particularly). 

Regards,
Vlad
the Telerik team

[vijay sutaria]

Is any updates available regarding "RadGridView multiple cell select like Excel"

[Vlad]

Hello,

 Indeed you can select multiple cells with latest version. Please refer to our demos, documentation, etc. 

Regards,
Vlad
the Telerik team

[vijay sutaria]

Thanks for your quick reply..

I have purchased WPF telerik controls of version 4.0

I am able to select multiple cells, but its not possible to select cells like we can select in excel sheet.
This facility is also available with normal WPF datagrids.

So is it possible with 4.0 version?

Thanks

[Milan]

Hello vijay sutaria,

Please set SelectionMode to Extended and SelectionUnit to Cell and there should be not problem to select cells similarly to Excel.

Kind regards,
Milan
the Telerik team

[Swapan]

I am using ASP.Net Ajax version RadControls 3.5. Is multiple cell selection available for ASP.net or is it just for Silverlight?
If not available - can you please direct me to a solution example? 
Many thanks