Package jxl.write
Class WritableCellFeatures
- java.lang.Object
-
- jxl.biff.BaseCellFeatures
-
- jxl.CellFeatures
-
- jxl.write.WritableCellFeatures
-
public class WritableCellFeatures extends CellFeatures
Container for any additional cell features
-
-
Field Summary
Fields Modifier and Type Field 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 Summary
Constructors Constructor Description WritableCellFeatures()
ConstructorWritableCellFeatures(CellFeatures cf)
Copy constructor
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
removeComment()
Removes the cell comment, if presentvoid
removeDataValidation()
Removes any data validation, if presentvoid
setComment(java.lang.String s)
Sets the cell commentvoid
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 displayedvoid
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 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 validate-
Methods inherited from class jxl.CellFeatures
getComment, getDataValidationList, getSharedDataValidationRange
-
-
-
-
Field Detail
-
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 Detail
-
WritableCellFeatures
public WritableCellFeatures()
Constructor
-
WritableCellFeatures
public WritableCellFeatures(CellFeatures cf)
Copy constructor- Parameters:
cf
- the cell to copy
-
-
Method Detail
-
setComment
public void setComment(java.lang.String s)
Sets the cell comment- Overrides:
setComment
in classjxl.biff.BaseCellFeatures
- Parameters:
s
- the comment
-
setComment
public 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- 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
public void setDataValidationList(java.util.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 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
public void setDataValidationRange(java.lang.String namedRange)
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
-
-