Datagrid automatically trimming the cells

[Alex D.]

Hi. Does any body knows why databinding a datagrid with "Create columns
automatically at run time" option selected it shows my cells trimmed?? For
example if cell [0,0] was "0001" it shows only "1" ?

Thanks!
aLeX.

 

[Guest]

I suspect that it will be somthing to do with your data types, if it is a
number data type then it will likely get trimmed because it doesn't matter
how many 0s you precede a number with it is still 1. If it was a text field
then it should output what is in the field.

 

[Alex D.]

the solution is to add this to the cell's style: mso-number-format:\\@
this way it will be a text instead of a number what will be passed to Excel.

I suspect that it will be somthing to do with your data types, if it is a
number data type then it will likely get trimmed because it doesn't matter
how many 0s you precede a number with it is still 1. If it was a text
field
then it should output what is in the field.

Hi. Does any body knows why databinding a datagrid with "Create columns
automatically at run time" option selected it shows my cells trimmed??
For
example if cell [0,0] was "0001" it shows only "1" ?

Thanks!
aLeX.