Decimal column leading zeros

[Danilo]

Hi there

 I'm trying to add rows to a GridViewDecimalColumn with leading zeros. I know there's a property "FormatString" but this is not exactly what I want. I want the numbers always have the same amount of zeros leading. Here you can see my code:

GridViewDecimalColumn col = new GridViewDecimalColumn();
col.FormatString = "{0:0000}";
radGridView1.Columns.Add(col);

This will output the following:

Number 1 will be 0001
Number 2 will be 0002
Number 10 will be 0010
Number 100 will be 0100

But what I'm trying to achieve is:

Number 1 should be 0001
Number 10 should be 00010
Number 100 should be 000100
etc.

Is this possible? Hope you can help me.

Regards,

Danilo

[erwin]

Hi Danilo, I guess for this rather unusual formatting, your best option is to define an event handler to for the CellFormatting event.

 Regards

Erwin

[Danilo]

Hi Erwin

The problem is, it's a DecimalColumn so it's deleting all 0 before the first "real" number.

Any other ideas? :)

Regards,
Danilo

[Ralitsa]

Hi Danilo,

Thank you for contacting us. 

You can use the escape character to prevent the formatting operation. Here is the code snippet how to set the FormatString of GridViewDecimalColumn:

decimalColumn2.FormatString = "{0:\\0\\0\\0#}";

In the attachments you can find an image which demonstrates the result.  

You can refer to the following article from MSDN for more information about  Custom Numeric Format Strings, section "The Escape Character".
 
I hope this will help you. Let me know if you have any other questions.

Regards,
Ralitsa
Telerik