DataValidation Method

In This Topic

Shows the data validation dialog to limit the type of data that can be entered in a cell.

Syntax

'Declaration
 
Public Shared Function DataValidation( _
   ByVal spread As GcSpreadSheet, _
   ByVal applyAll As Boolean _
) As IDialog

'Usage
 
Dim spread As GcSpreadSheet
Dim applyAll As Boolean
Dim value As IDialog
 
value = BuiltInDialogs.DataValidation(spread, applyAll)

public static IDialog DataValidation( 
   GcSpreadSheet spread,
   bool applyAll
)

spread: The GrapeCity.Wpf.SpreadSheet.GcSpreadSheet control to work with.
applyAll: true to apply changes to all other cells with the same settings; false to change the selected cells only.

The IDialog object represents the format cells dialog.