search box in excel filter

[ttArbor]

is there some way I can change search operator in excel filter search box to 'contains' instead of 'startswith'?

Thank you, 

T

[Pavithra Subramaniyam]

Hi thao, 

 

Thanks for contacting Syncfusion support. 

 

You can change the Excel searchbox operator from ‘startswith’ to ‘contains’  by using the ‘actionBegin’ event of Grid component. Please refer to the below code example, documentation link and sample link for more information. 

 

[component.ts] 

@Component({ 

    selector: 'app-root', 

    template: '<ejs-grid #grid [dataSource]='data' (actionBegin)="actionBegin($event)" allowPaging='true' allowFiltering='true' [pageSettings]='pageSettings' [filterSettings]='filterSettings'> 

        <e-columns> 

            .  .  . 

        </e-columns> 

    </ejs-grid>', 

}) 

 

export class AppComponent { 

    .  .  . 

    ngOnInit(): void { 

        this.data = orderDataSource; 

        this.filterSettings = { type: 'Excel' }; 

    } 

    public actionBegin(e: any): void { 

       if(e.requestType == 'filtersearchbegin'){ 

              e.operator="contains"; 

        } 

    } 

} 

 

Documentation: https://ej2.syncfusion.com/angular/documentation/api/grid/#actionbegin 

 

Sample               : https://stackblitz.com/edit/angular-kjhjnn-8ngpzn?file=app.component.html 

 

Please get back to us if you need any further assistance on this. 

 

Regards, 

Pavithra S. 

[ttArbor]

works great!

Thanks

[Pavithra Subramaniyam]

Hi thao,  

Thanks for your update. 

We are happy to hear that the provided solution works. 

Please contact us if you need any further assistance. As always, we will be happy to assist you.  

Regards,  

Pavithra S.