public class WritableCellFeatures extends CellFeatures
Modifier and Type | Field and Description |
---|---|
static jxl.biff.BaseCellFeatures.ValidationCondition |
BETWEEN |
static jxl.biff.BaseCellFeatures.ValidationCondition |
EQUAL |
static jxl.biff.BaseCellFeatures.ValidationCondition |
GREATER_EQUAL |
static jxl.biff.BaseCellFeatures.ValidationCondition |
GREATER_THAN |
static jxl.biff.BaseCellFeatures.ValidationCondition |
LESS_EQUAL |
static jxl.biff.BaseCellFeatures.ValidationCondition |
LESS_THAN |
static jxl.biff.BaseCellFeatures.ValidationCondition |
NOT_BETWEEN |
static jxl.biff.BaseCellFeatures.ValidationCondition |
NOT_EQUAL |
Constructor and Description |
---|
WritableCellFeatures()
Constructor
|
WritableCellFeatures(CellFeatures cf)
Copy constructor
|
Modifier and Type | Method and Description |
---|---|
void |
removeComment()
Removes the cell comment, if present
|
void |
removeDataValidation()
Removes any data validation, if present
|
void |
setComment(java.lang.String s)
Sets the cell comment
|
void |
setComment(java.lang.String s,
double width,
double height)
Sets the cell comment and sets the size of the text box (in cells)
in which the comment is displayed
|
void |
setDataValidationList(java.util.Collection c)
The list of items to validate for this cell.
|
void |
setDataValidationRange(int col1,
int row1,
int col2,
int row2)
The list of items to validate for this cell in the form of a cell range.
|
void |
setDataValidationRange(java.lang.String namedRange)
Sets the data validation based upon a named range.
|
void |
setNumberValidation(double val,
jxl.biff.BaseCellFeatures.ValidationCondition c)
Sets the numeric value against which to validate
|
void |
setNumberValidation(double val1,
double val2,
jxl.biff.BaseCellFeatures.ValidationCondition c)
Sets the numeric range against which to validate the data
|
getComment, getDataValidationList, getSharedDataValidationRange
public static final jxl.biff.BaseCellFeatures.ValidationCondition BETWEEN
public static final jxl.biff.BaseCellFeatures.ValidationCondition NOT_BETWEEN
public static final jxl.biff.BaseCellFeatures.ValidationCondition EQUAL
public static final jxl.biff.BaseCellFeatures.ValidationCondition NOT_EQUAL
public static final jxl.biff.BaseCellFeatures.ValidationCondition GREATER_THAN
public static final jxl.biff.BaseCellFeatures.ValidationCondition LESS_THAN
public static final jxl.biff.BaseCellFeatures.ValidationCondition GREATER_EQUAL
public static final jxl.biff.BaseCellFeatures.ValidationCondition LESS_EQUAL
public WritableCellFeatures()
public WritableCellFeatures(CellFeatures cf)
cf
- the cell to copypublic void setComment(java.lang.String s)
setComment
in class jxl.biff.BaseCellFeatures
s
- the commentpublic void setComment(java.lang.String s, double width, double height)
setComment
in class jxl.biff.BaseCellFeatures
s
- the commentwidth
- the width of the comment box in cellsheight
- the height of the comment box in cellspublic void removeComment()
removeComment
in class jxl.biff.BaseCellFeatures
public void removeDataValidation()
removeDataValidation
in class jxl.biff.BaseCellFeatures
public void setDataValidationList(java.util.Collection c)
setDataValidationList
in class jxl.biff.BaseCellFeatures
c
- the list of valid valuespublic void setDataValidationRange(int col1, int row1, int col2, int row2)
setDataValidationRange
in class jxl.biff.BaseCellFeatures
col1
- the first column containing the data to validate againstrow1
- the first row containing the data to validate againstcol2
- the second column containing the data to validate againstrow2
- the second row containing the data to validate againstpublic void setDataValidationRange(java.lang.String namedRange)
setDataValidationRange
in class jxl.biff.BaseCellFeatures
namedRange
- the workbook named range defining the validation
boundariespublic void setNumberValidation(double val, jxl.biff.BaseCellFeatures.ValidationCondition c)
setNumberValidation
in class jxl.biff.BaseCellFeatures
val
- the numberc
- the validation conditionpublic void setNumberValidation(double val1, double val2, jxl.biff.BaseCellFeatures.ValidationCondition c)
setNumberValidation
in class jxl.biff.BaseCellFeatures
val1
- the first numberval2
- the second numberc
- the validation condition