Home > jQuery > jqGrid 4.3.0

jqGrid 4.3.0

December 12th, 2011 Leave a comment Go to comments

Hello All,

We are happy to announce the fresh new jqGrid 4.3 release. This release adds a lot of new functionality and bug fixes. Here is what is new:

  • Column Freezing – you can now freeze the first N columns of the grid, so that a horizontal scroll bar appears and they stay fixed (frozen) while you can still scroll the un-frozen columns.
  • Inline add new row – we figured we have “Add New Dialog” – why not have the same functionality for inline editing as well.
  • Inline navigator – a better way to handle control buttons while in inline add/edit/delete modes
  • This one thanks to Oleg – support reading any data from XML including attributes. Thanks again Oleg – your efforts are much appreciated.
  • jQuery 1.7.1 and ThemeRoller 1.8.16 support – the latest jQuery and ThemeRoller releases are now officially supported and tested.
  • A LOT of fixes.

The documentation and examples are up to date. You can see it in the appropriate pages. You can have a look at how jqGrid works in this poker games website where this has used on iPhone poker sites and apps to make poker games.

Please, let us know in the comments below what you think about this release and what do you expect in the next releases. Top of list for now – sorting by multiple columns and grouping by multiple columns.

We’d like to also remind you that we have released 4.3 for our commercial set of components available here – http://www.trirand.net . You can find many additional components like chart, scheduler, jqForm + FormBuilder, datepicker, autocomplete, PDF/Excel/Image exports, automatic binding with no code to all databases (MySQL, Postgre, Oracle, MS SQL), automatic codeless CRUD, etc. We currently provide tools for PHP, ASP.NET WebForms and ASP.NET MVC.

On behalf of the Trirand Team, we’d like to wish you merry Christmas and a great new year.

Yours,
The Trirand Team


