Posted 8 September 2017, 2:20 pm EST
Hi, Iam trying to set the verticalGridLines to be black and the horizontal lines to be gray with the following two lines of code. But the problem is because of the horizontal lines, there is a gap between each cell for the verticalgridlines. if I make the width of the horizontal line to be zero, it works but the horizontal lines vanish (for obvious reason). So, How can I tackle this situation ? I want dark vertical lines with no gaps and gray horizonallines.
.Sheets(0).VerticalGridLine =New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Black, Color.Black, Color.Black, 1.5)
.Sheets(0).HorizontalGridLine =New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.LightGray, Color.LightGray, color.LightGray, 0.6)
Any help is apreciated.