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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Excel like editing

Thread ID:





95839 Aug 3,2010 10:29 PM UTC Aug 12,2010 10:20 AM UTC Silverlight 5
Tags: GridControl
Tigger Tag
Asked On August 3, 2010 10:29 PM UTC

When I set grid.Model.Options.ExcelLikeCurrentCell to true, is it possible to edit the cell text just like Excel; i,e when you start typing it should automatically edit the text in the cell intstead of cell mouse click and then edit the text.


Jeraldes J [Syncfusion]
Replied On August 4, 2010 11:59 AM UTC

Hi Tigger,

By setting the ExcelLikeCurrentCell to true you can edit the cells directly like the excel edit option.

Sample code snippet:

Model.Options.ExcelLikeCurrentCell = true;

Please download the sample from the below link for your reference.


Let us know if you need any other details.

Jeraldes J

Tigger Tag
Replied On August 4, 2010 01:56 PM UTC

The sample in the reference link is for WPF project, could you send a sample that works in Silverlight 4.0?


Jeraldes J [Syncfusion]
Replied On August 6, 2010 10:52 AM UTC

Hi Tigger,

Please download the sample with the ExcelLikeCurrentCell from the below link.


For your future reference regarding excel like features please refer the sample from our dashboard.

SilverLight->Grid->Excel Like Features

Let us know if you face any other issues.

Jeraldes J

Tigger Tag
Replied On August 10, 2010 01:29 PM UTC

Hi Jeraldes,
I did refer to the samples, but this one is not working as I expect. Here is what I did, I set the excel options as below:
this.grid.Model.Options.ExcelLikeCurrentCell = true;
this.grid.Model.Options.ExcelLikeSelectionFrame = true;

Here is how it is working:
1) I did a mouse click on a cell, the cell enters into edit mode, I can type text. After I finish typing I click enter key, the cell comes out of edit mode (As expected).
2) Now I use keyboard up or down arrow key to navigate to another cell and start typing in keys.
I expect the cell to automatically enter into edit mode and display the keys I typed in, but the cell is not entering into edit mode.

Here is my Syncfusion version and environment details I am using.
1) Syncfusion Dlls:
2) Silverlight 4 & VS 2010 environment
3) I had to install a patch SyncfusionPatch_8.2.0.18_131067_8032010052817_68610.exe to fix another issue.

Your project was targetted to silverlight 3, I modified your project and added my dll reference, and am attaching my project for your reference.



Jeraldes J [Syncfusion]
Replied On August 12, 2010 10:20 AM UTC

Hi Tigger,

This issue have been rectified in our vol3. If you need your patch in 8.2v. You please place an incident regarding the issue in our Direct-trac by using this forum ID mentioned in that.

Let us know if you need any other details.

Jeraldes J


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon