Hello Laurence, I need help on style precendence rules.
If you set a style for a range, then set the style for a cell, it looks like it applies that style to the entire range. I was expecting it to work like Excel; I can define a style for a range then change one cell and it should take precendence.
I’m confused about how this currently works. I have 2.6.1.
How would you perform the following ?
1. Set a given range of cells to background color, then make only one cell BOLD but keep the background color.
I’m assuming a cell style uses the range name and then applies its own style in an “additive” fashion. This is how Excel works but I can’t figure out how to do this.
Also, this style seems to set background to black no matter what color I choose…
Dim style2 As Style = x._xls.Styles(x._xls.Styles.Add())
style2.Name = Me.sStyleSiteVisitsRange
style2.Font.Size = 10
style2.Pattern = BackgroundType.Solid
style2.BackgroundColor = Color.Gray
’ yields black for my range for some reason and I don’t think its a palette issue - maybe it is…