Possible multiplecellsadvanced Issues with 3.0.1

[DavidSimmonsParticipant]

Keyboard navigation changed with 3.0.1 release. The cursor should go to the line below after editing and you should be able to now edit the new row. But with 3.0.1 cursor goes to the row below but you have to click on the cell to edit now….. So it seems the grid is losing focus but not sure.

[Peter StoevKeymaster]

Hi David,

That is not the behavior observed in our demo: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/cellediting.htm?web. When a cell is edited and I press Enter, the selection goes to the cell below. Now, I can type another value without having to click with the mouse.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[DavidSimmonsParticipant]

I have to perform a $(jqxgrid).jqxGrid(‘updatebounddata’); after each update because of support columns. Example when the user enters a product number I perform AfterCrudEvents to lookup multiple support columns like Product Description, and Cost which are a part of the same screen same record which forces me to do a $(jqxgrid).jqxGrid(‘updatebounddata’). In all previous versions this method work fine. In the new version 3.0.1 the grid loses focus or something. I can still move the cursor from cell to cell or change rows but to edit again it forces me to click on the cell. This makes no sense.

[Peter StoevKeymaster]

Hi David,

Is is really necessary to re-bind the whole Grid after updating a cell? If you want to update the other cells on the same row, you can simply use the “updaterow” method of jqxGrid. If you want to update the editor’s data source in case of DropDownList, you can do that in its column’s “initeditor” callback. I really do not think that a full update is required after editing a cell.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[DavidSimmonsParticipant]

I have been using JQWidgets for a while now and currently one of my main app are around 120000 one of code. This has been in production over a year. The reason I refresh after updates is due to near 20 AfterCrudEvents or php mysql statements that have to run after a column is updated. I am using preparedstatements and updating one column of the grid at a time. The support columns or calculations are what is being performed by the AfterCrudEvents. The number of AfterCrudEvents as well as the Type depend on the column that is being updated. This is a commodity type industry which detects much of the design.

So for me to not be able to updatebounddata on an update is a KILLER…. I am not sure why you want me to limit the application and design to a simple update of the complete row each time to work with the grid widget.

How about giving us a custom update capability and let us tell the grid to commit based on what we see necessary. I see this as a bug, but maybe I am wrong.

[Peter StoevKeymaster]

Hi David,

The Grid cannot know what is necessary in your scenario to be committed. As you know, all the synchronization with your server should be done by you, not by the Grid. Yes, I don’t think that a full data update of the Grid is necessary, but it is your decision whether to do it or not. That was just a suggestion. And of course, when updatebounddata is called, the Grid will be re-rendered which means that the focused HTML Elements will be recreated and so the focus will be lost as expected.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[DavidSimmonsParticipant]

Is there a method to set focus on the grid->row->cell. When you make the update you know the rowid and the cell index. That would take care of my issue and be great, but i have not found a way to do that.

[Peter StoevKeymaster]

Hi David,

The Grid’s “focus” method puts the focus on the Grid.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts