1,453
社区成员
发帖
与我相关
我的任务
分享spreadsheet 控件的单元格内容的长度如何控制？高分相送！
如何将spreadsheet的单元格的内容长度进行控制，如设定单元格中的内容长度不能超过8个字节！
...全文
请发表友善的回复…
发表回复
zhengoodman 2004-08-03
- 打赏
- 举报
SSMain.ColWidth(i) = 8
beastpupu 2004-08-01
- 打赏
- 举报
spread.TypeMaxEditLen 属性
dljinsui 2004-07-31
- 打赏
- 举报
给分！！
dljinsui 2004-07-31
- 打赏
- 举报
Spread.TypeEditLen = 200
yhx1980 2004-07-28
- 打赏
- 举报
能不能说清楚一点，我看不太明白呀！
gpo2002 2004-07-28
- 打赏
- 举报
TypeMaxEditLen As Integer
FPSpreadADO.fpSpread 的成员
Sets or returns the maximum number of characters users can enter in an edit cell or in the edit field of a combo box cell.
***********************************************************************
To limit user entry in an edit cell
At run time,
1,If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property, or continue and work with the active sheet.
2,Set the Col, Col2, Row, and Row2 properties as appropriate.
3,If you are selecting a block of cells, set the BlockMode property to True.
4,Set the CellType property to 1 (Edit).
5,Provide a character set that specifies what the user can type into the cell by setting the TypeEditCharSet property.
6,Specify the maximum number of characters allowed in the cell using the TypeMaxEditLen property.
7,Allow users to type text in multiple lines by setting the TypeEditMultiLine property to True.
8,If you selected a block of cells, set the BlockMode property back to False.
FPSpreadADO.fpSpread 的成员
Sets or returns the maximum number of characters users can enter in an edit cell or in the edit field of a combo box cell.
***********************************************************************
To limit user entry in an edit cell
At run time,
1,If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property, or continue and work with the active sheet.
2,Set the Col, Col2, Row, and Row2 properties as appropriate.
3,If you are selecting a block of cells, set the BlockMode property to True.
4,Set the CellType property to 1 (Edit).
5,Provide a character set that specifies what the user can type into the cell by setting the TypeEditCharSet property.
6,Specify the maximum number of characters allowed in the cell using the TypeMaxEditLen property.
7,Allow users to type text in multiple lines by setting the TypeEditMultiLine property to True.
8,If you selected a block of cells, set the BlockMode property back to False.
