public interface SDataValidation extends FormulaContent
Modifier and Type | Interface and Description |
---|---|
static class |
SDataValidation.AlertStyle |
static class |
SDataValidation.OperatorType |
static class |
SDataValidation.ValidationType |
Modifier and Type | Method and Description |
---|---|
void |
addRegion(CellRegion region) |
SDataValidation.AlertStyle |
getAlertStyle() |
java.lang.String |
getErrorMessage() |
java.lang.String |
getErrorTitle() |
java.lang.String |
getFormula1() |
java.lang.String |
getFormula2() |
java.lang.Object |
getId() |
java.lang.String |
getInputMessage() |
java.lang.String |
getInputTitle() |
int |
getNumOfValue() |
int |
getNumOfValue1() |
int |
getNumOfValue2() |
SDataValidation.OperatorType |
getOperatorType() |
java.util.List<SCell> |
getReferToCellList() |
java.util.List<SCell> |
getReferToCellList(int row,
int col)
Return the referred list relative to the specified row and column.
|
java.util.Set<CellRegion> |
getRegions() |
SSheet |
getSheet() |
SDataValidation.ValidationType |
getValidationType() |
java.lang.Object |
getValue(int i) |
java.lang.Object |
getValue1(int i) |
java.lang.Object |
getValue2(int i) |
boolean |
hasReferToCellList() |
boolean |
hasReferToRelativeCol()
Returns whether the referred list formula contains a relative column.
|
boolean |
hasReferToRelativeRow()
Returns whether the referred list formula contains a relative row.
|
boolean |
isFormulaParsingError()
Return formula parsing state.
|
boolean |
isIgnoreBlank() |
boolean |
isInCellDropdown() |
boolean |
isShowError() |
boolean |
isShowInput() |
void |
removeRegion(CellRegion region) |
void |
setAlertStyle(SDataValidation.AlertStyle alertStyle) |
void |
setErrorMessage(java.lang.String message) |
void |
setErrorTitle(java.lang.String title) |
void |
setFormula1(java.lang.String formula) |
void |
setFormula2(java.lang.String formula) |
void |
setIgnoreBlank(boolean ignore) |
void |
setInCellDropdown(boolean show) |
void |
setInputMessage(java.lang.String message) |
void |
setInputTitle(java.lang.String title) |
void |
setOperatorType(SDataValidation.OperatorType type) |
void |
setRegions(java.util.Set<CellRegion> regions) |
void |
setShowError(boolean show) |
void |
setShowInput(boolean show) |
void |
setValidationType(SDataValidation.ValidationType type) |
clearFormulaResultCache
SSheet getSheet()
SDataValidation.AlertStyle getAlertStyle()
void setAlertStyle(SDataValidation.AlertStyle alertStyle)
void setIgnoreBlank(boolean ignore)
boolean isIgnoreBlank()
void setInCellDropdown(boolean show)
boolean isInCellDropdown()
void setShowInput(boolean show)
boolean isShowInput()
void setShowError(boolean show)
boolean isShowError()
void setInputTitle(java.lang.String title)
void setInputMessage(java.lang.String message)
java.lang.String getInputTitle()
java.lang.String getInputMessage()
void setErrorTitle(java.lang.String title)
void setErrorMessage(java.lang.String message)
java.lang.String getErrorTitle()
java.lang.String getErrorMessage()
java.util.Set<CellRegion> getRegions()
void setRegions(java.util.Set<CellRegion> regions)
void addRegion(CellRegion region)
void removeRegion(CellRegion region)
SDataValidation.ValidationType getValidationType()
void setValidationType(SDataValidation.ValidationType type)
SDataValidation.OperatorType getOperatorType()
void setOperatorType(SDataValidation.OperatorType type)
boolean isFormulaParsingError()
isFormulaParsingError
in interface FormulaContent
boolean hasReferToCellList()
java.util.List<SCell> getReferToCellList()
int getNumOfValue()
java.lang.Object getValue(int i)
int getNumOfValue1()
java.lang.Object getValue1(int i)
int getNumOfValue2()
java.lang.Object getValue2(int i)
java.lang.String getFormula1()
java.lang.String getFormula2()
void setFormula1(java.lang.String formula)
void setFormula2(java.lang.String formula)
java.lang.Object getId()
boolean hasReferToRelativeCol()
boolean hasReferToRelativeRow()
java.util.List<SCell> getReferToCellList(int row, int col)
row
- col
- Copyright © 2005-2010 Potix Corporation. All Rights Reserved.