jQuery Grid Plugin – jqGrid

We are pleased to announce the release of Guriddo jqGrid JavaScript 5.5.1. This is a bug fix release with important fixes on tree grid.

Below is the list of the fixes:

Bug Fixes

• Fix preserving original values in method getRowData when using indent
• Fix reloading tree after search when treeModel is adjacency
• Fix for xml data when reloading tree node
• Fix formatting numbers in summary, header and footer data in excel export

Enjoy the new version.

Kind Regards
Guriddo Team

We are happy to inform you that the new release of Guriddo Suito PHP version 5.5.0 is released
This version is a minor release and add interbase SQL driver, improvements in TreeGrid, server and local exporting, unary searching, new method max grid height and much more.

PHP

Additions and Changes PHP

• Rewrite Intebase SQL database driver
• Support radio buttons in jqForm
• Added excel export options empty_date which set a empty date when the date is null or empty
• Use build in date functions when php >= 5.3.0

Bug fixes PHP

• Fix obfuscation error
• Fix deprecated function magic quotes to be compatible with php version 7.4
• Removing zoom property in css files

JavaScript

• For all additions and fixes see here

Enjoy new version
Guriddo Support Team

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

We are pleased to announce the new Guriddo jqGrid JavaScript version 5.4.0 release.
This version is a major release and add a support for Section 508, custom defined search, custom excel formatting and much more. A lot of numerous bugs are fixed and documentation is updated accordant.

Below is the full list of the additions and fixes.

Additions and Updates

• Add new module grid.aria.js to support section 508. See docs for details. Demo
• Add automatic and custom auto-re sizing of columns on data loading. Two new options autoResizing in grid option and autosize in colModel. Demo
• Add a custom defined search filter see grid option customFilterDef. Demo
• Add custom excel formatting with introduction a new option in colModel exportoptions. Demo
• Add parameter loadIndicator in all export modules (pdf, csv, excel, html). Can be a function or Boolean. Demo
• Add support for in and not in operands when searching local data. Demo
• Add support for frozen row at header – option headerrow (similat to footerrow ). Demo
• Add method headerData and support of userDataOnHeader for the frozen header row
• Add method autoSelect similar to Excel auto filter for search type select. Works only on local data and toolbar filtering. Demo
• Remove not used parameter in scrollGrid internal function
• Remove currentview parameter from getRootNodes and getNodeChildren since the view and the data are the same in treeGrid
• Add onBeforeExport event in exportToCsv method
• Extend options parameter in createEl function with property module for determining from which editing module is called. The new parameter is module with the following possible values : cell, form, inline
• Add option decodeValue in formatter select in order to decode value in case it is encoded. This fix a selection of displayed value.
• Making the pager buttons and info responsive.

Bug Fixes

• Fix scroll in Chrome when height auto or 100% when Bootstrap
• Fix delRowData in multi-select mode when the parameter is integer. See https://github.com/tonytomov/jqGrid/issues/935
• Fix for local search comparison of numeric values in case a non-numeric is entered
• Do not remove the ids of edited rows when reset the selection
• Fix option scrollOffset when rtl is set
• Fix method setGridWidth in case of multiple headers
• Fix method setGridWidth in case grouping headers is on and there is a horizontal scroll.
• Fix column menu position in case when group header is set
• Fix form edit option checkonUpdate in case edittype is select with dataUrl is used
• Fix for numbers with length > 15 in the in excel export method exportToExcel in the new parsers.
• Fix multiple search in case of jQuery 3.x
• Fix formatter select to set correct all attributes in case no value option is set
• Six treeGrid functions which add/edit/delete data to be compatible with idPrefix option
• Fix getRowData method to take idPrefix in account when parameter usedata is on
• Add BOM to fix excel bug when exporting to csv and the charset is utf-8
• Fix clear search value in toolbar filtering when column reordering is enabled.
• Fix exporting integer 0 in excel export.
• Fix export to excel in case a number is detected (prevent double value creating in case of multiple parser which meet the condition)
• Header and Footer user data should be not formatted (userDataOnFooter, userDataOnHeader) when placed in grid. They should npot use the formatter for that column

Enjoy the new version

Guriddo Team

We are pleased to announce the release of Guriddo Suito PHP 5.3.2. This is a bug fix release, with few useful additions. It add support for Interbase database

PHP

Additions and Changes

• Add support for Intebase database (add interbase driver jqGridIbase.php)
• Add parseSort variable (default true) to enable/disable parsing the sortname and sortorder when they contain special chars

Fixes

• Fixes for paging in TreeGrid php
• Fix customFunc to be executed when export is performed. This apply only for the userdata and not a data.
• Fix create_function in Form.php and Visual builder to be compatible with PHP 7.2

JavaScript

• For all additions and fixes see here

Enjoy the new version.

Kind Regards
Guriddo Team