急求【Spread自定义类型】

想自定义一个类型，类型和Text类型基本相同，
但是，当MaxLength设置为40的时候，自定义
类型的单元格只能输入40个Byte，不论手输入
还是粘贴，都只能输入40个Byte求详细代码。

因为本人重来没有自定义过类型，所以求详细
代码，越详细，越好，在此非常感谢！！！

谢谢！！！！

回复 1楼miyaminn的帖子

抱歉让你久等了，关于自定义单元格类型的例子，请你先参考：

1. 
   
2. class myCkBox  : FarPoint.Win.Spread.CellType.CheckBoxCellType
   
3. {
   
4. CheckBox ckbx = new CheckBox();
   
5. 
   
6. public myCkBox()
   
7. {
   
8. }
   
9. new event EventHandler EditingCanceled;
   
10. new event EventHandler EditingStopped;
    
11. 
    
12. public override void StartEditing(EventArgs e, bool selectAll, bool autoClipboard)
    
13. {
    
14.    return;
    
15. }
    
16. public override void CancelEditing()
    
17. {
    
18.    EditingCanceled(ckbx, EventArgs.Empty);
    
19.    base.FireEditingCanceled();
    
20. }
    
21. public override bool StopEditing()
    
22. {
    
23.    if (EditingStopped != null)
    
24.    {
    
25.       EditingStopped(ckbx, EventArgs.Empty);
    
26.       base.FireEditingStopped();
    
27.       return true;
    
28.    }
    
29.    else
    
30.    {
    
31.       return false;
    
32.    }
    
33. }
    
34. 
    
35. public override bool IsReservedKey(KeyEventArgs e)
    
36. {
    
37.    return base.IsReservedKey(e);
    
38. }
    
39. public override object IsReservedLocation(Graphics g, int x, int y, Rectangle r, FarPoint.Win.Spread.Appearance appr, object
    
40. value, float zoom)
    
41. {
    
42.    return base.IsReservedLocation(g, x, y, r, appr, value, zoom);
    
43. }
    
44. public override Size GetPreferredSize(Graphics g, Size size, FarPoint.Win.Spread.Appearance appr, object value, float zoom)
    
45. {
    
46.    return base.GetPreferredSize(g, size, appr, value, zoom);
    
47. }
    
48. public override object Parse(string s)
    
49. {
    
50.    return base.Parse(s);
    
51. }
    
52. public override string Format(object o)
    
53. {
    
54.    return base.Format(o.ToString());
    
55. }
    
56. public override Control GetEditorControl(FarPoint.Win.Spread.Appearance appearance, float zoomFactor)
    
57. {
    
58.    return ckbx;
    
59. }
    
60. public override object GetEditorValue()
    
61. {
    
62.    return ckbx.CheckState;
    
63. }
    
64. public override void PaintCell(Graphics g, Rectangle r, FarPoint.Win.Spread.Appearance appr, object value, bool issel, bool
    
65. islocked, float zoom)
    
66. {
    
67.    GetEditorValue();
    
68.    if (ckbx.CheckState == CheckState.Checked)
    
69.    {
    
70.       ControlPaint.DrawCheckBox(g, r.X, r.Y, r.Width - 40, r.Height - 6, ButtonState.Checked);
    
71.    }
    
72.    else if (ckbx.CheckState == CheckState.Unchecked)
    
73.    {
    
74.      ControlPaint.DrawCheckBox(g, r.X, r.Y, r.Width - 40, r.Height - 6, ButtonState.Normal);
    
75.    }
    
76. }
    
77. public override void SetEditorValue(object value)
    
78. {
    
79.    ckbx.CheckState = CheckState.Checked;
    
80. }
    
81. public override Cursor GetReservedCursor(object o)
    
82. {
    
83.    return base.GetReservedCursor(o);
    
84. }
    
85. }
    
86. 
    
87. private void menuItem4_Click(object sender, System.EventArgs e)
    
88. {
    
89.    myCkBox ckbx = new myCkBox();
    
90.    fpSpread1.ActiveSheet.Cells[0, 0].CellType = ckbx;
    
91. }
    
92. 
    

复制代码

在获取的时候直接把 fpspread1.EditorControl 转化成  TextBox 即可：

1. 
   
2.         void fpSpread1_EditModeOn(object sender, EventArgs e)
   
3.         {
   
4.             TextBox tb = this.fpSpread1.EditingControl as TextBox;
   
5.             tb.TextChanged += tb_TextChanged;
   
6.         }
   

复制代码

自定义 TextCellType 基本思路和上面代码相同，大概代码如下。

1. 
   
2.    private void Form1_Load(object sender, EventArgs e)
   
3.         {
   
4.             this.fpSpread1.ActiveSheet.Columns[1].CellType = new MyTextBoxCellType();
   
5.         }
   
6.         GeneralEditor editor;
   
7.         void fpSpread1_EditModeOn(object sender, EventArgs e)
   
8.         {
   
9.             TextBox tb = this.fpSpread1.EditingControl as TextBox;
   
10.             tb.TextChanged += tb_TextChanged;
    
11.         }
    
12. 
    
13.         void tb_TextChanged(object sender, EventArgs e)
    
14.         {
    
15.             
    
16.         }
    
17.         public class MyTextBoxCellType : FarPoint.Win.Spread.CellType.TextCellType
    
18.         {
    
19.             public override Control GetEditorControl(Control parent, FarPoint.Win.Spread.Appearance appearance, float zoomFactor)
    
20.             {
    
21.                 TextBox tx = new TextBox();
    
22.                 tx.BackColor = Color.Black;
    
23.                 return tx;
    
24.             }
    
25. 
    
26.             public override void SetEditorValue(object value)
    
27.             {
    
28.                 base.SetEditorValue(value);
    
29.             }
    
30.         }
    

复制代码

有后续问题欢迎继续交流