|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectjxl.biff.BaseCellFeatures
jxl.CellFeatures
jxl.write.WritableCellFeatures
public class WritableCellFeatures
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 |
|---|
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(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 |
| Methods 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 |
| Methods inherited from class java.lang.Object |
|---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Field Detail |
|---|
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
| Constructor Detail |
|---|
public WritableCellFeatures()
public WritableCellFeatures(CellFeatures cf)
cf - the cell to copy| Method Detail |
|---|
public void setComment(java.lang.String s)
setComment in class jxl.biff.BaseCellFeaturess - the comment
public void setComment(java.lang.String s,
double width,
double height)
setComment in class jxl.biff.BaseCellFeaturess - 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.BaseCellFeaturespublic void removeDataValidation()
removeDataValidation in class jxl.biff.BaseCellFeaturespublic void setDataValidationList(java.util.Collection c)
setDataValidationList in class jxl.biff.BaseCellFeaturesc - the list of valid values
public void setDataValidationRange(int col1,
int row1,
int col2,
int row2)
setDataValidationRange in class jxl.biff.BaseCellFeaturescol1 - 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.BaseCellFeaturesnamedRange - the workbook named range defining the validation
boundaries
public void setNumberValidation(double val,
jxl.biff.BaseCellFeatures.ValidationCondition c)
setNumberValidation in class jxl.biff.BaseCellFeaturesval - the numberc - the validation condition
public void setNumberValidation(double val1,
double val2,
jxl.biff.BaseCellFeatures.ValidationCondition c)
setNumberValidation in class jxl.biff.BaseCellFeaturesval1 - the first numberval2 - the second numberc - the validation condition
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||