I am using Infragistics4.Documents.Excel.v11.2 to create an excel spreadsheet. I am able to load all of the data correctly. I then go to format the sheet and set the font. Using this code:
'Sheet is already populated
Dim sheet As Worksheet
For Each row as WorksheetRow in sheet.Rows
For Each cell as WorksheetCell in row.Cells
cell.CellFormat.Font.Name = "Trebuchet MS"
Next
As I'm processing the second row, the cell Next statement throws the exception:
Collection was modified after the enumerator was instantiated.
Stack Trace:
at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
at System.Collections.Generic.SortedList`2.Enumerator.MoveNext()
at Infragistics.Documents.Excel.WorksheetRow.<GetCellsWithData>d__a.MoveNext()
at Infragistics.Documents.Excel.WorksheetCellCollection.<GetEnumeratorHelper>d__0.MoveNext()
at ConsoleApplication1.Module1.Main()
Any ideas what is causing this error to be thrown?
Hello,
I try to reproduce your issue in a small sample, but without success. Could you please take a look at the attached sample and video file and please feel free to modify this sample to reproduce your issue and revert it back to me. I`ll be glad to research your issue. Also please tell me do you have any installed service release and which one.
Let me know if you have any questions.
Regards
HI,
Have you been able to resolve your issue ? Did you have a time ot take a look at th eattached sample. Let me know if you have any questions.