jQuery Grid Plugin – jqGrid

Hello,

We are glad to announce the new release of Guriddo jqGrid JavaScript version 5.9.0.
This version is a minor release and add replaces the existing features which causes problems and can not be used full.

The first one is the local data manipulation, where we have a used a eval based new Function to parse the data. This causes jqGrid not to run in CSP. The new module is rewritten and currently we do not use any eval and new Function

The second one in list is the virtual scroll. This module is entirely rewritten and  currently we support variable row height virtual scroll. See the docs for the setup. The old virtual scroll is still available for compatibility.

Loading the grid state with loadState does not require eval anymore.  We can now safely save and load the grid state.

The release has a lot of important bug fixes.

For a full list of additions and fixes look below:

Additions and Updates

• Replace the old local data manipulation engine of Hugo Bonacci with the new one v3.0.1, which does not use eval and new Function
• Rewrite virtual scroll module. See documentation
• Removing the runCode function which run simulated eval and optimizing the JSON parse function
• Make pivot grid and tree grid to work properly with the new local engine
• Change autoSelect method to work with the new local engine
• parseFunc which convert json string, containing functions, is rewritten so that it does not use new Function. The idea is to parse the json string, separate the functions and then include the string which contain functions as JavaScript in the code. This is dirty hack, but I do not see any other way to save the existing users not to change existing code.
• Restore grid state (loadState method) use the same approach of separating the functions. To make the script compatible with CSP the nonce parameter is added which should cover the the case when it is used. See documentation (read to the end)
• To overcome errors in frozenrows is added baseclass , so the user can set any custom additional class for the frozen rows. See setFrozenRows method.
• Now it is possible to add aria-label in column headers via property arialabel in colModel
• Add aria-label to close button x in modal
• Updates in lang files
• Add dataCleaner to local data to strip not needed keys in the input local data array (as from example Ember data)

Bug Fixes

• Fix saving unformated value in case of calculating the sumarries at once in pivot grid
• Fix pivot to get and calculate all the data at once
• Fix template select search dialog for jQueryUI
• Try to fix double pixel border when frozen columns in bootstrap 4
• Change class names for toast to overcome conflicts with other plug-ins. See : 1074
• Small improvements for frozen columns for bootstrap 5
• Fixes in getFormData in form editing to work correct with custom value and functions
• Fix for select element in case the split gets only one element to separate value and label
• Fix button position in info_dialog
• Fix adding the case when sorttype is function in local database manipulation (new engine)
• Fix transparency when grouping and the group value is shown. Now the content of the first cell in grouped row is shown correctly.
• Fix set ExpandColumn in case if it is not set in grid params.
• Fix setRowData title when TreeGrid and ExpandColumn. See : 1076
• Fix In frozen columns methods we add ‘if ( !this.grid ) {return;}’
• Fix unformat in expand column when of treegrid in form editing. See: 1077
• Accessibility fix: Adding role img to sorting icon
• Accessibility fix: To the pager records per page select box added aria label attribute and removed roles listbox and option form the self described element select and option
• Accessibility fix: added label for pager input text box
• Fix pager height in bootstrap 5. We need to have a value.
• Fix Columns without name should have title attribute
• Fix Set sufficient color contrast for no records to view row
• Fixes for search dialog for input and select elements to have aria-label
• Fixes for subgrid – add title attribute to button when expand and collapse row
• Fix Accesibilty improvements in form editing
• Fix Accessible park-able buttons in delete form
• Fix Make delete dialog parkable
• Fix pivotgrid to use datatype local
• Fix Adding aria-label to all elemets created with jgrid.createEl
• Fix exportToexcel includeHeader and includeFoooter . The export of these is possible only if the flag is true and the header footer row are enabled.
• Fix comboGrid method to use tab and to select correct values when enter key is pressed
• Fix – prevent json parse when empty string

Happy coding
Guriddo Team

We are pleased to announce the release of Guriddo jqGrid JavaScript version 5.8.2. This is a bug fix release.

Below is the list of the fixes:

Bug Fixes

• Update ES language
• Fix Can’t read properties of undefined colSpanHeader
• Fix column menu to be a scrollable in case of many columns
• Fixing not needed groups when build search and splitSearch function is on
• Fix excel export when colSpanHeader is on. Add mergecell in data object to all custom merging cells
• Fixes for comboGrid
• Fix frozen rows to prevent error when rowids array parameter is not defined – now rowids array is defined
• Fix Japanese language runtime error
• Fix exportToPdf when group header is on
• add method isServiceCol which return true if column is checkbox, row number, subgrid or search column
• Fix for columnChooser
• Add afterSetGroupHandler event which raises every time after group header is created
• Fix export to excel and pdf when group header is on and certain column of group is set to hidden.

