プロパティ値
セルへのテキストの入力書式を指定する文字列。既定値は String.Empty です。
public void SetTextCell5() { TextCellType textCellType1 = new TextCellType(); textCellType1.AutoConvert = true; //The input characters will be converted to capital letters automatically and allow to input 'space' key. textCellType1.Format = "AS"; //If you try to input 'grapecity' in cell, only the 'grape' is left. textCellType1.MaxLength = 5; textCellType1.MaxLengthUnit = GrapeCity.Windows.SpreadGrid.Editors.LengthUnit.Char; //When you try to input 6th char, the focus will move next cell. textCellType1.ExitOnLastChar = true; //The input text will overwrite the existed character. textCellType1.EditMode = GrapeCity.Windows.SpreadGrid.Editors.EditMode.Overwrite; this._gcSpreadGrid1[0, 0].CellType = textCellType1; }
Public Sub SetTextCell5() Dim textCellType1 As New TextCellType() textCellType1.AutoConvert = True 'The input characters will be converted to capital letters automatically and allow to input 'space' key. textCellType1.Format = "AS" 'If you try to input 'grapecity' in cell, only the 'grape' is left. textCellType1.MaxLength = 5 textCellType1.MaxLengthUnit = GrapeCity.Windows.SpreadGrid.Editors.LengthUnit.[Char] 'When you try to input 6th char, the focus will move next cell. textCellType1.ExitOnLastChar = True 'The input text will overwrite the existed character. textCellType1.EditMode = GrapeCity.Windows.SpreadGrid.Editors.EditMode.Overwrite Me._gcSpreadGrid1(0, 0).CellType = textCellType1 End Sub