RecommendedValue Property (GcNumberCellType)

Visual Basic
C#

'Declaration
 
Public Property RecommendedValue As Decimal

'Usage
 
Dim instance As GcNumberCellType
Dim value As Decimal
 
instance.RecommendedValue = value
 
value = instance.RecommendedValue

public decimal RecommendedValue {get; set;}

Property Value

A System.String value that indicates the recommended value.
The default is System.Decimal.Zero.

Exception	Description
System.ArgumentException	Occurs when an invalid value that does not match the current pattern is set with the RecommendedValue property.

The RecommendedValue property provides a hint for the user that is shown before the value is fully entered. When a value is being typed, pressing a special shortcut key or key combination accepts the recommended value.

This example sets the RecommendedValue property.

C#

GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType ncell1 = new GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType();
//Press enter or double-click on the cell to see the recommended value
ncell1.RecommendedValue = 5;
ncell1.ShowRecommendedValue = true;
fpSpread1.Sheets[0].Cells[1, 1].CellType = ncell1;

Visual Basic

Dim ncell1 As New GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType()
'Press enter or double-click on the cell to see the recommended value
ncell1.RecommendedValue = 5
ncell1.ShowRecommendedValue = True
FpSpread1.Sheets(0).Cells(1, 1).CellType = ncell1

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

GcNumberCellType Class
GcNumberCellType Members