Validation Class

Validation class

Represents data validation.settings.

type Validation struct  {
	ptr unsafe.Pointer
}

Constructors

Method	Description

Methods

Method	Description
IsNull	Checks whether the implementation object is nullptr.
GetOperator	Represents the operator for the data validation.
SetOperator	Represents the operator for the data validation.
GetAlertStyle	Represents the validation alert style.
SetAlertStyle	Represents the validation alert style.
GetType	Represents the data validation type.
SetType	Represents the data validation type.
GetInputMessage	Represents the data validation input message.
SetInputMessage	Represents the data validation input message.
GetInputTitle	Represents the title of the data-validation input dialog box.
SetInputTitle	Represents the title of the data-validation input dialog box.
GetErrorMessage	Represents the data validation error message.
SetErrorMessage	Represents the data validation error message.
GetErrorTitle	Represents the title of the data-validation error dialog box.
SetErrorTitle	Represents the title of the data-validation error dialog box.
GetShowInput	Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.
SetShowInput	Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.
GetShowError	Indicates whether the data validation error message will be displayed whenever the user enters invalid data.
SetShowError	Indicates whether the data validation error message will be displayed whenever the user enters invalid data.
GetIgnoreBlank	Indicates whether blank values are permitted by the range data validation.
SetIgnoreBlank	Indicates whether blank values are permitted by the range data validation.
GetFormula1_Bool_Bool	Gets the value or expression associated with this validation.
GetFormula2_Bool_Bool	Gets the value or expression associated with this validation.
GetFormula1_Bool_Bool_Int_Int	Gets the value or expression associated with this validation for specific cell.
GetFormula2_Bool_Bool_Int_Int	Gets the value or expression associated with this validation for specific cell.
SetFormula1_String_Bool_Bool	Sets the value or expression associated with this validation.
SetFormula2_String_Bool_Bool	Sets the value or expression associated with this validation.
GetFormula1	Represents the value or expression associated with the data validation.
SetFormula1_String	Represents the value or expression associated with the data validation.
GetFormula2	Represents the value or expression associated with the data validation.
SetFormula2_String	Represents the value or expression associated with the data validation.
GetListValue	Get the value for list of the validation for the specified cell.
GetValue1	Represents the first value associated with the data validation.
SetValue1	Represents the first value associated with the data validation.
GetValue2	Represents the second value associated with the data validation.
SetValue2	Represents the second value associated with the data validation.
GetValue	Get the value of validation on the specific cell.
GetInCellDropDown	Indicates whether data validation displays a drop-down list that contains acceptable values.
SetInCellDropDown	Indicates whether data validation displays a drop-down list that contains acceptable values.
GetAreas	Gets all CellArea which contain the data validation settings.
AddArea_CellArea	Applies the validation to the area.
AddArea_CellArea_Bool_Bool	Applies the validation to the area.
AddAreas	Applies the validation to given areas.
RemoveArea	Remove the validation settings in the range.
RemoveAreas	Removes this validation from given areas.
RemoveACell	Remove the validation settings in the cell.
Copy	Copy validation.