Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Roger Blanchard
2170
CellFormat
posted

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

 

 

DO:

oWorksheetRow:CellFormat:FillPattern = FillPatternStyle:Solid.

oWorksheetRow:CellFormat:FillPatternForegroundColor = System.Drawing.Color:LightGray.

 

 

END.

oWorksheetRow:Cells:Item[iColumn]:CellFormat:Font:Color = System.Drawing.Color:Red.

Parents
No Data
Reply
  • 44743
    Verified Answer
    posted

    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.

Children