AddValidation メソッド

検証を設定します。

構文

Visual Basic
C#

'Declaration
 
Public Function AddValidation( _
   ByVal cellRanges() As CellRange, _
   ByVal type As GrapeCity.Spreadsheet.DataValidationType, _
   ByVal operator As GrapeCity.Spreadsheet.DataValidationOperator, _
   ByVal errorStyle As GrapeCity.Spreadsheet.DataValidationErrorStyle, _
   ByVal formula1 As String, _
   Optional ByVal formula2 As String, _
   Optional ByVal ignoreBlank As Boolean, _
   Optional ByVal inCellDropdown As Boolean, _
   Optional ByVal showInput As Boolean, _
   Optional ByVal inputTitle As String, _
   Optional ByVal inputMessage As String, _
   Optional ByVal showError As Boolean, _
   Optional ByVal errorTitle As String, _
   Optional ByVal errorMessage As String _
) As GrapeCity.Spreadsheet.DataValidation

'使用法
 
Dim instance As SheetView
Dim cellRanges() As CellRange
Dim type As GrapeCity.Spreadsheet.DataValidationType
Dim operator As GrapeCity.Spreadsheet.DataValidationOperator
Dim errorStyle As GrapeCity.Spreadsheet.DataValidationErrorStyle
Dim formula1 As String
Dim formula2 As String
Dim ignoreBlank As Boolean
Dim inCellDropdown As Boolean
Dim showInput As Boolean
Dim inputTitle As String
Dim inputMessage As String
Dim showError As Boolean
Dim errorTitle As String
Dim errorMessage As String
Dim value As GrapeCity.Spreadsheet.DataValidation
 
value = instance.AddValidation(cellRanges, type, operator, errorStyle, formula1, formula2, ignoreBlank, inCellDropdown, showInput, inputTitle, inputMessage, showError, errorTitle, errorMessage)

public GrapeCity.Spreadsheet.DataValidation AddValidation( 
   CellRange[] cellRanges,
   GrapeCity.Spreadsheet.DataValidationType type,
   GrapeCity.Spreadsheet.DataValidationOperator operator,
   GrapeCity.Spreadsheet.DataValidationErrorStyle errorStyle,
   string formula1,
   string formula2,
   bool ignoreBlank,
   bool inCellDropdown,
   bool showInput,
   string inputTitle,
   string inputMessage,
   bool showError,
   string errorTitle,
   string errorMessage
)

パラメータ

cellRanges: セル範囲。
type: 型。
operator: 演算子。
errorStyle: エラースタイル。
formula1: 数式1。
formula2: 数式2。
ignoreBlank: 空白を無視する場合はtrue。
inCellDropdown: セルドロップダウンの場合はtrue。
showInput: 入力を表示する場合はtrue。
inputTitle: 入力タイトル。
inputMessage: 入力メッセージ。
showError: エラーを表示する場合はtrue。
errorTitle: エラータイトル。
errorMessage: エラーメッセージ。

戻り値の型

GrapeCity.Spreadsheet.DataValidation。

参照

SheetView クラス
 SheetView メンバ