cell value over 10 billion can't be exported with a number format using UltraGridExcelExporter

Byonghoon posted over 14 years ago

Hi. I'm still poor at English. sorry first.

My 1st question in this forum has not resolved yet.

(I think it's platform bug, but SDK I'm using was so old and I decided to make a new grid and it works well.)

Now I'm interested in exporting to excel.

Suddenly, I found that cell value over 10 billion can't be exported with a number format using UltraGridExcelExporter.

- I put some hard coded values (111111111-a, 1111111111-b, 11111111111-c)

- a, b exported properly with a number format

- c exported improperly.

(in debugger, value type was Int64 but exported not a number format but a string format)

(string format assigned with column unit so in the cell of the column of the row, still remained custom number format)

Is there any problem with interface between ultragrid and excel? (data width, ...)

Thanks in advance

Parents

No Data

Reply

469350

Offline Mike Saltzman posted over 14 years ago

Hi,

It's not clear to me what format you are referring to.

Are you setting the Format on the Excel cell?

Are you exporting a WinGrid, or writing to an Excel Workbook object directly?
Cancel
Reply

Cancel

Children

80

Byonghoon posted over 14 years ago in reply to Mike Saltzman

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);

}

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

private void uee_InitializeColumn(object sender, InitializeColumnEventArgs e)

{

e.ExcelFormatStr = e.FrameworkFormatStr;

}

private void uee_BeginExport(object sender, BeginExportEventArgs e)

{

e.CurrentWorksheet.Columns[3].CellFormat.Alignment = Infragistics.Excel.HorizontalCellAlignment.Right;

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

e.CurrentWorksheet.Rows[e.CurrentRowIndex++].Cells[0].Value = "wire transfer";

e.CurrentWorksheet.Rows[e.CurrentRowIndex++].Cells[0].Value = "sender : KARI";

e.CurrentRowIndex++;

}

private void uee_EndExport(object sender, EndExportEventArgs e)

{

const int width_unit = 256;

int i;

long total;

e.CurrentWorksheet.Columns[0].Width = 20 * width_unit;

e.CurrentWorksheet.Columns[1].Width = 25 * width_unit;

e.CurrentWorksheet.Columns[2].Width = 20 * width_unit;

e.CurrentWorksheet.Columns[3].Width = 20 * width_unit;

e.CurrentWorksheet.Columns[4].Width = 15 * width_unit;

for (i = 4, total = 0; i < e.CurrentRowIndex; i++)

total += Convert.ToInt64(e.CurrentWorksheet.Rows[i].Cells[3].Value);

e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[0].Value = "total";

e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[0].CellFormat.Alignment = Infragistics.Excel.HorizontalCellAlignment.Center;

e.CurrentWorksheet.Rows[e.CurrentRowIndex++].Cells[3].Value = total;

e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[0].Value = "test1";

e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[0].CellFormat.Alignment = Infragistics.Excel.HorizontalCellAlignment.Center;

e.CurrentWorksheet.Rows[e.CurrentRowIndex++].Cells[3].Value = 1111111111;// It works.

e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[0].Value = "test2";

e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[0].CellFormat.Alignment = Infragistics.Excel.HorizontalCellAlignment.Center;

e.CurrentWorksheet.Rows[e.CurrentRowIndex++].Cells[3].Value = 11111111111;// It works.

e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[0].Value = "test3";

e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[0].CellFormat.Alignment = Infragistics.Excel.HorizontalCellAlignment.Center;

e.CurrentWorksheet.Rows[e.CurrentRowIndex++].Cells[3].Value = 111111111111;// It doesn't work.

}
Cancel
Reply

Cancel