We have users who are very familiar with Excel. I would like to start moving them toward an application for their UI, because it gives me so much more control to develop the functionality behind the data. However, that will be a challenge due to their love of Excel. Are there some samples that I can refer to that make the xamDataGrid look and feel as much like Excel as possible? Specifically I'm thinking of the navigation (arrows, [Home], [End], etc.), data entry, adding records, etc., etc. The closer I can make it to Excel in all regards, the better it will be.
Thanks!
Brad.
Hello Brad,
Thank you for your post. I have been looking into it and I can suggest you see this forum thread:
http://ko.infragistics.com/community/forums/t/56099.aspx
where a similar question is already answered. Please let me know if you have further questions on this matter.
Looking forward for your reply.
That helps, but there are still a number of issues. The left and right arrow keys still don't work exactly as in Excel. How about adding a new row when I hit the down arrow on or tab past the end of the last row? What about [Home], [End], [Page Up] and [Page Down]? Obviously I could capture and deal with all of these, but it would be much nicer if there were simply a setting of some kind that says "act like Excel". I know, that may be asking too much, but....
As you said, the thing you can do is handling the keydown event and write your own logic when each of this keys is pressed. If you want a property which can control this, you an log a product idea for this here:
http://ideas.infragistics.com/
Here you can see all the events:
http://help.infragistics.com/Help/Doc/WPF/2014.1/CLR4.0/html/InfragisticsWPF4.DataPresenter.v14.1~Infragistics.Windows.DataPresenter.XamDataGrid_members.html
Please take a look at them and tell us what more events do you need.
I'm not sure what to say. I'm still wishing/hoping for a better outcome, but I understand if the grid simply doesn't offer it. Also, from my (little bit of) testing, it looks like there aren't quite enough events exposed to do exactly what I'm looking for.
I am just checking the progress of this issue and was wondering if you need any further assistance on the matter.