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 final jxl.biff.BaseCellFeatures.ValidationCondition
    BETWEEN
     
    static final jxl.biff.BaseCellFeatures.ValidationCondition
    EQUAL
     
    static final jxl.biff.BaseCellFeatures.ValidationCondition
    GREATER_EQUAL
     
    static final jxl.biff.BaseCellFeatures.ValidationCondition
    GREATER_THAN
     
    static final jxl.biff.BaseCellFeatures.ValidationCondition
    LESS_EQUAL
     
    static final jxl.biff.BaseCellFeatures.ValidationCondition
    LESS_THAN
     
    static final jxl.biff.BaseCellFeatures.ValidationCondition
    NOT_BETWEEN
     
    static final jxl.biff.BaseCellFeatures.ValidationCondition
    NOT_EQUAL
     

    Fields inherited from class jxl.biff.BaseCellFeatures

    logger

  • Constructor Summary

    Constructors
    Constructor
    Description
    WritableCellFeatures()
    Constructor
    WritableCellFeatures(CellFeatures cf)
    Copy constructor

  • Method Summary

    Modifier and Type
    Method
    Description
    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(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 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, 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 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

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

  • Method Details

    • setComment

      public void setComment(String s)
      Sets the cell comment
      Overrides:
      setComment in class 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 class 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

    • removeComment

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

    • removeDataValidation

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

    • 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 class jxl.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 class 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

    • setDataValidationRange

      public void setDataValidationRange(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 class jxl.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 class jxl.biff.BaseCellFeatures
      Parameters:
      val - the number
      c - 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 class jxl.biff.BaseCellFeatures
      Parameters:
      val1 - the first number
      val2 - the second number
      c - the validation condition