RadNumericTextBox controls contains DecimalSeparator and GroupSeparator properties in NumberFormateSettings collection. But these properties are not available in RadGrid's GridNumericColumn. Unfortunately GridNumericColumn's DataFormatString property also not working correctly. How can I achieve these properties behaviour in GridNumericColumn? (Even I'm ready to develop CustomRadGrid control also.)
7 Answers, 1 is accepted
please check below code snippet for set such type of property.
Let me know if any concern.
Thanks for your reply. Actually my grid is not in edit mode (its in display mode only). And also I'm not using RadNumericTextBox inside the grid. I'm only using GridBoundColumn and GridNumericColumn columns.
RadGrid1 is like this
On the above Numeric Column I want to apply DecimalSeperator and GroupSeperator functionalities.
If I able to achieve above functionality then I will expose these two properties in my Custom Grid and that functionality I will incorporate in customRadGrid itself (we require same functionality in many places thats why making CustomRadGrid.) And all my control users just set these two properties as per their need like below
Any way this CustomGrid is secondary, first of all I'm unable to achieve Decimalseparator and GroupSeparator functionality on GridNumericColumn (in display mode only not in edit mode). Any suggestions are appreciated.
I have the same problem as described above. I want radGrid column to display the numeric values with a specific decimal and group separator in display mode.
Did you find any solutions to the above problem?
Thanking you in advance.
Please try the following approach:
For additional customization, please refer to the following topic:
I hope this will prove helpful. Please give it a try and let me know about the result.
All the best,
the Telerik team
The above dataformatString
displays the value 123456789.5678 as 123,456,789.568 in english culture.
But I want my column to display my specific decimal and group separator.
For example, I have set “*” as decimal separator and “@” as group separator, my grid column should display 123@456@789*568
I read that GridNumericColumn has RadNumericTextBox in edit mode. I can set RadNumericTextBox’s decimal and group separator to edit my value.
Do you have any solutions to display and edit my decimal value in grid according to my decimal separator “*” and group separator “@”?
Thanks for the reply.
In this case you will need to access the auto-generated RadNumericTextBox in edit mode and modify the cell text in regular view. Please try the following approach:
That should do the trick. Please try it out and let me know if it helps you.
The Telerik Team
Your solution worked well.
Thanks for the reply.