回复 1楼wlosg的帖子
fpSpread1.BlockMode = True 时,
代表当前的操作是针对选择的单元格范围。例如以下代码可以同时改变这个范围单元格的背景色:
- fpSpread1.Col = 1
- fpSpread1.Row = 1
- fpSpread1.Text = "1st Quarter"
- fpSpread1.Row = 2
- fpSpread1.Text = "2nd Quarter"
- fpSpread1.Row = 3
- fpSpread1.Text = "3rd Quarter"
- fpSpread1.Row = 4
- fpSpread1.Text = "4th Quarter"
- fpSpread1.Col = 1
- fpSpread1.Row = 1
- fpSpread1.Col2 = 1
- fpSpread1.Row2 = 4
- fpSpread1.BlockMode = True
- fpSpread1.BackColor = RGB(192, 192, 100)
复制代码
反之,当fpSpread1.BlockMode = False时,只能设置范围内左上部单元格的背景色。
更详细内容可以参考帮助文档。 |