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

收藏

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

ZenosZeng · ZenosZeng

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

private Int32 MaxLength = 10;
private void fpSpread1_EditModeOn(object sender, EventArgs e)
{
FarPoint.Win.Spread.CellType.GeneralEditor editor = fpSpread1.EditingControl as FarPoint.Win.Spread.CellType.GeneralEditor;
editor.KeyPress -= new KeyPressEventHandler(editor_KeyPress);
editor.KeyPress += new KeyPressEventHandler(editor_KeyPress);
}
void editor_KeyPress(object sender, KeyPressEventArgs e)
{
string text = fpSpread1.ActiveSheet.ActiveCell.Text + e.KeyChar;
if (text.Length > MaxLength)
{
e.Handled = true;
}
}

复制代码

		自动登录	找回密码
密码			立即注册

[已处理] Spread单元格如何设置按字节长度限定输入