jQuery Grid Plugin – jqGrid

New version 5.8.7 of Guriddo jqGrid JS is released. The version contain numerous bug fixes and a lot of useful additions. Below the full list of the additions and fixes.

Additions and Updates

• Add new function to add custom excel style – font and colors in onBeforeExport event
• Added parameters – this, value and options in editoptions.value object when it is a function. See: https://github.com/tonytomov/jqGrid/issues/1049Replaced the complette ajax event with success to fix server latency.Changes in headerData and footerData – added actions, addrow, delrow, remove. Action set can set data on certain position. Additional parameter is added index – to determine on which index to perform the action
• Added parameter method (default GET) to excelExport which allow posting data with GET or POST
• Add postForm function to post data to server without ajax
• Add shadow class to support it in columnMenus and navigator actions menu
• Add support for label class in form editing + fix position of dropmenu in navigator
• Addition: if custom_value function return #ignoreme# the element is not added to the postdata to be posted to the server. This allow to ignore element by condition when post to the server.
• Add function isVisible to resize only visible grids when responsive flag is on
• Add minGridWidth and maxGridWidth grid parameters to which grid can not be resized defaults are 100 and 3000.
• Add boolean grid parameter resizeHeight (true) to resize height when responsive is on. Set it to false does not resize the gridheight
• Add name attribute to the pager selectbox
• Add deleteIfExists in dbconfig (indexedDB) to determine if the existing data should be cleared when loading new one. Add reader property in the same to filter records – this can be a Function
• Add onMultiSelect event which executes when action is performed
• Add onErrorLoadData for simple subgrid when do ajax request. Added ajax error event in ajax populatesubgrid function.
• To the multiselect checkboxes we can apply custom formatter
• Add possibility in info_dialog to control the overlay
• Add option items in colMenuAdd o be a possible to create one level submenu. Properties for text icon and run of items array are the same as for item menu
• Optimize starsWith and endsWith in from function
• Add tooltip property to setColSpanHeader too.
• Add tooltip (title attribute) to setGroupHeaders
• In onkeyCheck event is added a object baseFunc which contain the basic functions for movements in excelLikegrid. The following are available: bF.isValidCellm bF.getNextCell, bF.getNextVisibleCell, bF.movePage

Bug Fixes

• Fix for setColSpanHeader to support html lables
• Fix setColSpanHeader to accept html tags in titleText
• Fix rowNum and other issues related to the rowIndex. See https://github.com/tonytomov/jqGrid/issues/1063#issuecomment-2106461023,
• Set info_dialog to get the style in case the defaults.styleUI is set.
• Fix deprecated substr in all modules. See: https://github.com/tonytomov/jqGrid/issues/1059,
• Re-initializing v variable to prevent its assignment to the next filter fields
• Fix grid in case it is within form tag and a enter is pressed. This caused submitting a form
• Fix editing cell if row is disabled with a disabled class
• Fix cellEdit in case no ariabody and enter key saves the cell.
• Fix destroyGrid in case the grid does not exists
• The footerData and headerData methods should get the un-formatted value when format parameter is on
• Add scope=col to labels. We need to fix this for the grouped headers too.
• Fix modal classes and info_dialog function
• Show info dialog when error in indexedDB crud operations.
• Fixes in deletestorageRecord and addstoragerecord and updatestoragerecords method in indexedDB
• Fix selectAll check box not to be on when there are no records in the grid and preserveSelection is on
• Fix identify selects in search form – the must have at minimum name attribute
• Fix delete dialog width (bootstrap 5)
• Fix navGrid not to create alertmod info dialog when it is created. This causes too many content in case of subgrids with navigators. Now we create in line dialog and remove it after it is closed.
• Fix Add name attribute to some inputs elements for browser readers
• Fix autowidth to be calculated before to put any content from the grid. Small improvements for bootstrap
• Fix check the unformatted value in editCell https://github.com/tonytomov/jqGrid/issues/1055
• Fix setGridWidth to remove the unneeded scroll when height auto and grid is resized.
• Fix dropmenu=true to show all description texts when no button text is set
• Fix custom button margin in pager in BS5 CSS
• Fix calculating the count and return the right style number in addExcelStyle method.
• Fixes for headerData/footerData in bootstrap.
• Fix getTextWidth to update the font correct every time it is called with different one.
• Fix in indexedDB when sortname are not set. We set the first field from colModel
• Fix autosize_headers in case the label is changed with setLabel method.
• Update grid.locale-he.js
• Fix frozen columns when grouping and the grid is initially invisible: See https://github.com/tonytomov/jqGrid/issues/1041#issuecomment-1660613019
• Fix frozen Columns in case of grouping and height auto See: https://github.com/tonytomov/jqGrid/issues/1041#issuecomment-1660790265
• Fix returnAsString in ExportToCsv
• Change the logic of saving the row when textarea and enter is pressed. First we check for onEnter event and then if the input is textarea.
• Fix modal position when rtl and width is set to auto

Enjoy the new version
Happy coding
Guriddo jqGrid Team