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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to set format for the whole column

Thread ID:





80850 Apr 29,2009 02:47 PM UTC Apr 30,2009 09:56 AM UTC WinForms 1
Tags: XlsIO
Yezdi Parvez
Asked On April 29, 2009 02:47 PM UTC

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 09:56 AM UTC

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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon