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.

[clickon]

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." wrote:

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.

[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.

"clickon" <cl*****@discussions.microsoft.comwrote in message
news:AF**********************************@microsof t.com...

>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." wrote:

>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.