Package jxl.write
Class WritableCellFeatures
java.lang.Object
jxl.biff.BaseCellFeatures
jxl.CellFeatures
jxl.write.WritableCellFeatures
Container for any additional cell features
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final jxl.biff.BaseCellFeatures.ValidationCondition
static final jxl.biff.BaseCellFeatures.ValidationCondition
static final jxl.biff.BaseCellFeatures.ValidationCondition
static final jxl.biff.BaseCellFeatures.ValidationCondition
static final jxl.biff.BaseCellFeatures.ValidationCondition
static final jxl.biff.BaseCellFeatures.ValidationCondition
static final jxl.biff.BaseCellFeatures.ValidationCondition
static final jxl.biff.BaseCellFeatures.ValidationCondition
Fields inherited from class jxl.biff.BaseCellFeatures
logger
-
Constructor Summary
ConstructorsConstructorDescriptionConstructorCopy constructor -
Method Summary
Modifier and TypeMethodDescriptionvoid
Removes the cell comment, if presentvoid
Removes any data validation, if presentvoid
setComment
(String s) Sets the cell commentvoid
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 displayedvoid
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
(String namedRange) Sets the data validation based upon a named range.void
setNumberValidation
(double val1, double val2, jxl.biff.BaseCellFeatures.ValidationCondition c) Sets the numeric range against which to validate the datavoid
setNumberValidation
(double val, jxl.biff.BaseCellFeatures.ValidationCondition c) Sets the numeric value against which to validateMethods inherited from class jxl.CellFeatures
getComment, getDataValidationList, getSharedDataValidationRange
Methods inherited from class jxl.biff.BaseCellFeatures
getCommentDrawing, getCommentHeight, getCommentWidth, getDVParser, hasDataValidation, hasDropDown, removeSharedDataValidation, setComboBox, setCommentDrawing, setReadComment, setValidationSettings, setWritableCell, shareDataValidation
-
Field Details
-
BETWEEN
public static final jxl.biff.BaseCellFeatures.ValidationCondition BETWEEN -
NOT_BETWEEN
public static final jxl.biff.BaseCellFeatures.ValidationCondition NOT_BETWEEN -
EQUAL
public static final jxl.biff.BaseCellFeatures.ValidationCondition EQUAL -
NOT_EQUAL
public static final jxl.biff.BaseCellFeatures.ValidationCondition NOT_EQUAL -
GREATER_THAN
public static final jxl.biff.BaseCellFeatures.ValidationCondition GREATER_THAN -
LESS_THAN
public static final jxl.biff.BaseCellFeatures.ValidationCondition LESS_THAN -
GREATER_EQUAL
public static final jxl.biff.BaseCellFeatures.ValidationCondition GREATER_EQUAL -
LESS_EQUAL
public static final jxl.biff.BaseCellFeatures.ValidationCondition LESS_EQUAL
-
-
Constructor Details
-
WritableCellFeatures
public WritableCellFeatures()Constructor -
WritableCellFeatures
Copy constructor- Parameters:
cf
- the cell to copy
-
-
Method Details
-
setComment
Sets the cell comment- Overrides:
setComment
in classjxl.biff.BaseCellFeatures
- Parameters:
s
- the comment
-
setComment
Sets the cell comment and sets the size of the text box (in cells) in which the comment is displayed- Overrides:
setComment
in classjxl.biff.BaseCellFeatures
- Parameters:
s
- the commentwidth
- the width of the comment box in cellsheight
- the height of the comment box in cells
-
removeComment
public void removeComment()Removes the cell comment, if present- Overrides:
removeComment
in classjxl.biff.BaseCellFeatures
-
removeDataValidation
public void removeDataValidation()Removes any data validation, if present- Overrides:
removeDataValidation
in classjxl.biff.BaseCellFeatures
-
setDataValidationList
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 classjxl.biff.BaseCellFeatures
- Parameters:
c
- the list of valid values
-
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 classjxl.biff.BaseCellFeatures
- Parameters:
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
-
setDataValidationRange
Sets the data validation based upon a named range. If the namedRange is an empty string ("") then the cell is effectively made read only- Overrides:
setDataValidationRange
in classjxl.biff.BaseCellFeatures
- Parameters:
namedRange
- the workbook named range defining the validation boundaries
-
setNumberValidation
public void setNumberValidation(double val, jxl.biff.BaseCellFeatures.ValidationCondition c) Sets the numeric value against which to validate- Overrides:
setNumberValidation
in classjxl.biff.BaseCellFeatures
- Parameters:
val
- the numberc
- the validation condition
-
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 classjxl.biff.BaseCellFeatures
- Parameters:
val1
- the first numberval2
- the second numberc
- the validation condition
-