public interface DataValidation
Modifier and Type | Interface and Description |
---|---|
static class |
DataValidation.AlertStyle
AlertStyle attributes that can be applied.
|
static class |
DataValidation.Operator
Operator attributes that can be applied.
|
static class |
DataValidation.Type
Type attributes that can be applied.
|
Modifier and Type | Method and Description |
---|---|
DataValidation.AlertStyle |
getAlertStyle()
Returns the alert style.
|
String |
getErrorMessage()
Returns the error message.
|
String |
getErrorTitle()
Returns the title of the data validation error dialog box.
|
String |
getFormula1()
Returns the formula1 expression.
|
String |
getFormula2()
Returns the formula2 expression.
|
String |
getInputMessage()
Returns the input message.
|
String |
getInputTitle()
Returns the title of the data validation input dialog box.
|
DataValidation.Operator |
getOperator()
Returns the data validation operator
|
DataValidation.Type |
getType()
Returns the data validation type
|
boolean |
isIgnoreBlank()
Returns whether to ignore the blank
|
boolean |
isInCellDropdown()
Returns whether to display a drop-down list that contains acceptable values
|
boolean |
isShowError()
Returns whether to show the error message message whenever the user enters
invalid data.
|
boolean |
isShowInput()
Returns whether to show the input message whenever the user selects a cell in the
data validation range.
|
void |
setAlertStyle(DataValidation.AlertStyle alertStyle)
Sets the alert style.
|
void |
setErrorMessage(String errorMessage)
Sets the error message.
|
void |
setErrorTitle(String errorTitle)
Sets the title of the data validation error dialog box.
|
void |
setFormula1(String formula1)
Sets the formula1 expression.
|
void |
setFormula2(String formula2)
Sets the formula2 expression.
|
void |
setIgnoreBlank(boolean ignoreBlank)
Sets to ignore the blank
|
void |
setInCellDropdown(boolean inCellDropdown)
Sets to display a drop-down list that contains acceptable values
|
void |
setInputMessage(String inputMessage)
Sets the input message.
|
void |
setInputTitle(String inputTitle)
Sets the title of the data validation input dialog box.
|
void |
setOperator(DataValidation.Operator operator)
Sets the data validation operator
|
void |
setShowError(boolean showError)
Sets to show the error message message whenever the user enters invalid data.
|
void |
setShowInput(boolean showInput)
Sets to show the input message whenever the user selects a cell in the
data validation range.
|
void |
setType(DataValidation.Type type)
Sets the data validation type
|
void setType(DataValidation.Type type)
DataValidation.Type getType()
void setIgnoreBlank(boolean ignoreBlank)
ignoreBlank
- boolean isIgnoreBlank()
void setInCellDropdown(boolean inCellDropdown)
inCellDropdown
- boolean isInCellDropdown()
void setShowError(boolean showError)
showError
- boolean isShowError()
void setShowInput(boolean showInput)
showInput
- boolean isShowInput()
void setAlertStyle(DataValidation.AlertStyle alertStyle)
alertStyle
- either DataValidation.AlertStyle.Stop
, DataValidation.AlertStyle.Warning
,
or DataValidation.AlertStyle.Information
DataValidation.AlertStyle getAlertStyle()
void setErrorTitle(String errorTitle)
errorTitle
- String getErrorTitle()
void setErrorMessage(String errorMessage)
errorMessage
- String getErrorMessage()
void setInputTitle(String inputTitle)
inputTitle
- String getInputTitle()
void setInputMessage(String inputMessage)
inputMessage
- String getInputMessage()
void setFormula1(String formula1)
formula1
- a string value, a cell reference (i.e. A1Notation), or a formulavoid setFormula2(String formula2)
formula2
- a string value, a cell reference (i.e. A1Notation), or a formulaString getFormula1()
String getFormula2()
void setOperator(DataValidation.Operator operator)
operator
- either DataValidation.Operator.Between
, DataValidation.Operator.NotBetween
,
DataValidation.Operator.Equal
, DataValidation.Operator.NotEqual
,
DataValidation.Operator.LessThan
, DataValidation.Operator.LessThanOrEqual
,
DataValidation.Operator.GreaterThan
, or DataValidation.Operator.GreaterThanOrEqual
DataValidation.Operator getOperator()
Copyright © 2018. All rights reserved.