jQuery Grid Plugin – jqGrid

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

We are pleased to announce the release of Guriddo jqGrid JavaScript and Guriddo Suito PHP versions 5.5.5. This is a bug fix release, with few useful additions. The documentation is updated according to the new release. Below is the list of additions and bug fixes.
 

PHP Changes

 

• Making easy work with dates when php >= 5.3.0
• Fix autocomplete to work with inline edit when 3 items are requiered

 

JavaScript Additions and Updates

 

• method GetFont now return more parameters to calculate precisely the width in canvas
• optimize intNum function and add new floatNum function for more compact calculations
• Add new colModel option autosize_headers – if set to true it will include the headers cells when calculation max width for auto re-sizing feature
• Add close button to search dialog in column menu
• Add aria-label=Close to elements without text which close the dialog s
• Add P option to date formatting . See https://www.php.net/manual/en/datetime.format.php
• Rename build.gradle to build_gradle
• Code and speed optimizations in filterToolbar method
• mergeSearch options is added in colMenu searching
• Add possibility to search in filter toolbar splitting the word separated with option splitSearchSeparator which produce or logic. By example entering a;b in search field will produce field == a or field == b
• Add grid option emptyRecordRow which enables or disables the No records to view row. Default is true.
• Add new parameter in dragEnd function to disable calling recreation of frozenColumns
• Add new common function – getElemByAttrVal to get element by attribute value from array of objects element
• Add new parameter in resizeColumn method to not recreate forzenColumns.
• Add possibility to use a predefined excel formatters again with possibility to format the excel value as true text – set exportoption excel_type =’text’. See: https://github.com/tonytomov/jqGrid/issues/984
• Add new utility function isJSON to check if the given value is (valid) JSON object.
• Changing parameter name in getGridParam which conflicts in some frameworks: https://github.com/tonytomov/jqGrid/issues/986
• Add a utility function dateToOADate to convert an ECMAScript Date to a Microsoft OADate. Used for export to excel for better date formatting.

 

JavaScript Bug Fixes

 

• Fix column name parameter in colMenuBeforeProcess when freeze
• Fix disable sortable columns with mouse on frozen columns.
• Fix for parameter disabledKeys in fillterToolbar method in order to prevent error in save/load-Sates methods.
• Fix for key-press in fillterToolbar when grid is restored from loadState
• Fix column grouping in state restoring loadState
• Fix column menu searching when reset is pushed and data is local with grouping
• Revert back the changes in setCell and setRowData methods so that we do not change the existing cell properties.
• Fix forzen column when re-sizing and calling it correct when rebuilding.
• Fix filterToolbar to restore correct the search in loadState when mergeSearch is on
• Fix for filterRefactor function to find correct the included fields
• Fix the _No records to view_ row to be not editable.
• Fix css presentation of custom element in filter Toolbar. Fix executing search on custom element in filterToolbar
• Fix auto re-sizing no to recreate frozenColumns on every column
• Fix toolbar search to keep the search values on frozen columns
• Fix showing sort icons on frozen columns
• Fix bug in setLabel method
• Fix for ie11 when using filterToolbar disabledKeys
• Fix gridResize method to work with bootstrap.
• Fix small problem in jquery ui resizable which should attach only one class with comma
• Fix export to excel when formatter return &nbsp
• Fix mergeSearch to work with single search in dialog searching (multipleSearch = false)
• Fix local sorting to work with local special characters https://github.com/tonytomov/jqGrid/issues/982
• Fix custom formatting in export to excel See: https://github.com/tonytomov/jqGrid/issues/983
• Fix forzen columns vertical synchronization when a new column is set to frozen.

 

Enjoy the new version.
Kind Regards
Guriddo Team

We are happy to inform you that the new release of Guriddo jqGrid JS version 5.5.4 is released. This is bug fix release, but add a full support of jQuery 3.5.X, has numerous important fixes and add a very useful additions. Below is the list of additions and bug fixes.

Additions and Updates

• Add new feature combined search – to combine search results in different searching modules. Added two new parameters – mergeSearch (boolen) and searchModules (object). See searching in documentation.
• Add two parameters to resizeGrid to enable responsibility on width and/or height
• $.jgrid.parseDate now can be used without to be applied to a grid object. Added new option parameter for validation
• Add colModel sizingStringFunc which is a user defined function to calculate the max width of column value. Parameters to it are cell value, font, options and row data object. Should return the width of cell value.
• Add grid event colMenuBeforeProcess to be executed before any action in any column menu defined. Parameters passed to it are module, action, and column name

Bug Fixes

• Fix no records message in frozen columns
• Fix group headers in case of autoresize is applied with double click
• Fixes for position dialog s (edit, view, search) when rtl is on and recreateForm is false
• Disable searching in filterToolbar when press special keys like alt, ctrl and etc. and autosearch is enabled.
• Fix exports in grouping
• Fix setGridWidth method when shrinkToFit parameter is set to false
• Fix getCol and getRowData methods in case of no records message appear.
• Replace the deprecated jQuery.isArray with Array.isArray
• Replace deprecated jQuery.isFunction with $.jgrid.isFunction
• Replace deprecated jQuery.type with $.jgrid.type
• Replace deprecated jQuery :first with first()
• Fix autoresizing when hidden columns are present.
• Fix frozen columns in certain situation when the first columns are hidden
• Fix icon position left in bootstrap4
• Replace deprecated jQuery :eq with eq()
• Replace deprecated jQuery :last with last()
• Replace deprecated :gt with slice
• Replace jQuery $.trim with $.jgrid.trim
• Fix pager when RTL.
• Fix transparency of header and footer rows in Boostrap4
• Fix frozen columns in various situations

Enjoy the new version
Happy coding
Guriddo jqGrid Team