numeric filter problems using differents localizations

Javier posted over 12 years ago

Hello Team,

I’m trying to implement WebDataGrid 11.1 using the Filtering behaviour.

Problem is when I use decimal or datetime data fields, as I’m using the Spanish number format applied to the column (using the Microsoft specification for this kind of data {0:C}, {0:N2}, {0:N2}, …), the filter doesn’t work correctly.

It’s possible for me to type the right format in the filter bar, like 1234,56. But after applying the filter (pressing ENTER), the WebDataGrid transform the filter (1,234.56) and I get an error: ‘Async request failed’.

I’ve tried to specify the culture/ui-culture at the @Page but it doesn’t work.

Thanks for your help.

Parents

37874

[Infragistics] Nikolay posted over 12 years ago

Hi jcuesta,

Thank you for posting in the community.

I have tested the scenario you have described, but I was not able to reproduce the issue. It seems that the WebDataGrid filter will format the value you enter to match the DataFormatString of the corresponding column. Also, the DataFormatString depends on culture, so if you change the culture the grid would change the formatting accordingly. I am attaching a sample, replicating this scenario. Please take a look and if you still need assistance, provide me with a small isolated sample, demonstrating the issue.

If you have any further questions, please feel free to ask.

WDGFiltering.zip
Cancel
Reply

Cancel
37874

[Infragistics] Nikolay posted over 12 years ago in reply to [Infragistics] Nikolay

Hello jcuesta,

If you need any further assistance on the matter please do not hesitate to ask.
Cancel
Reply

Cancel
65

Javier posted over 12 years ago in reply to [Infragistics] Nikolay

Hello Nikolay
Thanks for your answer and your example.
I've testing your example and it works for the date field format. But in your example the numeric column is an Integer type, not decimal. If I change the numeric column format from integer to decimal and I try to filter (using the spanish culture) I get the error I've mentioned before ('Async request failed’).
Please have a look at your example modified to reproduce the error.

Best regards. Javier.

WDGFilteringError.zip
Cancel
Reply

Cancel
37874

[Infragistics] Nikolay posted over 12 years ago in reply to Javier

Hi Javier,

I tested the sample you have attached, but I was not able to reproduce the issue. Are you using Spanish language and regional settings or some custom numbering format? Is it possible for you to test this on another machine and see if the issue occurs?

Thanks.
Cancel
Reply

Cancel
65

Javier posted over 12 years ago in reply to [Infragistics] Nikolay

Hi Nikolay,
Yes I’m using Spanish language, does WebGrid only works with English language?
Anyway, I’ve tested our sample changing the regional settings and I get the same error (attached). In the sample I’ve selected the ‘Equals’ filter and I typed the 99904,01 value (remember we’re using Culture="es-ES"), after press enter the filter value changes automatically to 99,904.01 and I get the error.
Regards. Javier
Cancel
Reply

Cancel

Reply

37874

[Infragistics] Nikolay posted over 12 years ago in reply to Javier

Hi jcuesta,

I have investigated your issue, and I have asked our engineering staff to examine this further. To ensure that it will receive attention, I have logged this behavior in our internal tracking system with a Development ID of 105915. The next step will be for a developer to review my investigation and confirm my findings or to offer a fix, or other resolution.

I will leave this case open and update you with any new information after the review. You can also continue to send updates to this case at any time.

You can view the status of the development issue connected to this case by selecting the "Development Issues" tab when viewing this case on the web site.

Please let me know if you need more information.
Cancel
Reply

Cancel

Children

No Data