Class DVRecord

  • All Implemented Interfaces:
    java.lang.Cloneable

    public final class DVRecord
    extends StandardRecord
    implements java.lang.Cloneable
    Title: DATAVALIDATION Record (0x01BE)

    Description: This record stores data validation settings and a list of cell ranges which contain these settings. The data validation settings of a sheet are stored in a sequential list of DV records. This list is followed by DVAL record(s)

    • Constructor Detail

      • DVRecord

        public DVRecord​(int validationType,
                        int operator,
                        int errorStyle,
                        boolean emptyCellAllowed,
                        boolean suppressDropDownArrow,
                        boolean isExplicitList,
                        boolean showPromptBox,
                        java.lang.String promptTitle,
                        java.lang.String promptText,
                        boolean showErrorBox,
                        java.lang.String errorTitle,
                        java.lang.String errorText,
                        Ptg[] formula1,
                        Ptg[] formula2,
                        CellRangeAddressList regions)
    • Method Detail

      • getListExplicitFormula

        public boolean getListExplicitFormula()
        Returns:
        true if in list validations the string list is explicitly given in the formula, false otherwise
      • getEmptyCellAllowed

        public boolean getEmptyCellAllowed()
        Returns:
        true if empty values are allowed in cells, false otherwise
      • getSuppressDropdownArrow

        public boolean getSuppressDropdownArrow()
        Returns:
        true if drop down arrow should be suppressed when list validation is used, false otherwise
      • getShowPromptOnCellSelected

        public boolean getShowPromptOnCellSelected()
        Returns:
        true if a prompt window should appear when cell is selected, false otherwise
      • getShowErrorOnInvalidValue

        public boolean getShowErrorOnInvalidValue()
        Returns:
        true if an error window should appear when an invalid value is entered in the cell, false otherwise
      • getConditionOperator

        public int getConditionOperator()
        get the condition operator
        Returns:
        the condition operator
        See Also:
        utility class
      • getPromptTitle

        public java.lang.String getPromptTitle()
      • getErrorTitle

        public java.lang.String getErrorTitle()
      • getPromptText

        public java.lang.String getPromptText()
      • getErrorText

        public java.lang.String getErrorText()
      • getFormula1

        public Ptg[] getFormula1()
      • getFormula2

        public Ptg[] getFormula2()
      • toString

        public java.lang.String toString()
        Description copied from class: Record
        get a string representation of the record (for biffview/debugging)
        Overrides:
        toString in class Record
      • getSid

        public short getSid()
        Description copied from class: Record
        return the non static version of the id for this record.
        Specified by:
        getSid in class Record
        Returns:
        he id for this record
      • clone

        public DVRecord clone()
        Clones the object. Uses serialisation, as the contents are somewhat complex
        Overrides:
        clone in class Record