ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: queensgambit9 on October 14, 2025, 04:19:39 pm

Title: Replace char in filter
Post by: queensgambit9 on October 14, 2025, 04:19:39 pm

Users sometimes use dot ('.') as decimal while comma (',') is the correct one for a specific column (float).
What would be a good way to address this issue? Replace or validation etc?

Title: Re: Replace char in filter
Post by: paramvir on October 14, 2025, 10:16:20 pm

You mean in the filter header row? Characters entered in the input box aren’t directly replaced, but the user’s input is automatically parsed into numbers according to the column’s format and localeFmt settings.

For example:

"." is used as the decimal separator in en-US

"," is used as the decimal separator in de-DE

So, as long as the localeFmt and format are correctly configured, numeric input with the appropriate decimal symbol will be parsed correctly.

If your users belong to different locales, you can leave localeFmt empty — the decimal symbol will then automatically adapt to each user’s system locale.