RadNumericTextBox Hide Trailing Zeros

[Chen Jun Ying]

Hi all,

I have  RadNumericTextBox with 10 DecimalDigits. I would like to hide any trailing zeros. If value is 0.1456000000, I want to display 0.1456.

Any ideas?
 

[Princy]

Hello,

Try setting AllowRounding as false.

<telerik:RadNumericTextBox runat="server" ID="RadNumericTextBox">
   <NumberFormat AllowRounding="false" DecimalDigits="10" />
</telerik:RadNumericTextBox>

Thanks,
Princy.

[Chen Jun Ying]

Thanks Princy.

It works on numerictextbox.

When I try the same on GridNumericColumn, it doesn't work.  Any ideas?

[Vasil]

Hello,

This behavior is by design in the implementation of RadInput.
The feature request is logged in our private tracking system and we will try to implement it when done with the tasks that has higher priority.

Kind regards,
Vasil
the Telerik team

[Chen Jun Ying]

Thanks Vasil.

I do not mean RadIput here.What I am after is to use GridNumericColumn to bind the data. I still shows all the trailing zeros even if I set AllowRounding="false" for the GridNumericColumn.

Chen.

[Shinu]

Hello,
 
Try setting the DataFormatString.
aspx:

<telerik:GridNumericColumn DataField="Freight" HeaderText="Freight ID" DataFormatString="{0:f5}"   UniqueName="Freight" />

-Shinu.

[Chen Jun Ying]

Hi Shinu,

It doesn't work. Since I don't know the number of decimal points, I can't set in the dataformatstring. Any ideas?

 

[Vasil]

Hello,

Try to use the the {0:G} or {0:R} formats.

Greetings,
Vasil
the Telerik team

[Chen Jun Ying]

Both DataFormatString are not working. Just wondering if it can be done using GridNumericColumn. I might consider using templatecolumn and format the number.

[Vasil]

Hi Chen,

Yes if you like to perform any custom formatting you could always use a TemplateColumn that will give you more freedom and customization.

Greetings,
Vasil
the Telerik team

[Chen Jun Ying]

Thanks Vasil.

i go for TemplateColumn option. 

[Hitesh]

Hi,
I am using Telerik version 2012.2.912.40 and RadMaskedNumericInput.

It don't have NumberFormat AllowRounding="false" property.

Please advise how trailing zeros can be hidden on form as well in Grid?

Form
------------

 

 

 

 

<telerik:RadMaskedNumericInput Value="{Binding XXX, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged, ValidatesOnDataErrors=True}" Mask="" FormatString="N4" TextMode="PlainText" IsClearButtonVisible="False" SelectionOnFocus="DefaultSelectAll" >

 

 

 

 

</CoreTelerikCtrl:RadMaskedNumericInput>

 

 

 

 

Grid
---------
<telerik:GridViewDataColumn.CellEditTemplate>

 

 

 

 

<DataTemplate>

 

 

 

 

<telerikInputCtrl:RadMaskedNumericInput Value="{Binding Path=XXX, Converter={StaticResource millionToNumberConverter}, UpdateSourceTrigger=PropertyChanged}"

 

 

 

 

telerikInputext:MaskedInputExtensions.Minimum="0"

 

 

 

Mask="" FormatString="N2" IsClearButtonVisible="False" />

 

 

 

 

</DataTemplate>

 

 

 

 

</telerik:GridViewDataColumn.CellEditTemplate>

 

[Vasil]

Hello Hitesh,

The RadControls for ASP.Net Ajax does not contain control called "RadMaskedNumericInput". If you use the Silverlight suite, try to ask your question into their forums to get competent response from the Silverlight community.

Greetings,
Vasil
the Telerik team

[Jippy]

Hi,
   I have decimal values in telerik grid view data column, i formatted it and showing properly but when i try to edit the value and double click on it, it displays a bunch of zeros after the decimal point.Now i want to remove all those zeros when i double click for editing.Can anybody please help me out on this as soon as possible?

[Vasil]

Hello Jippy,

Make sure KeepTrailingZerosOnFocus for your RadNumericTextBox is set to false (the default value).

Greetings,
Vasil
the Telerik team