public interface DataValidation
Modifier and Type | Interface and Description |
---|---|
static class |
DataValidation.ErrorStyle
Error style constants for error box
(错误框的错误样式常量)
|
Modifier and Type | Method and Description |
---|---|
void |
createErrorBox(java.lang.String title, java.lang.String text)
Sets the title and text for the error box .
(设置错误框的标题和文本。)
|
void |
createPromptBox(java.lang.String title, java.lang.String text)
Sets the title and text for the prompt box .
(设置提示框的标题和文本。)
|
boolean |
getEmptyCellAllowed()
Retrieve the settings for empty cells allowed
(检索允许的空单元格的设置)
|
java.lang.String |
getErrorBoxText() |
java.lang.String |
getErrorBoxTitle() |
int |
getErrorStyle()
o
(这)
|
java.lang.String |
getPromptBoxText() |
java.lang.String |
getPromptBoxTitle() |
CellRangeAddressList |
getRegions() |
boolean |
getShowErrorBox() |
boolean |
getShowPromptBox() |
boolean |
getSuppressDropDownArrow()
Useful only list validation objects .
(仅列出验证对象有用。)
|
DataValidationConstraint |
getValidationConstraint() |
void |
setEmptyCellAllowed(boolean allowed)
Sets if this object allows empty as a valid value
(设置此对象是否允许空作为有效值)
|
void |
setErrorStyle(int error_style)
Sets the error style for error box
(设置错误框的错误样式)
|
void |
setShowErrorBox(boolean show)
Sets the behaviour when an invalid value is entered
(设置输入无效值时的行为)
|
void |
setShowPromptBox(boolean show)
Sets the behaviour when a cell which belongs to this object is selected
(设置选择属于此对象的单元格时的行为)
|
void |
setSuppressDropDownArrow(boolean suppress)
Useful for list validation objects .
(对列表验证对象很有用。)
|
DataValidationConstraint getValidationConstraint()
void setErrorStyle(int error_style)
DataValidation.ErrorStyle
int getErrorStyle()
DataValidation.ErrorStyle
void setEmptyCellAllowed(boolean allowed)
allowed
-
true
if this object should treats empty as valid value ,
false
otherwise
(allowed - 如果此对象应将空视为有效值,则为 true,否则为 false)
boolean getEmptyCellAllowed()
void setSuppressDropDownArrow(boolean suppress)
suppress
- True if a list should display the values into a drop down list , false otherwise . In other words , if a list should display the arrow sign on its right side
(suppress - 如果列表应将值显示到下拉列表中,则为 True,否则为 false。换句话说,如果列表应该在其右侧显示箭头符号)
boolean getSuppressDropDownArrow()
true
if a list should display the values into a drop down list ,
false
otherwise .
(如果列表应将值显示到下拉列表中,则为 true,否则为 false。)
void setShowPromptBox(boolean show)
show
-
true
if an prompt box should be displayed ,
false
otherwise
(show - 如果应显示提示框,则为 true,否则为 false)
boolean getShowPromptBox()
true
if an prompt box should be displayed ,
false
otherwise
(如果应显示提示框,则为 true ,否则为 false)
void setShowErrorBox(boolean show)
show
-
true
if an error box should be displayed ,
false
otherwise
(show - 如果应该显示错误框,则为 true,否则为 false)
boolean getShowErrorBox()
true
if an error box should be displayed ,
false
otherwise
(如果应显示错误框,则为 true ,否则为 false)
void createPromptBox(java.lang.String title, java.lang.String text)
title
- The prompt box's title
(title - 提示框的标题)
text
- The prompt box's text
(text - 提示框的文本)
java.lang.String getPromptBoxTitle()
null
(提示框的标题或 null)
java.lang.String getPromptBoxText()
null
(提示框的文本或 null)
void createErrorBox(java.lang.String title, java.lang.String text)
title
- The error box's title
(title - 错误框的标题)
text
- The error box's text
(text - 错误框的文本)
java.lang.String getErrorBoxTitle()
null
(错误框的标题或 null)
java.lang.String getErrorBoxText()
null
(错误框的文本或 null)
CellRangeAddressList getRegions()
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.