jQuery Grid Plugin – jqGrid

Dear all,

We are happy to let you know that the new 7.0.0 version of our Guriddo Suito PHP  is available from today. This is a completely new version rewritten for PHP 8.

This version has the same functionalities as the previous one, but is optimized to work with PHP 8.

In general, the new things that are available in this version are:

1. Full support for bootstrap 5
2. Brand new auto-completer and date-picker components with Bootstrap 5 support.
3. Logger for easy troubleshooting.
4. Completely new Scheduler with a modified interface
5. Improved operation of form and validation classes
6. Improved export to PDF, Excel and CSV
7. Completely redesigned demonstration center
8. A new class of transposed grid
9. Improved installation of Visual Form builder
10. Completely rewritten documentation

and many more improvements and bug fixes.

(Check the Demo on this site to see updates.)

Due to the fact that it is quite difficult to maintain standard (obfuscated) and subscription versions, we have decided from today to have only one version of the product.

Obfuscation is not a solution to preserve technology solutions, and so we decided to only have a source code version. This will make it too easy for the developers and ourselves.

The trail version that we will provide for testing will be trimmed from many features and will only show the main capabilities of the product.

All users with an active subscription plan will receive the new version.

For all existing customers without an active subscription plan, we are offering 60% discount to renew until the end of April.

The old version 5.5.5 will be supported for one year without further development. All efforts and funds will be directed to the new seventh version.

We hope that these changes will make your work easier and better.

As always, we put product support first and strive to improve it with your feedback.

Last but not least, we want to express our heartfelt thanks to all our existing users who took part in testing the new product and all the while giving us valuable advice to improve it.

Best wishes for fruitful work
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

Hello,

We are glad to announce the new release of Guriddo jqGrid JavaScript version 5.8.0.
This version is a minor release and add improvements in local exporting, add new col-span
header method to, new experimental comboGrid, improved columns searching and much more.

The release has a lot of important bug fixes.

For a full list of additions and fixes look below:

Additions and Updates¶

• When groupHeader is on the names appear in columns colmenu
• Support colSpamStyle when export to excel and pdf and header grouping is on
• ColumnChooser can not take in account grouping header values. To activate set groupHeaders to true in the method options.
• Define inColumnHeader function as common to overcome writing repeated code
• Added experimental comboGrid method
• filterInput method can now be used for remote(ajax) data. Added new parameter to it selectFirstFound to highlight(select) the first found record in grid and firstFoundTimeout
• Add new boolean parameter in bindKeys – onSlectRow – which disables or enables the execution of onSelectRow when enter is pressed. Default true.
• Make getGridRowById method to use the much faster namedItem JavaScript build in function.
• Add new method getGridRowByIndex to return the grid row by index.
• Add grid parameter defaultColWidth default column width parameter in case the width is not set in colModel.
• Add maxWidth option in colModel to support maximum width in columns. See https://github.com/tonytomov/jqGrid/issues/1019#issuecomment-1296806264
• Add two new methods hideSearchCol and showSearchCol to show and hide columns when searchCols is on
• Update the Romanian language file
• Added onHeaderKeyCheck event in the methods ariaHeaderGrid or in setAriaGrid to check the key when the navigation is on the header cells. Accept index an event as parameters.
• Change the number of parameters of onKeyCheck in ariaGrid ariaBodyGrid and excelLike grid
• Add option visibleCoumns in searchColOptions to exclude a search on certain columns.
• Remove column menu when show/hide col and do not remove it when sorting
• Changes in dialogs bootstrap5
• Add possibility to include fields by name in the summaryTpl formatting string. See https://github.com/tonytomov/jqGrid/issues/1015#issuecomment-1176405115
• Add possibility to export only visible tree nodes in all export modules. The option is visibleTreeNodes, which by default is false.
• Add option excel_header_format in exportoptions to separately format the header labels in export to excel.
• Added new event replace_header_format, which is similar to replace_format, but only for the headers
• Add labels array in data object parameter so that we can modify all the data before export in export modules. See customizeData event.
• Adding Shift key to the disabled array in searchColOnKey method.
• Added multiseparator option (string) in select editoptions to custom separate the data when multiple select is used instead of “,”
• triggerToolbar function accept parameter page to load certain page after triggering the search.
• Add methods setColSpanHeader and destroyColSpanHeader to span header cells in grid header.

