Bug on FilterType Excel when language is not english

[Renee Sales]

Good Afternoon.

I'm facing a bug where I have a Grid with FilterType as Excel and app locale is set to '@syncfusion/ej2-locale/src/pt-BR.json'.

When started typing on the filter box, it works fine, but if I keep typing, it starts to duplicate the 'AddCurrentSelection' text every time I pause typing:

This happens on any other language I try on locale, but if I put '@syncfusion/ej2-locale/src/en-US.json', it works fine:

FilterSetting is:

{

  "type": "Excel",

  "ignoreAccent": false,

  "enableInfiniteScrolling": true

}



I'm using the following settings on my app:

import { L10n, setCulture } from '@syncfusion/ej2-base';

import * as locale from '../../node_modules/@syncfusion/ej2-locale/src/pt-BR.json';

L10n.load(locale);

setCulture("pt-BR");

Thank you for the attention.

[Aishwarya Rameshbabu]

Hi Renee Sales,

 

Greetings from Syncfusion support.

 

We have conformed the reported scenario as a bug from our end and logged it as “Issue with Excel Filter when localization is enabled in Grid”. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technical feasibility and Product Development Life Cycle ) and will include the defect fix in our upcoming patch release which will be rolled out on “October 22nd, 2024”.

 

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through the below link,

 

Feedback: https://www.syncfusion.com/feedback/61790/issue-with-excel-filter-when-localization-is-enabled-in-grid

 

Disclaimer: "Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization".

 

 

Regards

Aishwarya R 

[Aishwarya Rameshbabu]

Hi Renee Sales,

 

We are glad to announce that, we have included the fix for the issue “Issue with Excel Filter when localization is enabled in Grid” in our 27.1.55 release. So please upgrade to our latest version of the Syncfusion package to resolve the reported issue.

 

Root Cause: This occurs when infinite scrolling is enabled in the Excel filter. The problem arises because the search box's child values do not match the localized values, causing the default value of "Add current selection to filter" option to appear instead of the localized value.

 

Solution: This issue has been resolved by setting the localized value for the "Add current selection to filter" option through the getLocalizedLabel method.

 

Release Notes: https://ej2.syncfusion.com/angular/documentation/release-notes/27.1.55?type=all#grid

 

Sample: Please find in the attachment.

 

Screenshot:

 

 

   

Feedback: https://www.syncfusion.com/feedback/61790/issue-with-excel-filter-when-localization-is-enabled-in-grid

 

We thank you for your support and appreciate your patience in waiting for this release. Please get back to us if you need any further assistance.

 

 

Regards,

Aishwarya R

Attachment: 194581UpdatedSample_74ce0121.zip