DataValiditySettingsRecord(DataValiditySettingsRecord dvsr) 
{
    super(Type.DV);
    data = dvsr.getData();
}

Copy constructor

 public DataValiditySettingsRecord(DVParser dvp) 
{
    super(Type.DV);
    dvParser = dvp;
}

Constructor called when the API creates a writable data validation

Parameters:

dvsr - the record copied from a writable sheet

 public DataValiditySettingsRecord(Record t,
    ExternalSheet es,
    WorkbookMethods wm,
    WorkbookSettings ws) 
{
      
    super(t);
    data = t.getData();
    externalSheet = es;
    workbook = wm;
    workbookSettings = ws;
}

Constructor

 DataValiditySettingsRecord(DataValiditySettingsRecord dvsr,
    ExternalSheet es,
    WorkbookMethods w,
    WorkbookSettings ws) 
{
    super(Type.DV);
    workbook = w;
    externalSheet = es;
    workbookSettings = ws;
    Assert.verify(w != null);
    Assert.verify(es != null);
    data = new byte[dvsr.data.length];
    System.arraycopy(dvsr.data, 0, data, 0, data.length);
}

Constructor

Parameters:

dvsr - the record copied from a writable sheet

 DVParser getDVParser() 
{
    return dvParser;
}

Gets the DVParser. This is used when doing a deep copy of cells on the writable side of things

 public byte[] getData() 
{
    if (dvParser == null)
    {
      return data;
    }
    return dvParser.getData();
}

Retrieves the data for output to binary file

 public int getFirstColumn() 
{
    if (dvParser == null)
    {
      initialize();
    }
    return dvParser.getFirstColumn();
}

Accessor for first column

 public int getFirstRow() 
{
    if (dvParser == null)
    {
      initialize();
    }
    return dvParser.getFirstRow();
}

Accessor for first row

 public int getLastColumn() 
{
    if (dvParser == null)
    {
      initialize();
    }
    return dvParser.getLastColumn();
}

Accessor for the last column

 public int getLastRow() 
{
    if (dvParser == null)
    {
      initialize();
    }
    return dvParser.getLastRow();
}

Accessor for the last row

 public String getValidationFormula() 
{
    try
    {
      if (dvParser == null)
      {
        initialize();
      }
      return dvParser.getValidationFormula();
    }
    catch (FormulaException e)
    {
      logger.warn("Cannot read drop down range " + e.getMessage());
      return "";
    }
}

 public  void insertColumn(int col) 
{
    if (dvParser == null)
    {
      initialize();
    }
    dvParser.insertColumn(col);
}

Inserts a row

 public  void insertRow(int row) 
{
    if (dvParser == null)
    {
      initialize();
    }
    dvParser.insertRow(row);
}

Inserts a row

 public  void removeColumn(int col) 
{
    if (dvParser == null)
    {
      initialize();
    }
    dvParser.removeColumn(col);
}

Removes a column

 public  void removeRow(int row) 
{
    if (dvParser == null)
    {
      initialize();
    }
    dvParser.removeRow(row);
}

Removes a row

  void setDataValidation(DataValidation dv) 
{
    dataValidation = dv;
}

Sets the handle to the data validation record