Home > jQuery > Guriddo jqGrid JavaScript 5.2.0 is released

Guriddo jqGrid JavaScript 5.2.0 is released

November 21st, 2016 Leave a comment Go to comments


We are glad to anounce the immediate availability of Guriddo jqGrid JavaScript version 5.2.0.
This version is a major release and add a support of jQuery 3.x.
Another usefull addition is true export to Excel, PDF and CSV with our new export module. See our updated demo

Below is the list of additions and fixes:

Additions and Updates

  • Support to jQuery 3.x
  • Added a export to CSV, Excel (open excel format) and pdf. For excel we need additionally jsZip and for pdf pdfMake libs.
  • Add saveAs function in util module, which do a browser save dialog for saving diffrent data type.
  • Update Portugase translation file grid.locale-pt.js
  • Add a new event – validationCell which may occur (if defined) when a validation error. Parameters – element, error message, iRow and iCol. When restoreCellonFail is set to false now we focus the cell when info dialog is closed
  • Added method setSortIcon. the method changes the position of the sort icon at left or right. The first parameter is the column name or the position of the column in colModel starting from zero. The second parameter is left or right(or empty or nothing).
  • Update of lang files for the serch dilogs
  • Update for the language spanish file.
  • Update of Bulgarin, German and Russian lang files according to the new search text
  • Adding validationCell event custom message in inline edit. Parameters passed to this are the element, error message, row index and column index.
  • Update Chinese Translate for v5.1.1
  • Adding custom aggregate function in pivot grid. In the aggregates array the aggregator now can be a function.
    Parameters passed to this function are: value, field name, data record
  • Making possible to run addLocalData as grid method. Added a parameter(boolean) which set if we need all the data (and not paged one)

Bug Fixes

  • Fixes in import module.
  • Fix cc variable in cell edit to be a jQuery object causing error. See https://github.com/tonytomov/jqGrid/issues/812
  • Fix pivot in case yDimension is not set
  • Fix getRowData when the second paraneter is not set
  • More tolerante checking of isEmpty function in formedit validations
  • Fix for beforedrop event in the gridDnD method.
  • Fix for avg function in pivot
  • Fix: Data in pivot should be array.
  • Fix cacheUrl to accept empty values in case in case they are defined in option value.
  • Fix getting the cell data in cell edit mode
  • Fix: Added missed translation text in serach dialogs for the button rules.
  • Fix get cell to return the right content of the ExpandColumn field when treeGrid is on
  • Fix for Bootstrap horizontall scroll bar when height auto/100%
  • Fixed misspelling of “inline-block”
  • Fix info dilog when error from the server – position the dialog ner to the cell and focus a field if restoronCellFail is false
  • Try to focus the field in inline edit when a validation error occur
  • Fix finding the position of the objec. We need the cuurent position of the screen.
  • Fix pivot initial sorting when set in grid options as sortname
  • Fix pager info for loaded records when adding new one and virtual scroll is enabled.
  • Formatting changes
  • Fix adding non empty id in editGridRow (fix is for treegrid)
  • Fix German locale toolbar search options

Enjoy the new version.
Trirand Team

  1. March 9th, 2017 at 03:02 | #1

    We are evaluating your jqgrid 5.2 with bootstrap 3.0 http://www.guriddo.net/demo/bootstrap/ — I don’t see the an option to export to xlsx
    but I saw a working version from here

    I tried to combined the 2 version and include the jsZip library

    However I could not get very far with the following error:
    Uncaught Error: Invalid XML:
    at Function.error (jquery-2.1.1.min.js:2)
    at Function.n.parseXML (jquery-2.1.1.min.js:4)
    at HTMLTableElement. (jquery.jqGrid.min.js:1513)
    at Function.each (jquery-2.1.1.min.js:2)
    at n.fn.init.each (jquery-2.1.1.min.js:2)
    at n.fn.init.exportToExcel (jquery.jqGrid.min.js:1483)
    at n.fn.init.$.fn.jqGrid (jquery.jqGrid.min.js:101)
    at HTMLButtonElement. (BaseView.csp?page=v1:107)
    at HTMLButtonElement.dispatch (jquery-2.1.1.min.js:3)
    at HTMLButtonElement.r.handle (jquery-2.1.1.min.js:3)
    error @ jquery-2.1.1.min.js:2
    n.parseXML @ jquery-2.1.1.min.js:4
    (anonymous) @ jquery.jqGrid.min.js:1513
    each @ jquery-2.1.1.min.js:2
    each @ jquery-2.1.1.min.js:2
    exportToExcel @ jquery.jqGrid.min.js:1483
    $.fn.jqGrid @ jquery.jqGrid.min.js:101
    (anonymous) @ BaseView.csp?page=v1:107
    dispatch @ jquery-2.1.1.min.js:3
    r.handle @ jquery-2.1.1.min.js:3

    I wonder if you can provide a working version export to xlsx with bootstrap integration or if you can point out what I have done wrong.

    Many thanks,

  2. March 9th, 2017 at 10:23 | #2


    The Bootstarp implementation does not have connection with the export to excel.
    It all depend how you do this and we do not see it.

    Please send a mail to support at gurriddo dot net in order to see what you do.

    Kind Regards

  3. Ed
    April 6th, 2017 at 18:08 | #3

    Do you know when the bootstrap version will have the export feature? Or is there a way it can be added by the developer? Thanks!

  4. April 6th, 2017 at 18:24 | #4


    Export in Bootstrap works fine. Maybe you mean a bug which does not work in IE when export to Excel independent of the CSS Framework used.

    Here is the working example – export to excel with Bootstrap

  5. carolyn
    July 7th, 2017 at 22:31 | #5


    I receive the same ‘Uncaught Error: Invalid XML’ message when trying to Export to Excel (am not using bootstrap).
    Was a cause/fix ever determined?

    Many thanks!

  6. July 8th, 2017 at 09:26 | #6


    In order to solve the problem I need a test case, which shows the problem. You can use our public forum here : http://guriddo.net/?page_id=4

    We have fixed a lot of problems, but every problem is particular, so I need demo


  1. No trackbacks yet.

Privacy Policy   Terms and Conditions   Contact Information