Spread Windows Forms 8.0 Product Documentation
AutoConvert Property
Example 


Gets or sets whether to automatically convert the entered characters according to the input mask.
Syntax
'Declaration
 
Public Property AutoConvert As Boolean
'Usage
 
Dim instance As GcTextBoxCellType
Dim value As Boolean
 
instance.AutoConvert = value
 
value = instance.AutoConvert
public bool AutoConvert {get; set;}

Property Value

True if characters are automatically converted according to the input mask; otherwise, false.
The default is true.
Remarks

If the AutoConvert property is set to true, all convertible characters are automatically converted accordingly to the input mask. For example, if the input mask is "A", hitting a lower case character causes the control to automatically convert the character to upper case.

If SBCS is entered in a DBCS mask input, the entered character is automatically converted to DBCS. Also a DBCS space is automatically converted to a SBCS space when the control allows only SBCS.

Example
This example uses the AutoConvert property.
GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType datecell = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
datecell.FieldsEditMode = GrapeCity.Win.Spread.InputMan.CellType.FieldsEditMode.RightSide;
datecell.ExcelExportFormat = "MM/dd/yy";
fpSpread1.Sheets[0].Cells[0, 0].CellType = datecell;

GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType textcell = new GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType();
textcell.AutoConvert = true;
textcell.FormatString = "A";
fpSpread1.Sheets[0].Cells[1, 1].CellType = textcell;
Dim datecell As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType()
datecell.FieldsEditMode = GrapeCity.Win.Spread.InputMan.CellType.FieldsEditMode.RightSide
datecell.ExcelExportFormat = "MM/dd/yy"
FpSpread1.Sheets(0).Cells(0, 0).CellType = datecell

Dim textcell As New GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType()
textcell.AutoConvert = True
textcell.FormatString = "A"
FpSpread1.Sheets(0).Cells(1, 1).CellType = textcell
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

Reference

GcTextBoxCellType Class
GcTextBoxCellType Members
Format Property
AllowSpace Property

 

 


Copyright © GrapeCity, inc. All rights reserved.