Enjoy the version
Guriddo Team

[HTML1]

We are glad to announce the new release of Guriddo jqGrid JavaScript version 5.6.0.
This version is a minor release and add improvements in CSS styling (Bootstrap 5 support), aria grid, excel like grid navigaion and frozen columns improvements. The version has a numerous bug fixes. Below is the full list of all changes, bug fixes and additions.

Additions and Updates

• Add support for Bootstrap5
• Add method excelLikeGrid to simulate editing and key navigation like Excel
• Add event onFrozenColumnsCall which is triggered every time the method setFrozenColumns is called
• Adding new option in colModel labelClasses, which add custom classes to the labels in the grid.
• Replace javascrip eval function in all jqGrid code
• Improve ariaGrid and cellEdit to work better together
• Remove deprecated :eq and :first from setRowData method and replace it with .eq()
• Add customCellAction event in ariaGrid which raises when the user press key different from the predefined one up, down and etc.
• Update package.json to include the repository
• Add new common parameter frozenColCount to indicate the number of frozen columns when set
• Add Support for cell editing when ariaGrid and excelLikeGrid method(s) are activated.
• Add method getLastVisibleCol to get the index of last visible col
• Method setCell now support frozen columns.
• Method delRowData now support frozen columns
• Method setRowData now support frozen columns
• Add new method groupingInit, which set the grouping parameters to initial state.
• Add In groupingRemove method second parameter, which if set to true destroy all the grouping data
• Adding common function $.jgrid.isNull

Bug fixes

• Fix misalignment of columns when frozen columns and grouped headers
• Fix frozen columns in case scrollOffset will be set manually
• Fix for multi-select plugin remove all button, to work correct after the second click
• Fix adding classes property to the invisible first row in the grid – class=firstrow.
• Fix set predefined custom style in export to excel.
• Fix in addRowData method when no not rows in the grid
• Fix resizeGrid method when grid height is set to auto
• Fix hide no records row when emptyRecordRow is false
• Fix scrollbar in case no data and resizeGrid is called
• Fix saveRow to pass correct parameter in custom formatter when edit type is select
• Fix position of alert box in form edit in case the grid has height auto or 100%
• Fix refershFilterToolbar method to take in account the index from colModel
• Fix – do not create frozen divs and multiple calls of frozen columns without to destroy it first
• Fix setLabel method to work correct when column menu is enabled
• Fix colMenuBeforeProcess to be called in customMenu actions
• Fix for sortable (remapColumns method) to correct reorder grouping cells, when grouping is activated.

Enjoy the new version
Happy coding
Guriddo jqGrid Team

[HTML1]

We are pleased to announce the release of Guriddo jqGrid JavaScript 5.5.2. This is a bug fix release, with important fixes for Bootstrap 4. The documentation is updated according to the new release. Below is the list of additions and bug fixes.

Additions and Updates

• Add second parameter to setGridHeight, so that we set the entry grid height.

Bug Fixes

• Fix getDataIDs to not return “norecs” row
• Fix “norecs” row in case when add row with addRowData.
• Fix addRowData when add elements at certain positions in data array and fix reindexing of elements.
• Fine tune sort icons in bootstrap4
• Fix multiselect plugin to work with jQuery 3.5.x
• Fix pixel which causes scroll in Chrome in setGridWidth method when boostrap4
• Fixes for multibox header for jquery-ui css
• Fisxes for multisorting and sorting icons in Boostrap4
• resizeGrid now resizes to the parent/window height
• CSS Fixes for searchoperators in toolbar search
• Fix for the headerrow column in Bootstrap4
• Fixes for header row
• Fix find correct search operator in case there is a custom search element.
• Fixes for Frozen columns, stripped tables, group headers row hovering and row selecting in Bootstrap4
• Fixes for calling isGrouHeaderOn in filtering and exporting
• Fix icon position in navigator Bootstrap4 for fontAwesome
• Fix groupingHeaders when they are removed. Fix setGridWidth to remove/set frozen columns when it is executed. Fix position of data div of the frozen columns. Fix hovering in bootstrap
• Fix jquery UI css adding overflow hidden in navigator buttons with texts
• Fix remove centering of label cells when grouping. Add overflow hidden to long texts in navigator buttons
• Fix dirty-cell not being set and console error when saving using latest jQuery #972
• Fixes for boostrap4 modal-content class
• Fixed error “hasOwnProperty is not a function when saving data using jQuery 3.5.1
• Fix dirty-cell not being set on cells changed inline
• Fixing destroy group header function
• Fix Bootstrap4 warning dialog display property
• Fix grouping headers with frozen columns rebuilding.
• Bootstarp4 css fixes for group headers and frozen columns
• Fix hovering and highlighted selected row in Bootstrap 4 css
• Fix losing focus when setGroupHeaders is call.
• Fix sort icons in fontawesome and octicons css definition

