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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

GcDateTimeCellType Class
GcDateTimeCellType Members