jQWidgets Forums
jQuery UI Widgets › Forums › Grid › filtermode: 'excel' not working
Tagged: filtermode: 'excel'
This topic contains 1 reply, has 2 voices, and was last updated by Peter Stoev 11 years, 1 month ago.
-
Author
-
I ,
I have a grid with regular text & number input filters on them.
I would like to add the “excel” mode filtering as well (to appear in the sorting context menu as a checked list).Can it work together? for some reason the sorting context menu does not contain the filtering ‘excel’ options..
(I would like to to work on only the Name column – which has a textbox filter already.
Thanks.my grid –
$(“#jqxgrid”).jqxGrid(
{
height:’530′,
width: ‘99.5%’,
source: dataAdapter,
showfilterrow: true,
filterable: true,
filtermode: ‘excel’,
autoshowfiltericon: true,
theme: ‘darkblue’,
selectionmode: ‘singlerow’,
editable: true,
showstatusbar: true,
statusbarheight: 25,
enabletooltips: true,
columnsresize: true,
showaggregates: true,
localization: getLocalization(),
sortable: true,
editmode: ‘click’,
columns: [
{ editable: false,text:’‘,filterable: false,sortable:false,pinned: true,columntype: ‘textbox’, datafield: ‘allMachinesPaused’, width:’2%’,cellsalign: ‘center’, align:’center’,cellsrenderer: warningimagerenderer,cellclassname: cellclass},
{ text: ‘Status’,pinned: false,align:’left’ ,cellsalign: ‘left’,datafield: ‘status’, width: ‘5%’, columntype: ‘dropdownlist’,filtertype: ‘checkedlist’,cellclassname: cellclass,cellsrenderer:statusrenderer,
createeditor: function (row, column, editor) {
editor.jqxDropDownList({source: statusSource, promptText: ‘Select value’, autoOpen: true});
}},
{editable: false, text: ‘Name’,pinned: false,align:’left’ , columntype: ‘textbox’, filtertype: ‘textbox’,cellsalign: ‘left’, filtercondition: ‘contains’, datafield: ‘name’,width: ‘7%’,aggregates: [‘count’],cellsrenderer: linkrenderer,cellclassname: cellclass,aggregatesrenderer: function (aggregates, column, element, summaryData) {
var renderstring = “<div style=’font-size:11px;float: left; width: 100%; height: 100%;’>”;
$.each(aggregates, function (key, value) {
renderstring += ‘<div style=”font-size:11px;position: relative; margin: 6px; text-align: left; overflow: hidden;”><B>’ + value + ‘</B></div>’;
});
renderstring += “</div>”;
return renderstring;
}
},hi assaf.frank123,
That’s actually relatively new functionality. You can see it working as expected online: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/excelfiltering.htm?arctic
Best Regards,
Peter StoevjQWidgets Team
http://www.jqwidgets.com/ -
AuthorPosts
You must be logged in to reply to this topic.