HSSFDataValidation
, XSSFDataValidation
public interface DataValidation
Modifier and Type | Interface | Description |
---|---|---|
static class |
DataValidation.ErrorStyle |
Error style constants for error box
|
Modifier and Type | Method | 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
otherwiseboolean 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 sideboolean getSuppressDropDownArrow()
true
if a list should display the values into a drop down list ,
false
otherwise .void setShowPromptBox(boolean show)
show
- true
if an prompt box should be displayed , false
otherwiseboolean getShowPromptBox()
true
if an prompt box should be displayed , false
otherwisevoid setShowErrorBox(boolean show)
show
- true
if an error box should be displayed , false
otherwiseboolean getShowErrorBox()
true
if an error box should be displayed , false
otherwisevoid createPromptBox(java.lang.String title, java.lang.String text)
title
- The prompt box's titletext
- The prompt box's textjava.lang.String getPromptBoxTitle()
null
java.lang.String getPromptBoxText()
null
void createErrorBox(java.lang.String title, java.lang.String text)
title
- The error box's titletext
- The error box's textjava.lang.String getErrorBoxTitle()
null
java.lang.String getErrorBoxText()
null
CellRangeAddressList getRegions()
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.