Flexsheet-HeaderFilter CSS positioning issue

Posted by: sasmita.swain2014 on 14 December 2017, 5:39 pm EST

    • Post Options:
    • Link

    Posted 14 December 2017, 5:39 pm EST

    Hi,

    I have applied header filter using the attached code. I have a flexsheet with more than 20 columns, with a horizontal scrollbar.

    If i scroll forward the filter editor also moving forward to some extra pixels and the filter box is not coming below the column from where i have opened.

    Please give an update ASAP if its possible to fix or not.

    FlexSheet_headerFilter_toggle (2).zip

    Thanks,

    Sasmita

  • Posted 17 December 2017, 5:18 pm EST

    Hi,

    Any update on this. Please let me know if this issue can be fixed or not?

    Thanks,

    Sasmita

  • Posted 17 December 2017, 10:50 pm EST

    Hi Sasmita,

    This issue can be fixed by hiding columnHeaders row by setting visible property to false instead of headersVisiblilty to Row.

    Please use the following code snippet for the same:

    var flex = new wijmo.grid.sheet.FlexSheet('#theSheet', {
                    //headersVisibility:'Row'
                });
                flex.addBoundSheet('Sheet1', getData(0, 10));
                flex.columnHeaders.rows[0].visible=false;
    

    The code snippet is verified with 5.20173.380 build.

    ~Manish

  • Posted 20 December 2017, 2:54 am EST

    Thanks for the update. This header Filter is working fine with Chrome but not working in IE In my code. I have taken the latest wijmo build and i am using in angular 2 code.

    can you please look on it and let me know what might have went wrong with the code?

  • Posted 20 December 2017, 10:11 pm EST

    Hi Sasmita,

    The sample is working fine at our end in both IE and Chrome.

    ItemFormatter is used to add filter for first row since ColumnHeaders shows Alphabets instead of header same as FlexGrid. Here is the fiddle that shows how standard headers can be used same as FlexGrid for FlexSheet. Please refer to the filter:

    http://jsfiddle.net/Mike_Lu/h4nozk7e/

    ~Manish

  • Posted 21 December 2017, 6:38 pm EST

    Hi Maneesh,

    As per our requirement we don’t need “Filter By Condition” In filter box. How to remove that option?

    Thanks,

    Sasmita

  • Posted 25 December 2017, 4:55 pm EST

    Hi Sasmita,

    You need to set defaultFilterType to 2(ValueFilter) for FlexSheet filter. Please use the following code snippet

    flexSheet._filter.defaultFilterType=2;
    

    and refer to the updated code snippet for the same:

    http://jsfiddle.net/mkgupta911/h4nozk7e/20/

    ~Manish

  • Posted 25 December 2017, 9:13 pm EST

    Thanks for the update.

    I have attached one example. In the Country filter where filter by condition has a drop down containing all the country names instead of having that particular column data.

    Ex: Country column: filter by condition not supposed to have Italy. greece because that column doesn’t have those 2 names.

    can it possible to have only the Column containing names.

    FlexSheet_headerFilter_toggle (3).zip

    Thanks,

    Sasmita

  • Posted 26 December 2017, 8:32 pm EST

    Hi Sasmita,

    You need to get hostElement for ComboBox and get the control reference. By getting Control reference, you need to udpate itemsSource to the array list containing the items present in Column.

    The getting items from Column cells may be costly.

    Please find the attached sample for the same.

    ~Manish

    FlexSheet_conditionFilter_combobox_toggle.zip

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels