FarPoint FpSpread控件的使用心得2(5)

14 button事件

private void spdSetList_ButtonClicked(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e) {

int rowCount = e.Row;

int columnCount = e.Column;

if (e.Column == 16) {

if (message.ShowMessage(\選択したライン\ {

string DeleteTag = this.spdSetList.ActiveSheet.Cells[rowCount, columnCount+1].Text.Trim(); if (DeleteTag == \ {

this.spdSetList.ActiveSheet.Cells[rowCount, columnCount+1].Text = \

this.spdSetList.ActiveSheet.Cells[rowCount,columnCount+1].BackColor = clrWater; this.spdSetList.ActiveSheet.Rows[rowCount].Visible = false; }

else if (DeleteTag == \ {

this.spdSetList.ActiveSheet.Rows[rowCount].Remove(); } } } }

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/jiezigege/archive/2009/08/27/4486642.aspx

******************************************************

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) {

if(this.spdSetList.ActiveSheet.RowCount ==0) {

return; } }

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) {

if(e.KeyChar >= '0' && e.KeyChar <= '9' || e.KeyChar == 8 || e.KeyChar == 13) {

e.Handled = false; } else {

e.Handled = true; } }

9 // 用来捕捉按钮列等属于按钮范畴的事件 private void spdSetList_ButtonClicked(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e) {

}

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/kennba/archive/2007/03/20/1534651.aspx

*************************************** spread 打印示例代码 收藏 范例C:/Program Files/FarPoint Technologies/Spread70/samples/ActiveX/VB6/OwnerPrint/Project1.vbp

fpSpread1.PrintUseDataMax = False

Printer.Print \

fpSpread1.PrintHeader = \

Call fpSpread1.OwnerPrintDraw(Printer.hDC, 1000, 360, Printer.Width, (Printer.Height / 4), 1) fpSpread1.PrintHeader = \

Call fpSpread1.OwnerPrintDraw(Printer.hDC, 1000, (Printer.Height / 4) + 360, Printer.Width, (Printer.Height / 2), 1)

fpSpread1.PrintHeader = \

Call fpSpread1.OwnerPrintDraw(Printer.hDC, 1000, (Printer.Height / 2) + 360, Printer.Width, ((3 * Printer.Height) / 4), 1)

fpSpread1.PrintHeader = \

Call fpSpread1.OwnerPrintDraw(Printer.hDC, 1000, ((3 * Printer.Height) / 4) + 360, Printer.Width, Printer.Height, 1)

Printer.EndDoc

本文来自CSDN博客，转载请标http://blog.csdn.net/lanman/archive/2007/07/26/1710625.aspx

*************************************************************

出处明：

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库FarPoint FpSpread控件的使用心得2(5)在线全文阅读。