Class DVRecord

All Implemented Interfaces:
Cloneable

public final class DVRecord extends StandardRecord implements 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)

  • Field Details

  • Constructor Details

    • DVRecord

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

      public DVRecord(RecordInputStream in)
  • Method Details

    • getDataType

      public int getDataType()
      Returns:
      the condition data type
      See Also:
    • getErrorStyle

      public int getErrorStyle()
      Returns:
      the condition error style
      See Also:
    • 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:
    • getPromptTitle

      public String getPromptTitle()
    • getErrorTitle

      public String getErrorTitle()
    • getPromptText

      public String getPromptText()
    • getErrorText

      public String getErrorText()
    • getFormula1

      public Ptg[] getFormula1()
    • getFormula2

      public Ptg[] getFormula2()
    • getCellRangeAddress

      public CellRangeAddressList getCellRangeAddress()
    • toString

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

      public void serialize(LittleEndianOutput out)
      Description copied from class: StandardRecord
      Write the data content of this BIFF record. The 'ushort sid' and 'ushort size' header fields have already been written by the superclass.

      The number of bytes written must equal the record size reported by RecordBase.getRecordSize()} minus four ( record header consisting of a 'ushort sid' and 'ushort reclength' has already been written by their superclass).

      Specified by:
      serialize in class StandardRecord
      Parameters:
      out - the output object
    • getDataSize

      protected int getDataSize()
      Specified by:
      getDataSize in class StandardRecord
    • 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