Gets or sets the recommended value.
Property Value
A
System.DateTime value that indicates the default value of the editor.
This example uses the RecommendedValue property.
GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType datecell = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
datecell.RecommendedValue = System.DateTime.Now;
datecell.ShowRecommendedValue = true;
fpSpread1.Sheets[0].Cells[0, 0].CellType = datecell;
GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType textcell = new GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType();
textcell.RecommendedValue = "Test";
textcell.ShowRecommendedValue = true;
fpSpread1.Sheets[0].Cells[1, 1].CellType = textcell;
Dim datecell As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType()
datecell.RecommendedValue = System.DateTime.Now
datecell.ShowRecommendedValue = True
FpSpread1.Sheets(0).Cells(0, 0).CellType = datecell
Dim textcell As New GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType()
textcell.RecommendedValue = "Test"
textcell.ShowRecommendedValue = True
FpSpread1.Sheets(0).Cells(1, 1).CellType = textcell
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10