Welcome Guest Search | Active Topics | Sign In | Register

How to customizing EO.Grid control to be an Excel like GridView Options
Jack.Wu
Posted: Friday, May 22, 2009 2:27:08 PM
Rank: Advanced Member
Groups: Member

Joined: 5/22/2009
Posts: 33
I am evaluating your product and would like to make sure if we can implement an Excel like functionality in ASP.NET. I tried your sample but it is not like the behavior of Excel that I can not navigated by using the arrow keys and the Tab key to focus on the cell. Or resize the row height just like Excel.

Is it possible to customized your Grid control to be an ExcelGrid?

Thanks for your help.
eo_support
Posted: Friday, May 22, 2009 2:38:46 PM
Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194
Hi,

In order to enable keyboard navigation, you will need to set EnableKeyboardNavigation to true. You can see a working example here:

http://demo.essentialobjects.com/Default.aspx?path=Grid\_i1\_i20

By default when you focus a cell, the cell does not enter edit mode. You can handle the Grid's ClientSideOnCellSelected client event and then call the Grid's editCell method to automatically set the Grid into edit mode if you need to. Make sure you call editCell with a setTimeout if you do so. See this post for more details:

http://www.essentialobjects.com/forum/postst3212_Grid-Questions.aspx

The Grid supports column resizing but not row resizing. It however can have an edit UI that is bigger than the cell. For example, you can use a TextBoxColumn and set the columns' TextBoxRows to a large number. When the cell enters edit mode, it will display a textbox that is larger than the cell.

We have also recently implemented fixed top/bottom rows and column spans. Fixed top bottoms rows are very useful when you want one or more rows fixed in the top/bottom and the rest row scrolls (for example, a Total row fixed in the bottom). Column spans are similar to table cell colSpan and allows a cell to span over multiple columns. The build that includes these feature are not public yet. If you are interested in these features, please let us know and we can send you the new build.

Thanks!


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.