I have just upgraded a Web Project from version 10.2 to version 10.3 (With latest service release), and am getting the following error exporting my grid to Excel
at Infragistics.Excel.FormattingRun.Equals(Object obj) at Infragistics.Excel.FormattedStringElement.HasSameData(GenericCacheElement otherElement) at Infragistics.Excel.FormattedStringElement.Equals(Object obj) at System.Collections.Generic.ObjectEqualityComparer`1.Equals(T x, T y) at System.Collections.Generic.Dictionary`2.FindEntry(TKey key) at System.Collections.Generic.Dictionary`2.TryGetValue(TKey key, TValue& value) at Infragistics.Excel.GenericCachedCollection`1.Find(T element) at Infragistics.Excel.GenericCacheElement.FindExistingOrAddToCache[T](T newElement, GenericCachedCollection`1 collection) at Infragistics.Excel.GenericCacheElementProxy`1.AfterSet() at Infragistics.Excel.WorksheetShapeWithText.VerifyTextFormattingRuns() at Infragistics.Excel.WorksheetCellComment.set_Cell(WorksheetCell value) at Infragistics.Excel.WorksheetCell.set_Comment(WorksheetCellComment value) at FlashReport.UltraWebGridExcelExporter1_CellExporting(Object sender, CellExportingEventArgs e) in i:\Work_SmartSeries\InforPortal2011\CRSReports\FlashReport.aspx.cs:line 793
protected void UltraWebGridExcelExporter1_CellExporting(object sender, Infragistics.WebUI.UltraWebGrid.ExcelExport.CellExportingEventArgs e) { if (e.Value != null) { if (e.GridRow != null) { if (e.GridRow.Cells.FromKey(e.GridColumn.BaseColumnName).Title != null) { string tooltipText = e.GridRow.Cells.FromKey(e.GridColumn.BaseColumnName).Title;
try { e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex].Comment = new WorksheetCellComment() { Text = new FormattedString(tooltipText) }; } catch (Exception ex) { string temp = ex.Message; } } } } }
This was working fine under version 10.2
Thanks
David
This issue was reported and fixed and should be in the latest SR for versions 10.1 and later.
Sorry the routine is what is causing the issue, if I comment out the code in this event that adds the comments to the Excel sheet then it exports fine.