|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
System.Objectxl.biff.BaseCellFeatures
xl.CellFeatures
xl.write.WritableCellFeatures
Container for any additional cell features
| Field Summary | |
static xl.biff.BaseCellFeatures.ValidationCondition |
BETWEEN
|
static xl.biff.BaseCellFeatures.ValidationCondition |
EQUAL
|
static xl.biff.BaseCellFeatures.ValidationCondition |
GREATER_EQUAL
|
static xl.biff.BaseCellFeatures.ValidationCondition |
GREATER_THAN
|
static xl.biff.BaseCellFeatures.ValidationCondition |
LESS_EQUAL
|
static xl.biff.BaseCellFeatures.ValidationCondition |
LESS_THAN
|
static xl.biff.BaseCellFeatures.ValidationCondition |
NOT_BETWEEN
|
static xl.biff.BaseCellFeatures.ValidationCondition |
NOT_EQUAL
|
| Fields inherited from class xl.biff.BaseCellFeatures |
logger |
| Constructor Summary | |
WritableCellFeatures()
Constructor |
|
WritableCellFeatures(CellFeatures cf)
Copy constructor |
|
| Method Summary | |
void |
removeComment()
Removes the cell comment, if present |
void |
setComment(System.String s)
Sets the cell comment |
void |
setComment(System.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(System.Collections.ICollection 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(System.String namedRange)
Sets the data validation based upon a named range |
void |
setNumberValidation(double val,
xl.biff.BaseCellFeatures.ValidationCondition c)
Sets the numeric value against which to validate |
void |
setNumberValidation(double val1,
double val2,
xl.biff.BaseCellFeatures.ValidationCondition c)
Sets the numeric range against which to validate the data |
| Methods inherited from class xl.CellFeatures |
getComment, getDataValidationList |
| Methods inherited from class xl.biff.BaseCellFeatures |
getCommentDrawing, getCommentHeight, getCommentWidth, getDVParser, hasDataValidation, hasDropDown, setComboBox, setCommentDrawing, setReadComment, setValidationSettings, setWritableCell |
| Methods inherited from class System.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Field Detail |
public static readonly xl.biff.BaseCellFeatures.ValidationCondition BETWEEN
public static readonly xl.biff.BaseCellFeatures.ValidationCondition NOT_BETWEEN
public static readonly xl.biff.BaseCellFeatures.ValidationCondition EQUAL
public static readonly xl.biff.BaseCellFeatures.ValidationCondition NOT_EQUAL
public static readonly xl.biff.BaseCellFeatures.ValidationCondition GREATER_THAN
public static readonly xl.biff.BaseCellFeatures.ValidationCondition LESS_THAN
public static readonly xl.biff.BaseCellFeatures.ValidationCondition GREATER_EQUAL
public static readonly xl.biff.BaseCellFeatures.ValidationCondition LESS_EQUAL
| Constructor Detail |
public WritableCellFeatures()
public WritableCellFeatures(CellFeatures cf)
cf - the cell to copy| Method Detail |
public void setComment(System.String s)
s - the commentpublic void setComment(System.String s,
double width,
double height)
s - the commentwidth - the width of the comment box in cellsheight - the height of the comment box in cellspublic void removeComment()
public void setDataValidationList(System.Collections.ICollection c)
c - the list of valid valuespublic void setDataValidationRange(int col1,
int row1,
int col2,
int row2)
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 againstpublic void setDataValidationRange(System.String namedRange)
namedRange - the workbook named range defining the validation
boundariespublic void setNumberValidation(double val,
xl.biff.BaseCellFeatures.ValidationCondition c)
val - the numberc - the validation conditionpublic void setNumberValidation(double val1,
double val2,
xl.biff.BaseCellFeatures.ValidationCondition c)
val1 - 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 | |||||||||