Enjoy the new version.

Kind Regards
Guriddo Team

[HTML1]

Hello,

We are glad to announce the new release of Guriddo jqGrid JavaScript version 5.5.0.
This version is a minor release and add improvements in TreeGrid, local exporting, unary searching, new method max grid height and much more.
The version has a numerous bug fixes.

For a full list of additions and fixes look below:

Additions and Updates

• Added is a informative row in case no records are in the grid. Uses emptyrecords property from language file. See https://github.com/tonytomov/jqGrid/issues/950
• Disable freeze menu (in column menu) when subgrid, treegrid, celledit are on
• Add forcePgButtons parameter to force creation of pager buttons in responsive mode.
• Update Italian language file.
• Support of select All option in colmenu columns option. New option in coloptions object in colModel – columns_selectAll – default false. See docs.
• Add aria-sort attribute to support section 508 when sorting a column
• Add options sortTreeByNodeType (false/true) default false, sortTreeNodeOrder (asc/desc) to sort the tree by node type. I.e first node with children and then leafs or vice verso.
• Add option FullTreeSearchResult (false/true) default false to show the full tree node on found item in tree.
• In case of grouping headers set the columns to contain the parent and child names in searching dialog.
• Add support for hyperlinks in excel export
• Disable sorting in column Menu when sortable options in colModel is false and enable sorting only when this option and sorting option in colmenuoptions is true
• Add option navigationDisabled to disable navigation dynamically in aria module.
• Add Support new line in textarea in cell editing when alt + Enter is used in order to prevent saving data.
• Add new option in getRowData method to indent the expandColumn in case of treeGrid. Default is false.
• Add new option in all export modules treeindent to indent the expandcolumn when treegrid is exporting.
• Add options includeHeader in all export modules (exportToCsv, exportToPdf, ….) in order to support header row option when set. Default is true.
• Add method maxGridHeight to set and remove maximum height of entire grid
• Add option viewselected in viewGridRow method. If multiselect is true and this option is true viewing is enabled only to the selected grid rows in view grid mode.

Bug Fixes

• Fix local sorting in case date srcformat = newformat.
• Fix clearsearch values in filterToolbar
• Fix border-bottom in case of searchtoolbar and jQuery UI css
• Fix horizontal scroll bar in case shrinkToFit is set to false and no records are available.
• Fix pager in case it contain special characters. See https://stackoverflow.com/questions/57792149/jqgrid-pager-doesnt-display-when-its-id-has-special-characters
• Fix centering subgrid icon.
• Fix for the subgrid icon in Chrome
• Fix calculating autosize when Bootstrap is used
• Fix position of column menu when used jQuery > 3.x. See https://github.com/tonytomov/jqGrid/issues/951
• Fix export modules to read correct complex data structures in data
• Fix sorting a tree after search
• Fix setCell and setRowData methods to use the cellattr event in case of updating data. See: https://github.com/tonytomov/jqGrid/issues/953
• Fix editing module to use cellattr correct having all the needed data. See https://github.com/tonytomov/jqGrid/issues/953#issuecomment-554935412
• Fix formatting numbers in footer when colTotals is on in pivot grid https://github.com/tonytomov/jqGrid/issues/952
• Fix edit forms when jQuery UI CSS is used again with installed latest Bootstrap.
• Removing not needed css property zoom from bootstrap
• Fix hideCol/showCol to work correct with groupHeader
• Fix (Rework) setSortIcon method to better display left sorting icons
• Fix treeGrid to work correctly with local data
• Fix add serializeRowData in inline edit when clientArray is set as url
• Fix grid.utils.js module only to be run correct with jQuery.
• Fix delete norecs row in loadState after first initialization. This will be added correctly after calling updatepager
• Fix edit null line in inline edit. See https://github.com/tonytomov/jqGrid/issues/954
• Fix position of column menu when grid inside within element with left property
• Fix alert dialog position in navigator when grid is in bottom of the page in the scrolling window.
• Fix frozen columns (outherheight on row) to be compatible with jquery 3.x
• Fix sending correct sortnames and order to server when sorting and grouping is on and no sortname is set
• Fix grouping headers when it is set and autoresize is on
• Fix in all export methods to correctly export a treegrid.
• Fix getRowData, setRowData, editRow, saveRow and restoreRow to work correct only with single level down the DOM tree of table cell not including elements of other (sub)grids in the cell See https://github.com/tonytomov/jqGrid/issues/969

Enjoy the new version
Happy coding
Guriddo jqGrid Team
[HTML1]