jxl.write
Class WritableCellFeatures
java.lang.Object
jxl.biff.BaseCellFeatures
public class WritableCellFeatures
Container for any additional cell features
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
|
void | removeComment() - Removes the cell comment, if present
|
void | removeDataValidation() - Removes any data validation, if present
|
void | setComment(String s) - Sets the cell comment
|
void | setComment(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(Collection c) - The list of items to validate for this cell.
|
void | setDataValidationRange(String namedRange) - Sets the data validation based upon a named range
|
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 | setNumberValidation(double val1, double val2, jxl.biff.BaseCellFeatures.ValidationCondition c) - Sets the numeric range against which to validate the data
|
void | setNumberValidation(double val, jxl.biff.BaseCellFeatures.ValidationCondition c) - Sets the numeric value against which to validate
|
getCommentDrawing , getCommentHeight , getCommentWidth , getDVParser , getDataValidationList , hasDataValidation , hasDropDown , removeComment , removeDataValidation , setComboBox , setComment , setComment , setCommentDrawing , setDataValidationList , setDataValidationRange , setDataValidationRange , setNumberValidation , setNumberValidation , setReadComment , setValidationSettings , setWritableCell |
BETWEEN
public static final jxl.biff.BaseCellFeatures.ValidationCondition BETWEEN
EQUAL
public static final jxl.biff.BaseCellFeatures.ValidationCondition EQUAL
GREATER_EQUAL
public static final jxl.biff.BaseCellFeatures.ValidationCondition GREATER_EQUAL
GREATER_THAN
public static final jxl.biff.BaseCellFeatures.ValidationCondition GREATER_THAN
LESS_EQUAL
public static final jxl.biff.BaseCellFeatures.ValidationCondition LESS_EQUAL
LESS_THAN
public static final jxl.biff.BaseCellFeatures.ValidationCondition LESS_THAN
NOT_BETWEEN
public static final jxl.biff.BaseCellFeatures.ValidationCondition NOT_BETWEEN
NOT_EQUAL
public static final jxl.biff.BaseCellFeatures.ValidationCondition NOT_EQUAL
WritableCellFeatures
public WritableCellFeatures()
Constructor
WritableCellFeatures
public WritableCellFeatures(CellFeatures cf)
Copy constructor
removeComment
public void removeComment()
Removes the cell comment, if present
- removeComment in interface jxl.biff.BaseCellFeatures
removeDataValidation
public void removeDataValidation()
Removes any data validation, if present
- removeDataValidation in interface jxl.biff.BaseCellFeatures
setComment
public void setComment(String s)
Sets the cell comment
- setComment in interface jxl.biff.BaseCellFeatures
setComment
public void setComment(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
- setComment in interface jxl.biff.BaseCellFeatures
s
- the commentwidth
- the width of the comment box in cellsheight
- the height of the comment box in cells
setDataValidationList
public void setDataValidationList(Collection c)
The list of items to validate for this cell. For each object in the
collection, the toString() method will be called and the data entered
will be validated against that string
- setDataValidationList in interface jxl.biff.BaseCellFeatures
c
- the list of valid values
setDataValidationRange
public void setDataValidationRange(String namedRange)
Sets the data validation based upon a named range
- setDataValidationRange in interface jxl.biff.BaseCellFeatures
namedRange
- the workbook named range defining the validation
boundaries
setDataValidationRange
public 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.
- setDataValidationRange in interface 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 against
setNumberValidation
public void setNumberValidation(double val1,
double val2,
jxl.biff.BaseCellFeatures.ValidationCondition c)
Sets the numeric range against which to validate the data
- setNumberValidation in interface jxl.biff.BaseCellFeatures
val1
- the first numberval2
- the second numberc
- the validation condition
setNumberValidation
public void setNumberValidation(double val,
jxl.biff.BaseCellFeatures.ValidationCondition c)
Sets the numeric value against which to validate
- setNumberValidation in interface jxl.biff.BaseCellFeatures
val
- the numberc
- the validation condition