I'm having a problem with setting colors to a tablestyle when adding a new one.
I use the following code to set the colors, but when alering the table to have table breaks, the header bottom color isn't green but red.
what have i missed or did i do wrong.
' TITLE ROWS
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 5), _
CInt(GridLineType.HorizontalBottom), _
CInt(RowType.TitleRow))
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 5), _
CInt(GridLineType.HorizontalTop), _
CInt(RowType.TitleRow))
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 5), _
CInt(GridLineType.VerticalLeft), _
CInt(RowType.TitleRow))
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 5), _
CInt(GridLineType.VerticalRight), _
CInt(RowType.TitleRow))
' HEADER ROWS
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 3), _
CInt(GridLineType.HorizontalBottom), _
CInt(RowType.HeaderRow))
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 5), _
CInt(GridLineType.VerticalLeft), _
CInt(RowType.HeaderRow))
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 5), _
CInt(GridLineType.VerticalRight), _
CInt(RowType.HeaderRow))
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 3), _
CInt(GridLineType.HorizontalInside), _
CInt(RowType.HeaderRow))
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 3), _
CInt(GridLineType.HorizontalInside), _
CInt(RowType.HeaderRow))
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 1), _
CInt(GridLineType.VerticalInside), _
CInt(RowType.HeaderRow))
' DATA ROWS
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 5), _
CInt(GridLineType.HorizontalBottom), _
CInt(RowType.DataRow))
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 3), _
CInt(GridLineType.HorizontalTop), _
CInt(RowType.DataRow))
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 5), _
CInt(GridLineType.VerticalLeft), _
CInt(RowType.DataRow))
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 5), _
CInt(GridLineType.VerticalRight), _
CInt(RowType.DataRow))
ts.SetGridColor(Color.FromColorIndex(ColorMethod.ByAci, 1), _
CInt(GridLineType.InnerGridLines), _
CInt(RowType.DataRow))