Tags:
  1. Jack B.
    December 12th, 2011 at 20:51 | #1

    Thanks and Merry Christmas!

  2. Jack B.
    December 12th, 2011 at 20:54 | #2

    The Downloads page still reads “4.2.0.”

  3. December 12th, 2011 at 21:12 | #3

    Jack,
    Thanks. Fixed.

  4. Sandeep
    December 12th, 2011 at 21:53 | #4

    Frozen Column not working in the examples also on Trirand. Please verify.

  5. quincy
    December 13th, 2011 at 08:50 | #5

    Tony,
    The frozen column in demo page didn’t work well on Chrome.
    In Chrome, the grid do not have the horizontal scroll bar after load and only appear after I drag and increase one of the column’s width.
    Then the scrolling didn’t run well as the bottom row behave strangely.
    I think it has something to do with the run time generated horizontal scroll bar.

  6. December 13th, 2011 at 09:13 | #6

    @Sandeep,
    The demo work ok for us. Please when go to demo page clear your browser cache and reload/restart the browser.

    @quincy
    There is no problem on this. I just changed the demo so that the initial grid has a horizontal scroll. As well the second example is ok too.

    Kind Regards
    Tony

  7. zendy
    December 13th, 2011 at 12:46 | #7

    can I get the newer demo files download same as the demo page? I want to run in my localhost. please

  8. Ivan
    December 13th, 2011 at 16:02 | #8

    where are the demos for this new version?

    Demo Page (new window)

    jqGrid PHP component Demo
    jqGrid ASP.NET Webforms component Demo
    jqGrid ASP.NET MVC component Demo

    What is the page for version 4.3.0?

  9. jhonnie
    December 14th, 2011 at 11:41 | #9

    ,wow!
    frozen column is awesome!!
    nice gift this christmas

  10. Mojtaba Jamali
    December 14th, 2011 at 11:59 | #10

    Great work as always,
    Thanks Jqgrid team.

  11. Doraneko
    December 15th, 2011 at 02:25 | #11

    Uaaaaah!!
    I’ve been waiting for Frozen Col!!
    I appreciate for the new release.

  12. A1901
    December 15th, 2011 at 09:18 | #12

    I use that Jqgrid 4.3.0 for frozen column.but it does not work,because page take automatically the width as sum of all column width.so no scroll bar come for frozen column.i use the default css.

  13. December 15th, 2011 at 09:20 | #13

    @1901,
    Please look carefully in the demos. You will need to set shrinkToFit to false

  14. A1901
    December 15th, 2011 at 16:22 | #14

    @tony
    Thanks for help
    but now there is another problem.
    frozen column is coming twice and is overlapping with the first one.And sliding
    with others.

  15. Corneliu
    December 15th, 2011 at 18:57 | #15

    If multi-select is true then selection is ambiguous (check box selection is different than colored-row selection

  16. Maika
    December 15th, 2011 at 20:07 | #16

    first of all thanks alot for this christmas gift, I was wondering where I can see a demo with “Inline add new row”??

  17. jhonnie
    December 16th, 2011 at 07:09 | #17

    Hi Tony

    I already use frozen column with the footerrow

    but the problem is the scroll bar is on the top of footerrow,
    how can I fix that?

    here are some of my codes:
    colNames:[‘ID’,’Name’……],
    colModel:[
    {name:’id’,index:’id’,key:true,frozen:true},
    {name:’name’,index:’name’, width:80,sorttype:’decimal’},
    ………
    ],
    altRows:true,
    altclass :’myAltRowClass’,
    height: “auto”,
    width:200,
    rowNum:20,
    viewrecords:true,
    pager:’#pager’,
    footerrow : true,
    shrinkToFit: false,
    userDataOnFooter : true,
    loadonce:true
    });
    $(“#grid_actual_payroll”).jqGrid(‘setFrozenColumns’);

  18. December 16th, 2011 at 09:39 | #18

    @A1901,
    Please send us a test case, otherwise to say this is not working is not serious.

    @Corneliu
    This is fixed.
    https://github.com/tonytomov/jqGrid/commit/f07f829f619fcb551bac3c28e3b3c0aa2975120d

    @Maika
    http://trirand.com/blog/jqgrid/jqgrid.html
    See Row editing

    @jhonnie
    Thanks. We know about this. This is bug and we will try to resolve it

    Regards
    Tony

  19. jhonnie
    December 16th, 2011 at 11:19 | #19

    Ok, I hope this bug will be fix soon.
    Tnx a lot,

  20. December 17th, 2011 at 02:16 | #20

    Thanks for jqgrid, is so cool.

    Frozen Columns don’t work in grids with local data type.

    I hope too this bug will be fix soon.

    Best regards,
    Omar Yepez

  21. kobruleht
    December 17th, 2011 at 20:54 | #21

    If row is deleted using call to server, exception occurs in delete complete handler in jquery.jqGrid.src.js file near line 8273
    toarr = postdata.split(“,”);

    postdata is already array parsed already near line 8239

    postdata = postdata.split(“,”);

    and thus it does not contain split method. How to fix?

  22. eddy
    December 19th, 2011 at 03:12 | #22

    I have just tried the “Multi Select Example”, and find “Get Selected id’s” does not return the real ids I have selected; and also when I unselect a row, the some other row will unselect too! I can not use jqGrid in my project if this problem is not resolve, How to fix? thank you!

  23. Codyfire
    December 19th, 2011 at 14:12 | #23

    Hi all!! great release for Jqgrid. Gratz!!
    Well i have a question for you all.
    I’m trying inline row editing and add row inline whit data format error handling in grid.
    The grid show a error message when data format isn’t correct but when clicking “close” button in dialog, then “save row” and “cancel row” disables without deselecting the row i’m editing.

    That cause the user must click again in edit button to fix the error.

    How can i overcome this?

    ( Sorry for my english )

    here is the Grid part of my page:

    $(“#jqgrid”).jqGrid({
    url:’/ibi_apps/WFServlet?IBIF_ex=ejemgrid’,
    autowidth:true,
    autoheight:true,
    datatype: “xml”,
    colNames:[”,’Numero factura’,’Nombre Cliente’, ‘Importe’, ‘Fecha’],
    colModel:[
    {name:’ID’,index:’ID’, hidden:true, editable:true}, {name:’NUM_FAC’,index:’NUMERO_FACTURA’, width:60, editable:true,editoptions:{maxlength:8}}, {name:’NOM_CLI’,index:’NOMBRE_CLIENTE’, width:100,editable:true,editoptions:{maxlength:50}},
    {name:’IMPORTE’,index:’IMPORTE’, width:80, align:”right”,editable:true,editoptions:{maxlength:11},editrules:{number:true}},
    {name:’FECHA’,index:’FECHA’, width:80, align:”left”, editable:true, datefmt:’dd/mm/yyyy’,editoptions:{maxlength:10},editrules:{date:true}}
    ],
    pager: ‘#pager’,
    sortname: ‘ID’,
    rownumbers: true,
    viewrecords: true,
    sortorder: “desc”,
    pgbuttons: false,
    pgtext: false,
    pginput:false,
    editurl: “/ibi_apps/WFServlet?IBIF_ex=ejemsave”,
    caption: “Mantenimiento \”en linea\””
    });
    $(“#jqgrid”).jqGrid(‘navGrid’,”#pager”,{edit:false,add:false,del:false,refresh:false,search:false});
    $(“#jqgrid”).jqGrid(‘inlineNav’,”#pager”);

  24. Codyfire
    December 19th, 2011 at 14:15 | #24

    @Codyfire
    Thx for help in advance!

  25. els
    December 19th, 2011 at 19:25 | #25

    This is a really great feature however it has some issues. For instance, if I set cellEdit to true then frozen columns functionality doesn’t work. Also, if I set height to 100% it won’t work either but if I change it to ‘auto’ then it’ll work. Also, can anyone confirm whether frozen columns functionality will work after remap function is called on grid complete event?

  26. els
    December 19th, 2011 at 21:28 | #26

    I was able to get it to work. First remapColumns fucntion is called then I use setColProp to set frozen property for the first n cols finally call the setFrozenColumns function. As for cellEdit, if it is set to true, all bets are off.

  27. Corneliu
    December 19th, 2011 at 22:37 | #27

    @Codyfire I have the same problem with multi-select. Until this is fixed I hide the ‘cb’ column. Selection by click directly on the row seems to work ok and the ids are returned correctly.

  28. Corneliu
    December 19th, 2011 at 22:40 | #28

    @Corneliu
    Sorry! the above comment was for @eddy!

  29. olman rivera
    December 20th, 2011 at 00:10 | #29

    Thanks a lot for all your help and support!! this is a great piece of software, we used in our system since 6 months now and it is pretty stable and usefull, you got my greetings!

  30. wopswops
    December 30th, 2011 at 09:34 | #30

    thanks merry christMas!! happy new year!!!!!

  31. kylelind
    January 2nd, 2012 at 14:21 | #31

    Hi Tony, do you have any plans to develop frozen columns functionality when using cell editing?

  32. January 24th, 2012 at 08:30 | #32

    Hi Tony,
    First of all thanks a lot for jqGrid plugin.
    I am trying to use jqGrid….everything works fine but column resize doesn’t work when I set doctype to HTML5.
    Please guide me through the latest code where column resizing works in HTML5.

  33. enliven
    February 17th, 2012 at 04:10 | #33

    setting pginput:false does not work on subgrid in 4.3

  34. enliven
    February 17th, 2012 at 04:30 | #34

    enliven :
    setting pginput:false does not work on subgrid in 4.3

    It appears that ‘loadonce: true’ has to be set on subgrid or ‘pginput:false’ is ignored

  35. alex
    March 15th, 2012 at 18:58 | #35

    Hi.

    I need the function that export to excel.

    I saw in this article that in this version i can 2 export but i cant 2 export help me. i need to export excel in my pages.

    Tks GOd Bless All

  36. alex
    March 15th, 2012 at 19:00 | #36

    Is true that i can 2 export excel? help me with the code please…

    I try with this code: jQuery(“#grdi”).excelExport();

  37. hugh
    June 12th, 2012 at 18:05 | #37

    when I turn on ‘rownumbers: true’. setFrozenColumns seem to only move the column header, not the data.
    Is there a work around?

  38. TrailTrackers
    September 14th, 2012 at 19:24 | #38

    I’m still using 3.8.1 because of some compatibility issues, but I’ve implemented the sort by multiple columns for my use case. Changes to jqgrid consist of a plugin to configure the sort columns and order. The rest I’ve done on the server (asp.net :: C#) using Linq.
    What I’ve done may be a good start for you guys. Are you interested in it? I’ll send it to you if you are.

    I also came here looking for a solution to the very limited footer you guys have implemented. Too bad for me that you haven’t fixed that yet. This means that I will begin writing a configurable footer plugin today. I’ll keep you updated on that as well if you are interested.

    Thanks for a great product!

  39. November 2nd, 2012 at 05:17 | #39

    When double click the frozen column,can’t find the ondblclickrow’s value of the error occurred. And right-click on the row the same error occurred.

  1. No trackbacks yet.

Privacy Policy   Terms and Conditions   Contact Information