Hi All!
i get in the exportation the next error, i have exporting a Grid With 10Rows, and 1 in that rows, has a lot of child-rows, and the application throws me this error:
Index was outside the bounds of the array.
at Infragistics.Documents.Excel.GenericElementHashSet`1.AddIfItemDoesntExist(T element, T& existingElement)
at Infragistics.Documents.Excel.GenericCachedCollection`1.FindOrAdd(T element, T& equivalentElement)
at Infragistics.Documents.Excel.GenericCacheElement.FindExistingOrAddToCache[T](T newElement, GenericCachedCollection`1 collection)
at Infragistics.Documents.Excel.WorksheetCellBlock.SetCellValueInternalHelper(WorksheetRow row, Int16 columnIndex, Object valueInternal, DataType& type, CellValue& cellValue)
at Infragistics.Documents.Excel.WorksheetCellBlock.SetCellValueInternal(WorksheetRow row, Int16 columnIndex, Object newValueInternal, Boolean checkForBlockingValues)
at Infragistics.Documents.Excel.WorksheetRow.SetCellValueInternal(Int16 columnIndex, Object valueInternal, Boolean checkForBlockingValues)
at Infragistics.Documents.Excel.WorksheetRow.SetCellValue(Int32 columnIndex, Object value)
at Infragistics.Documents.Excel.WorksheetCell.set_Value(Object value)
at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.SetRegionRelativeToOrigin(UltraGridExporterHelper exportHelper, Rectangle rect, Object val, IWorksheetCellFormat cellFormat)
at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.WriteValueCell(UltraGridExporterHelper exportHelper, UltraGridRow row, UltraGridColumn ugColumn, Rectangle valueCellRect)
at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.ExportRowValuesCells(UltraGridExporterHelper exportHelper, UltraGridRow row)
at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.WriteSingleRow(UltraGridExporterHelper exportHelper, UltraGridRow row)
at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.ProcessSingleRow(UltraGridExporterHelper exportHelper, UltraGridRow row)
at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.ProcessGridRowInternal(UltraGridExporterHelper exportHelper, UltraGridRow row, ProcessRowParams processRowParams)
at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExporterHelper.ProcessRow(UltraGridRow row, ProcessRowParams processRowParams)
at Infragistics.Win.UltraWinGrid.RowsCollection.InternalTraverseRowsHelper(IUltraGridExporter exporter)
at Infragistics.Win.UltraWinGrid.UltraGrid.Export(IUltraGridExporter exporter)
at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.Export(UltraGrid grid, Worksheet worksheet, Int32 startRow, Int32 startColumn)
at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.Export(UltraGrid grid, WorkbookFormat workbookFormat)
at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.Export(UltraGrid grid, String fileName, WorkbookFormat workbookFormat)
at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.Export(UltraGrid grid, String fileName)
I Have the Infragistics 11.1, anyone knows what's happened?.
Regards!
Alfredo
Can you post a small sample which reproduces this issue? Also, have you tried using the latest SR for 11.1 to see if this issue was fixed?
Hi,
I have the same exception when I try to export grid to excel for big grid like 15000 rows, for 14000 I do not get the exception. I cannot give you any easy sample as the code is a bit complicated. I have version 11.1.20111.2009. Is there a chance to do something with it?
Best regards,
Dominik
I apologize for the delayed response. It appears this bug has already been submitted and fixed as bug id 82020. From the bug report, it appears it was fixed in 11.1 and later starting in version 11.1.20111.2050. Please upgrade to the latest SR and let me know if you are still experiencing the issue. Thank you.