How to display newly added/Inserted blank row when filtering is applied on a particular column(s). Thanks

We require Excel like auto filtering. (Including distinct value check boxes and filtering using logical operators like OR, AND, NOT, CONTAINS, IN, STARTSWITH, ISEQUALTO, ISNOTEQUALTO). Currently xceed datagrid doesn't support filtering based on logical operations. Is anybody have solution for this limitation?