jQuery Grid Plugin – jqGrid

A bug fix release 5.8.5 of jqGrid is published.

Below the list fixes:

Bug Fixes

• Revert back the change related to scrolling frozen columns.The new fix remove preventDefault, which break the code in certain situations. Making better
  calculations
• When calculating the the text length for autoresizing we need to exclude the hidden texts, done with using outerText property instead of text or html
• To the summary property of the groups we add the un-formated value which property is uv
• Fix frozen columns when label is empty according to the changed accesibility
• Fix check empty label columns in grouping and frozenColumns according to the new accessibility improvements
• Fix filterToolbar to be in sync with setColSpanHeader.
• Fix autoResizing to work correct with setColSpaneaders
• Fix for rowTotal – the issue is that if set in grid options that does not take any affect.
• 1 pixel fix if autowidth option is set and when expand to the window width

It is highly recommended when upgrading to this release to replace the CSS and language files too.

Happy coding.

Guriddo Team

We are happy to inform you that new version 5.8.4 of Guriddo jqGrid JS is released. This is bug fix release with many fixes. It also add support for indexeddb in case of working with big data on local computer. Below the full list of the additions and changes.

Additions and Updates

• Add indexeddb driver. Work with indexeddb table – searching, sorting, paging, update, delete insert record
• Support objects on $.jgrid.template
• Added new option in export to pdf: centerTableOnPage – to center the table on the page.
• Add method groupingResetCalcs to reset calculations in case of switching from one datatype to another. The method should be used before calling the triggering with the new datatype, See here: https://github.com/tonytomov/jqGrid/issues/1028
• Create two methods for updating in background the Edit and View form. Parameter pass to these methods is the id. See https://github.com/tonytomov/jqGrid/issues/1027#issuecomment-1434861403

Bug Fixes

• Fix selection and deselection in Frozen rows. Multiselect for now is not supported
• Fix calculation of position of frozen rows and resizing when responsive is on
• Fix empty on icon sort
• Fix frozen div to scroll with mouse wheel.
• Fix formatting summary values to be available everywhere. See https://github.com/tonytomov/jqGrid/issues/1034
• Fix for titlebar close button in case font-size is going bigger
• resizeColumn should not resize hidden fields.
• Fix frozen columns height when white-space is set to pre-line or normal in table cell
• Fix change the page after push Enter key into pager input
• Change the page after push Enter key into pager input
• Add a significant text to indicate that the span is empty or has no value
• Fix Empty table header
• Add title to row selection checkbox
• Remove the grid role in ‘ui-jqgrid-view’ div and add it in inner grid tables
• thead should have the rowgroup role
• Fix options without value accessibility issue
• Add title to checkbox to indicate if the checkbox is checked or unchecked
• Use concrete listbox role instead of abstract select role
• Add focus to the cross “x” to clean the column filter when we navigate the table with keyboard and add the click event that cleans the column filter value
• Add title to the column filter cells
• Add hidden span text to indicate div is empty
• Fix losing focus when autoresizing is on, with foren columns on, and search toolbar on, which frozen column is active search (the last one to close the door)
• Fix caption position when jQuery UI and menubar is true
• Support data.footer as array in export to excel if the data is customized.
• Fix focusing when paging and editing in ariagrid and excelLikeGrid
• Fix formatter actions edit del icons to be restored when beforeEdit return false.
• Small fixes for bootstrap 5 css
• Fix page 1 of 0 when no records on local data
• All events in the export now are called so that this within the event refer to grid and its properties
• FilterInput shouod return default object in case there is no value – this prevent filters froperty to be a full when no data is searched.
• Fix pivot in case yDimension value can not be get
• Fix toppager to show the total number of pages
• Do not prevent default when simulate click from other program
• Reload parent node when perform deleting in tree
• Make grouping calculations equal to dattype jsonstring and local – loop througth all the data.
• Fix wrong calculation of average value
• Fix exports in case average value is 0
• Fix data grouping to support frozen columns
• Fix all export modules when data grouping

Enjoy the new version
Happy coding
Guriddo jqGrid Team

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