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
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 © 2005-2010 Potix Corporation. All Rights Reserved.