Bug Fixes¶

• Fix scrollMaxBuffer to work correct when virtual scroll is enabled.
• Fix colmenu select in bootstrap5
• Fix customFilterDef to run correctly after replacing eval
• Fix loadState and jqGridExport methods to work correct when searchCols is on.
• Fix not needed calculation when autoResizing is off, which can cause memory and time consuming in case of relative many rows and columns
• Fix for bootstrap 3 css
• Fix sizingString Function to accept options from formatter.
• Fix title in serch dialog subgroup button
• Fix for rtl
• Fix sorting parameters when grouping is removed
• CSS fixes for bootstrap5
• Fix Bootstrap5 alert class
• Fix grouping when groupingCollapse true and showSummaryOnHide. See https://github.com/tonytomov/jqGrid/issues/1014
• Fix searchColOnEnter to work correct when frozenRows is on
• Fix bootstrap5 to view the form without transparency
• Fix horizontal scroll when filterToolbar.
• Fix exportToExcel date fields.
• Fix export hidden cols in exportToExcel
• Fixing destroyColSpanHeader to do hide=false on the hidden spanning columns
• Fix form edit form when initially set to auto and then reopen it without to change its position
• Fixes for Bootstrap5 – search dialog and filter toolbar.
• Small fix in setFrozenRows when data is already here (to quick)
• Fix setRowData in case of treeGrid and the column is leaf

Enjoy the new Release
Kind Regards,
Guriddo Team

Hello,

We are glad to announce the new release of Guriddo jqGrid JavaScript version 5.7.0.
This version is a minor release and add a lot of new features in improvements – Transposed Grid, Frozen Rows, Search by column and much more. As usual the version has a numerous bug fixes.

For a full list of additions and fixes look below:

Additions and Updates

• Add new transposed module which convert rows to columns Demo Docs
• Add new frozen rows module Demo Docs
• Add searching by column values. Demo Docs
• Improve maxGridHeigh method. Add third parameter to indicate the minimum height at which the method run.
• Add pager input to be configurable – i.e replace the input with text See
• Changes in language file
• Add title text when hovering column menu
• Adding searchColumn menu when the new search is enabled
• Add two new methods disabelColMenu and enableColMenu to disable and enable dynamically the column menu at specified column.
• Add colMenuBeforeProcess for column menu as triggered event (grid option) + fix for building menu custom column menus
• Optimizing rebuild calls when autoresizing is on
• Scroll the form to top to view the error in case there are a lot of fields on it
• Add stripScript function
• Add customizeData event in exportToExcel which allow to work on the raw data before to export,

Bug Fixes

• Fix problem when ariaGrid and searchColumn are on.
• Fix setGridWidth when shrinkToFit is true and the data height is < gridheight (no vertical scroll) and show hide columns are performed
• Fix sync the searchColumn with aria grid.
• Prevent change the state of select box in multiselct mode when beforeSelectRow Return false. See
• Prevent header checkbox (when multiselect) to go back in off state when it is off. See
• Fix maxGridHeight to work after data is loaded. Remove not needed aftercomplete event. See
• Fix multisort when frozen is off
• Second fix for the callinf events with options parameter
• Fix for previous fix when calling bindEvents with option parameter
• Fix passing correct oper option when editing data plus adding the option array in dataEvents as parameter – the first parameter is event the second is a option
• Fix show sort icons when frozen columns are on
• Fix typo name in transposed module
• Fix horizontal scroll when filterToolbar is on
• Fix scrolling grid in certain cases.
• Fix + optimization in frozenColumns method.
• Fix mixing local names in resizeColumn
• Fix parameter name in progressBar function
• Fix for sort icons to be found correct
• Fix multisort when frozenColumns and autoresizing are on
• Fix when multisorting
• Fix for IE11 in stripScript function
• Fix for IE11 to use the new features in 5.6.0
• Fix ungroup from column menu
• Fix prevent XSS in search textbox when showQuery is on ,
• Fix passing correct parameter in custom_value function in form editing ,

Enjoy the new version.
Kind Regards
Guriddo Team

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