ApplyRowStyle is not working with Excel 2010

Aspose.Cells Product Family
1

I have tried to use the following code ot set the style for a row in VS2010. When I open the spreadsheet in Excel 2010 the color of the rows does not display. I am attaching the spreadsheet that was created by the code. the row style should be applied to every row that has a cell value of "true" in the Is Read Only column.

                    Aspose.Cells.Style readOnlyStyle = workbook.CreateStyle();
                    readOnlyStyle.BackgroundColor = Color.Red;
                    readOnlyStyle.Pattern = BackgroundType.Solid;
                    Aspose.Cells.StyleFlag styleFlag = new Aspose.Cells.StyleFlag();
                    styleFlag.All = true;
 
                    cells.ApplyRowStyle(row, style, styleFlag);
2

Hi,

Please change your codes as following:

readOnlyStyle.ForegroundColor = Color.Red;
readOnlyStyle.Pattern = BackgroundType.Solid;