vb中spread打印时预览没有黑线

使用了动态增加列，所以在打印预览里面只有增加的列没有黑线边框，其他固定的列都有，fpSpread.InsertRows使用这个方法进行动态增加的。请问如何设置，可以在预览中查看增加行的border黑线

回复 1楼zhaoyuanxu的帖子

可以通过 SetCellBorder 设置新增行的 Border：

1. 
   
2. ' Hide the horizontal and vertical grid lines
   
3. fpSpread1.GridShowHoriz = False
   
4. fpSpread1.GridShowVert = False
   
5. ' Set a cell border on the top, bottom,
   
6. ' and left side of cell B2
   
7. fpSpread1.SetCellBorder 2, 2, 2, 2, 1, &H800000, CellBorderStyleSolid
   
8. fpSpread1.SetCellBorder 2, 2, 2, 2, 4, &H800000, CellBorderStyleSolid
   
9. fpSpread1.SetCellBorder 2, 2, 2, 2, 8, &H800000, CellBorderStyleSolid
   
10. ' Set a cell border on the top, bottom,
    
11. ' and right side of cell C2
    
12. fpSpread1.SetCellBorder 3, 2, 3, 2, 2, &H800000, CellBorderStyleSolid
    
13. fpSpread1.SetCellBorder 3, 2, 3, 2, 4, &H800000, CellBorderStyleSolid
    
14. fpSpread1.SetCellBorder 3, 2, 3, 2, 8, &H800000, CellBorderStyleSolid
    
15. ' Set the text to overflow to adjacent empty cells
    
16. fpSpread1.AllowCellOverflow = True
    
17. ' Provide text
    
18. fpSpread1.Col = 2
    
19. fpSpread1.Row = 2
    
20. fpSpread1.Text = "ADZ Racing Supplies"
    

复制代码