RecommendedValue Property (GcDateTimeCellType)

Visual Basic
C#

'Declaration
 
Public Property RecommendedValue As Nullable(Of Date)

'Usage
 
Dim instance As GcDateTimeCellType
Dim value As Nullable(Of Date)
 
instance.RecommendedValue = value
 
value = instance.RecommendedValue

public Nullable<DateTime> RecommendedValue {get; set;}

Property Value

A System.DateTime value that indicates the default value of the editor.

Exception	Description
System.ArgumentException	The value isn't valid.

The RecommendedValue property provides a hint for the user and is shown when the value is not completely entered. When a value is being typed, pressing a special shortcut key or key combination accepts the recommended value.

This example uses the RecommendedValue property.

C#

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;

VB.NET

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 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

GcDateTimeCellType Class
GcDateTimeCellType Members