jQWidgets Forums

jQuery UI Widgets Forums Grid filtermode: 'excel' not working

This topic contains 1 reply, has 2 voices, and was last updated by  Peter Stoev 11 years, 1 month ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • filtermode: 'excel' not working #52186

    assaf.frank123
    Participant

    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;
    }
    },

    filtermode: 'excel' not working #52195

    Peter Stoev
    Keymaster

    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 Stoev

    jQWidgets Team
    http://www.jqwidgets.com/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.