jQuery Grid Plugin – jqGrid

Thanks and Merry Christmas!

The Downloads page still reads “4.2.0.”

Jack,
Thanks. Fixed.

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

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.

@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

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

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?

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

Great work as always,
Thanks Jqgrid team.

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

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.

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

@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.

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

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

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’);

@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

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

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

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?

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!

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”);

@Codyfire
Thx for help in advance!

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?

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.

@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.

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

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!

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

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

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.

setting pginput:false does not work on subgrid in 4.3

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

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

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

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

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

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!

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.