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.

Grid/Excel export error

Thread ID:

Created:

Updated:

Platform:

Replies:

83096 Jun 23,2009 04:23 PM Jun 26,2009 02:05 PM Windows Forms 4
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On June 23, 2009 04:23 PM

This post might be better placed in the XlsIO forum, but anyways...Any idea why some (but not all) users of our application might be getting this error?

Message: There was an error creating the excel spreadsheet C:\TEMP\gvtemp1.xls. Maximum number of extended formats exceeded.

CallStack:
at Syncfusion.XlsIO.Implementation.Collections.ExtendedFormatsCollection.Add(ExtendedFormatImpl format)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.RegisterExtFormat(ExtendedFormatImpl format)
at Syncfusion.XlsIO.Implementation.CellStyle.EndUpdate()
at Syncfusion.XlsIO.Implementation.ExtendedFormatWrapper.set_BottomBorderLineStyle(ExcelLineStyle value)
at Syncfusion.XlsIO.Implementation.BorderImpl.set_LineStyle(ExcelLineStyle value)
at Syncfusion.GridExcelConverter.GridExcelConverterBase.CopyBorder(GridBorder cellBorder, IBorder rangeBorder)
at Syncfusion.GridExcelConverter.GridExcelConverterBase.CopyBorders(GridStyleInfo gridCell, IRange range)
at Syncfusion.GridExcelConverter.GridExcelConverterBase.CopyStyle(GridStyleInfo gridStyle, IRange destRange)
at Syncfusion.GridExcelConverter.GridExcelConverterBase.CopyStyles(GridModel grid, Int32 iRow, Int32 iColumn, GridStyleInfo gridCell, IRange range)
at Syncfusion.GridExcelConverter.GridExcelConverterControl.GridCellToExcel(GridModel grid, Int32 iRow, Int32 iColumn, IRange range)
at Syncfusion.GridExcelConverter.GridExcelConverterControl.GridToExcel(GridModel grid, IWorksheet sheet, ConverterOptions options)

Lingaraj S [Syncfusion]
Replied On June 24, 2009 08:32 AM

Hi Mark,

Thank you for your interest in Syncfusion product.

I am afraid that I was not able to reproduce the issue in ExcelConverter, when the GridControl has been exported to Excel. Also I have created a simple sample to test this issue and it is available in the following link.
http://files.syncfusion.com/support/samples/Grid.Windows/Forums/GridExport.zip

This sample shows how to Export the GridControl to Excel using GridExcelConverter.

Please let me know if still face the issue, it could be helpful reproduce the steps in the above sample.

Regards,
Lingaraj S.

Administrator [Syncfusion]
Replied On June 24, 2009 11:53 AM

I understand how to export from a grid to excel. It has been working great, but for some reason 1 of our users gets that error.
I definitely don't expect anyone to be able to repro the error, but can you tell me what the error means?
What does "Maximum number of extended formats exceeded." mean?

thanks,
Mark

Lingaraj S [Syncfusion]
Replied On June 25, 2009 04:56 AM

Hi Mark,

Thank you for the update.

I am able to see the issue in GridControl ExcelExport in version 6.4.0.15. When the GridControl has been exported with large number of rows and more column header. This issue has been fixed in our latest version. Please upgrade to our latest version 7.2.037.

Please let me know if you have any other concerns.

Regards,
Lingaraj S.

Administrator [Syncfusion]
Replied On June 26, 2009 02:05 PM

That's great! Thanks for the feedback.

CONFIRMATION

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.

;