jxl.write

Class WritableCellFeatures


public class WritableCellFeatures
extends CellFeatures

Container for any additional cell features

Field Summary

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

Fields inherited from class jxl.biff.BaseCellFeatures

BETWEEN, EQUAL, GREATER_EQUAL, GREATER_THAN, LESS_EQUAL, LESS_THAN, NOT_BETWEEN, NOT_EQUAL, logger

Constructor Summary

WritableCellFeatures()
Constructor
WritableCellFeatures(CellFeatures cf)
Copy constructor

Method Summary

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

Methods inherited from class jxl.CellFeatures

getComment, getDataValidationList

Methods inherited from class jxl.biff.BaseCellFeatures

getCommentDrawing, getCommentHeight, getCommentWidth, getDVParser, getDataValidationList, hasDataValidation, hasDropDown, removeComment, removeDataValidation, setComboBox, setComment, setComment, setCommentDrawing, setDataValidationList, setDataValidationRange, setDataValidationRange, setNumberValidation, setNumberValidation, setReadComment, setValidationSettings, setWritableCell

Field Details

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

Constructor Details

WritableCellFeatures

public WritableCellFeatures()
Constructor

WritableCellFeatures

public WritableCellFeatures(CellFeatures cf)
Copy constructor
Parameters:
cf - the cell to copy

Method Details

removeComment

public void removeComment()
Removes the cell comment, if present
Overrides:
removeComment in interface jxl.biff.BaseCellFeatures

removeDataValidation

public void removeDataValidation()
Removes any data validation, if present
Overrides:
removeDataValidation in interface jxl.biff.BaseCellFeatures

setComment

public void setComment(String s)
Sets the cell comment
Overrides:
setComment in interface jxl.biff.BaseCellFeatures
Parameters:
s - the comment

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
Overrides:
setComment in interface jxl.biff.BaseCellFeatures
Parameters:
s - the comment
width - the width of the comment box in cells
height - 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
Overrides:
setDataValidationList in interface jxl.biff.BaseCellFeatures
Parameters:
c - the list of valid values

setDataValidationRange

public void setDataValidationRange(String namedRange)
Sets the data validation based upon a named range
Overrides:
setDataValidationRange in interface jxl.biff.BaseCellFeatures
Parameters:
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.
Overrides:
setDataValidationRange in interface jxl.biff.BaseCellFeatures
Parameters:
col1 - the first column containing the data to validate against
row1 - the first row containing the data to validate against
col2 - the second column containing the data to validate against
row2 - 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
Overrides:
setNumberValidation in interface jxl.biff.BaseCellFeatures
Parameters:
val1 - the first number
val2 - the second number
c - the validation condition

setNumberValidation

public void setNumberValidation(double val,
                                jxl.biff.BaseCellFeatures.ValidationCondition c)
Sets the numeric value against which to validate
Overrides:
setNumberValidation in interface jxl.biff.BaseCellFeatures
Parameters:
val - the number
c - the validation condition