Disable auto round for decimal

[Flavio]

Hi,

  I updated my applications to new version, Telerik 2012 Q1 but before I was using Telerik 2012. When I was testing the application I saw a grid doesn't display the value of the previous version of Telerik. When I set a value 12.379 the value is rounded to 12.38 and in the previous version I set a value 12.379 and it keeps the value.
 I'd like know how to do disable the round option when I set values like 12.379?

Example attached.

Thanks!

[Stefan]

Hello Flavio,

Thank you for writing.

GridViewDecimalColumn has a property called DecimalPlaces which determines how many decimals should be displayed when the cell is edited. Additionally, there is a FormatString property of the column, which is used to format the cells when they are not in edit mode:

((GridViewDecimalColumn)radGridView1.Columns["MyColumnName"]).DecimalPlaces = 5;
((GridViewDecimalColumn)radGridView1.Columns["MyColumnName"]).FormatString = "{0:#,0.0000}";

I hope this helps.

Regards,
Stefan
the Telerik team

[Alejandro]

it does not work ... any idea?? is still auto rounding

[Stefan]

Hi Alejandro,

Thank you for writing.

You need to set the DecimalPlaces and the FormatString of the column with the number of decimal places desired. For example in my previous post I am allowing up to 5 decimal places, so any extra one will be rounded.

I hope this helps.
 
Kind regards,
Stefan
the Telerik team

[Aaron]

The solution you are proposing is not flawless, because if you put a number like 28.9999999999999 will get round to 29, so it is not good if your data needs to be accurate and without rounding.

[Stefan]

Hi Aaron,

Depending on your requirements, you can set the corresponding DecimalPlaces and FormatString. If you do not want rounding just set it the desired DecimalPlaces and FormatString:

((GridViewDecimalColumn)radGridView1.Columns["DecimalColumn"]).DecimalPlaces = 5;
((GridViewDecimalColumn)radGridView1.Columns["DecimalColumn"]).FormatString = "{0:N5}";

Make sure you column DataType supports decimals as well i.e. decimal, double.

Regards,
Stefan
Telerik

[Saif]

I'm having the same problem, even if i apply the decimalplaces and formatstring the value that i entered is still rounding

[Stefan]

Hello Saif,

Can you please provide an example - what value are you entering, and also what column type you use and the settings in the DecimalPlaces and the FormatString properties?

Regards,
Stefan
Telerik

[Mary]

Could it be that the data type of your underlying DataSource column is Int rather than Decimal? The reason that my decimal columns were rounding up (in spite of setting the DecimalPlaces and FormatString properties) was because the columns in my DataTable were Int32.

[Dess | Tech Support Engineer, Principal]

Hello, Mary,         

For numeric fields RadGridView offers GridViewDecimalColumn. You can specify the DataType, DecimalPlaces and FormatString properties of the GridViewDecimalColumn. Thus, the value will be integer and it is not expected to be rounded. If you are still experiencing any undesired behavior it would be greatly appreciated if you can provide a sample code snippet with which I can replicate the problem on my end and make an adequate analysis of the precise case.

I hope this information helps. If you have any additional questions, please let me know.  

 

Regards,
Dess
Progress Telerik

[F3M]

I will use this post because, I'm having the same problem, even if i apply the decimalplaces and formatstring the value that i entered is still rounding

[Dess | Tech Support Engineer, Principal]

Hello, 

Note that even though you may format a GridViewDecimalColumn to display 2 decimal places, the user is allowed to enter more digits. Hence, the value will be rounded up to 2 decimal places. If your requirement is to restrict the user to a specific number of decimal places, you may consider using a GridViewMaskBoxColumn with a numeric mask. I have prepared a sample code snippet for better illustration how to setup two GridViewMaskBoxColumns with integer and decimal values:

        public RadForm1()
        {
            InitializeComponent();

            List<Item> items = new List<Item>();
            for (int i = 0; i < 10; i++)
            {
                items.Add(new Item(i,"Item" + i, i * 1.33m));
            }
            this.radGridView1.DataSource = items;
            this.radGridView1.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;
            
            GridViewDecimalColumn idColumn = this.radGridView1.Columns["Id"] as GridViewDecimalColumn;
            idColumn.DataType = typeof(int);
            idColumn.DecimalPlaces = 0;
            idColumn.FormatString = "{0:N0}";

            GridViewDecimalColumn priceColumn = this.radGridView1.Columns["Price"] as GridViewDecimalColumn;
            priceColumn.DataType = typeof(decimal);
            priceColumn.DecimalPlaces = 2;
            priceColumn.FormatString = "{0:N2}";

            GridViewMaskBoxColumn maskBoxColumn = new GridViewMaskBoxColumn("Masked_Id"); 
            maskBoxColumn.FieldName = "Id"; 
            maskBoxColumn.MaskType = MaskType.Numeric;
            maskBoxColumn.Mask = "N0"; 
            maskBoxColumn.FormatString = "{0:N0}";
            maskBoxColumn.DataType = typeof(int);
            radGridView1.MasterTemplate.Columns.Add(maskBoxColumn);

            maskBoxColumn = new GridViewMaskBoxColumn("Masked_Price");
            maskBoxColumn.FieldName = "Price";
            maskBoxColumn.MaskType = MaskType.Numeric;
            maskBoxColumn.Mask = "N2";
            maskBoxColumn.FormatString = "{0:N2}";
            maskBoxColumn.DataType = typeof(decimal);
            radGridView1.MasterTemplate.Columns.Add(maskBoxColumn);

            this.radGridView1.CellEditorInitialized += radGridView1_CellEditorInitialized;
        }

        private void radGridView1_CellEditorInitialized(object sender, GridViewCellEventArgs e)
        {
            GridSpinEditor spinEditor = e.ActiveEditor as GridSpinEditor;
            if (spinEditor != null)
            {
                RadSpinEditorElement el = spinEditor.EditorElement as RadSpinEditorElement;
                if (this.radGridView1.CurrentColumn.Name == "Id")
                {
                    el.DecimalPlaces = 0;
                }
                else
                {
                    el.DecimalPlaces = 2;
                }
            }
        }

        public class Item
        {
            public int Id { get; set; }

            public string Name { get; set; }

            public decimal Price { get; set; }

            public Item(int id, string name, decimal price)
            {
                this.Id = id;
                this.Name = name;
                this.Price = price;
            }
        }

Please give the sample project a try and see how it works for your case. 

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik