Hi,

I'm still quite confused about what you are trying to do and what the problem is.

You have code in the InitializeColumn event to set e.ExcelFormatStr = e.FrameworkFormatStr. This is usualyl okay, but DotNet format strings and Excel format strings are not always the same, which is why we don't do this for you automatically. I think "#,###" is a valid Excel format string, but you might want to check Excel's documentation or maybe even just try this in Excel to make sure it works.

Since you are already setting this in InitializeColumn, there's no reason to set the format on an individual cell inside the BeginExport event:

e.CurrentWorksheet.Columns[3].CellFormat.FormatString = "#,###";

Why are you doing that? Is this format supposed to be different than the others? How do you know the cell you want will be at columns[3] in the worksheet? This seems like a dangerous assumption. It also seems unnecessary and since BeginExport fires before InitializeColumn, it's probably just getting overwritten, anyway.

What exactly isn't working? What are you expecting the values to look like and what do they actually look like? Have you tried applying the same format to the same values in Excel to see if they work there?

The format I'm referring to is a number format separated by comma (ex. #,###)

    Is there another way to meet a standard excel number format separated by comma?

    (The ways using "#" are always identified with custom format in excel)

Here are some parts of my source.

In this source, I set the format by column. But when I set the format by cell, results are always same.

..................

using (UltraGridExcelExporter uee = new UltraGridExcelExporter())

{

uee.InitializeColumn += new InitializeColumnEventHandler(uee_InitializeColumn);

uee.BeginExport +=new BeginExportEventHandler(uee_BeginExport);

uee.EndExport += new EndExportEventHandler(uee_EndExport);

uee.Export(ugdListToBank, sfd.FileName);

}