How to set format for the whole column

[Yezdi Parvez]

Hi SyncFusion,

In my data grid I have the first column of type long. It displays as the following in the sheet.

2.009E+15

I tried doing the following but did not work.

ws.Columns[1].EntireColumn.CellStyle.IncludeNumberFormat = true;
ws.Columns[1].EntireColumn.CellStyle.NumberFormat = "0";

how can I get it to work.

[Geetha M]

Hi Yezdi,

I am afraid that I am not able to reproduce the problem. You can check my test sample and output file in the link below:

http://files.syncfusion.com/samples/XlsIO.Windows/F80850/main.htm

Please let me know if you have any questions.

Regards,
Geetha