Spread单元格如何设置按字节长度限定输入

我用的是spread 6.0，能否设置成按字节长度限定输入，比如设置长度为10位，则只能输入5个汉字

你可以通过下面代码实现该功能：

1.     private Int32 MaxLength = 10;
   
2. 
   
3.     private void fpSpread1_EditModeOn(object sender, EventArgs e)
   
4.     {
   
5.         FarPoint.Win.Spread.CellType.GeneralEditor editor = fpSpread1.EditingControl as FarPoint.Win.Spread.CellType.GeneralEditor;
   
6.         editor.KeyPress -= new KeyPressEventHandler(editor_KeyPress);
   
7.         editor.KeyPress += new KeyPressEventHandler(editor_KeyPress);
   
8. 
   
9.     }
   
10. 
    
11.     void editor_KeyPress(object sender, KeyPressEventArgs e)
    
12.     {
    
13.         string text = fpSpread1.ActiveSheet.ActiveCell.Text + e.KeyChar;
    
14.         if (text.Length > MaxLength)
    
15.         {
    
16.             e.Handled = true;
    
17.         }
    
18.     }

复制代码