Posted 8 September 2017, 1:26 pm EST
Hi, I have two questions:
I have many spread sheets that have header text that needs to wrap onto two lines. I think that the only way to do this is to make the cell type a text and set the wrap text and multi-line to true. Can you please confirm if this is true or not?
My other question is that I need to have gradient header cells. I have used the following code and it works great, if I am using the default header cell type (not text). If I changed the cell type to text for the word wrap, it does not work as well as the 3-D border colors.
Dim gc As New FarPoint.Win.Spread.CellType.GradientHeaderRenderer(System.Drawing.Color.FromArgb(255, 225, 235, 255), System.Drawing.Color.FromArgb(255, 200, 215, 255), System.Drawing.Color.FromArgb(255, 225, 235, 255), System.Drawing.Color.FromArgb(255, 200, 215, 255), Drawing2D.LinearGradientMode.Vertical)
ssCustomers.ActiveSheet.ColumnHeader.Rows(0).Renderer = gc
I also tried the following example for a solid color, which I don't want, but I tried it anyway trying to solve this.
Dim darkstyle As New FarPoint.Win.Spread.StyleInfo()
darkstyle.BackColor = Color.Teal
darkstyle.ForeColor = Color.Yellow
ssCustomers.ActiveSheet.ColumnHeader.DefaultStyle = darkstyle
It will color the background on the cells that have a cell type of text the teal color and all of the cells text (ForeColor) yellow.
Bottom line, I need to do to have a gradient background for text and default type header cells. Can you help with this?