We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to set format for the whole column

Thread ID:





80850 Apr 29,2009 10:47 AM Apr 30,2009 05:56 AM Windows Forms 1
Tags: XlsIO
Yezdi Parvez
Asked On April 29, 2009 10:47 AM

Hi SyncFusion,

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


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 [Syncfusion]
Replied On April 30, 2009 05:56 AM

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:


Please let me know if you have any questions.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.