1
Vote

Issue with styling

description

Thanks for the great tool. Really helpful.

I am trying to apply a background fill (solid color) to rows based on certain conditions. For some reason the style is not sticking.

//style1.Fill.SetGradient(SLGradientShadingStyleValues.Corner1, SLThemeColorIndexValues.Accent1Color, SLThemeColorIndexValues.Accent6Color);

style1.Fill.SetPattern(PatternValues.Solid, System.Drawing.Color.Black, System.Drawing.Color.LightGray);

sl.SetCellStyle(r, 1, r, 14, style1);

Nothing happens with the above code. I am using SpreadsheetLight version 3.4.3.0 and DocumentFormat.OpenXml version 2.0.5022.0

thanks

comments