回复 1楼yinzhm的帖子
你好,
ActiveRowIndex 改变时并没有更改 SheetView 的 Selecions 范围,可以在设置之后添加AddSelection来更改选择范围:
- private void Form1_Load(object sender, EventArgs e)
- {
- fpSpread1.ActiveSheet.SelectionStyle = FarPoint.Win.Spread.SelectionStyles.SelectionColors;
- fpSpread1.ActiveSheet.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Range;
- fpSpread1.ActiveSheet.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row;
- fpSpread1.ActiveSheet.AddSelection(0, 0, 2, 2);
- fpSpread1.ActiveSheet.AddSelection(3, 0, 2, 2);
- fpSpread1.ActiveSheet.SelectionBackColor = Color.Red;
- fpSpread1.ActiveSheet.SelectionForeColor = SystemColors.Highlight;
- }
- private void changeActiveRowIndexToolStripMenuItem_Click(object sender, EventArgs e)
- {
- this.fpSpread1.Sheets[0].ActiveRowIndex = 10;
- this.fpSpread1.Sheets[0].AddSelection(10, 0, 1, 1);
-
- CellRange[] crs = this.fpSpread1.Sheets[0].GetSelections();
- }
复制代码 |