I have recently upgraded to 11.1 of Winforms and my logic that is creating an excel workbook has an issue with the Cellformat. We are using the Cellformat on the WorksheetRow to set a FillPattern and FillPatternForegroundColor for every other row. This works fine except when the logic will change the Cellformat for an actual cell afterwards. When this occurs the FillPattern and FillPatternForegroundColor are lost. This works just fine in 9.2.20092.2119. Is this an expected change or a bug?
IF
iRow MODULO 2 = 0 THEN
oWorksheetRow:CellFormat:FillPattern = FillPatternStyle:Solid.
oWorksheetRow:CellFormat:FillPatternForegroundColor = System.Drawing.Color:LightGray.
oWorksheetRow:Cells:Item[iColumn]:CellFormat:Font:Color = System.Drawing.Color:Red.
This issue has already been found and fixed (bug id 91505). I believe the SR with this fixed has already been released. Try upgrading to the latest SR to see if it fixes your issue.
The SR did indeed solve my issue.
Thank You!!