Farpoint教程.docVIP

标题: Spread的常用事件标题: Spread的常用事件标题: Spread的常用事件标题: Spread的常用事件标题: Spread的常用事件标题: Spread的常用事件标题: Spread的常用事件标题: Spread的常用事件 1 // 单元格编辑结束，焦点离开或者按回车键时 比如：你要判断当前单元格输入内容是否合法。private void fpSpread1_EditModeOff(object sender, System.EventArgs e) 2 // 单元格得到焦点时触发 private void fpSpread1_EnterCell(object sender, FarPoint.Win.Spread.EnterCellEventArgs e) 3// 编辑单元格时触发，单元格内容发生改变 private void fpSpread1_EditChange(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e) 4 // 编辑模式开始时触发private void fpSpread1_EditModeOn(object sender, System.EventArgs e) 5 // 单元格失去焦点时触发private void fpSpread1_LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e) 6 // 双击Spread时触发 一般用来付值，比如把选中行内容传给其他控件private void fpSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e) 7 // 单击Spread时触发 一般用来改变选中行的颜色private void fpSpread1_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e) 8 // 一般用来检测输入内容是否合法，比如检测输入的内容是否是数字 private void fpSpread1_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e) 9 // 用来捕捉按钮列等属于按钮范畴的事件private void spdSetList_ButtonClicked(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e --------------------------------------------------------------------Spread基本知识（一）--------------------------------------------------------------------1 取得当前行号、列号。int row=e.Row; int count=e.Count;或者：int rowindex = fpSpread1.ActiveSheet.ActiveRowIndex;int columnindex = fpSpread1.ActiveSheet.ActiveColumnIndex;2 单击一行变颜色。 private void spdResult_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e){//单击Spread列头时，什么也不处理if(!e.ColumnHeader){if(spdResult.Sheets[0].Rows.Count!=0){for(int i=0;ispdResult.Sheets[0].Rows.Count;i++){spdResult.Sheets[0].Rows[i].BackColor=System.Drawing.Color.White;}int row=e.Row;spdResult.Sheets[0].Rows[row].BackColor=System.Drawing.Color.FromArgb(((System.Byte)(192)), ((System.Byte)(255)), ((System.Byte)(255)));}}}3 将Spread的单元格内容付值给一控件的TexttxtItemCD.Text = spdResu