public DataValidation(DataValidityListRecord dvlr) 
{
      
    validityList = dvlr;
    validitySettings = new ArrayList(validityList.getNumberOfSettings());
    copied = false;
}

Constructor

 public DataValidation(int objId,
    ExternalSheet es,
    WorkbookMethods wm,
    WorkbookSettings ws) 
{
    workbook = wm;
    externalSheet = es;
    workbookSettings = ws;
    validitySettings = new ArrayList();
    comboBoxObjectId = objId;
    copied = false;
}

Constructor used to create writable data validations

 public DataValidation(DataValidation dv,
    ExternalSheet es,
    WorkbookMethods wm,
    WorkbookSettings ws) 
{
    workbook = wm;
    externalSheet = es;
    workbookSettings = ws;
    copied = true;
    validityList = new DataValidityListRecord(dv.getDataValidityList());
    validitySettings = new ArrayList();
    DataValiditySettingsRecord[] settings = dv.getDataValiditySettings();
    for (int i = 0; i <  settings.length ; i++)
    {
      validitySettings.add(new DataValiditySettingsRecord(settings[i],
                                                          externalSheet,
                                                          workbook,
                                                          workbookSettings));
    }
}

Copy constructor used to copy from read to write

 public  void add(DataValiditySettingsRecord dvsr) 
{
    validitySettings.add(dvsr);
    dvsr.setDataValidation(this);
    if (copied)
    {
      // adding a writable dv record to a copied validity list
      Assert.verify(validityList != null);
      validityList.dvAdded();
    }
}

Adds a new settings object to this data validation

 public int getComboBoxObjectId() 
{
    return comboBoxObjectId;
}

Accessor for the combo box, used when copying sheets

 public DataValidityListRecord getDataValidityList() 
{
    return validityList;
}

Accessor for the validity list. Used when copying sheets

 public DataValiditySettingsRecord[] getDataValiditySettings() 
{
    DataValiditySettingsRecord[] dvlr = new DataValiditySettingsRecord[0];
    return (DataValiditySettingsRecord[]) validitySettings.toArray(dvlr);
}

Accessor for the validity settings. Used when copying sheets

 public DataValiditySettingsRecord getDataValiditySettings(int col,
    int row) 
{
    boolean found = false;
    DataValiditySettingsRecord foundRecord = null;
    for (Iterator i = validitySettings.iterator(); i.hasNext() && !found;)
    {
      DataValiditySettingsRecord dvsr = (DataValiditySettingsRecord) i.next();
      if (dvsr.getFirstColumn() == col && dvsr.getFirstRow() == row)
      {
        found = true;
        foundRecord = dvsr;
      }
    }
    return foundRecord;
}

Used during the copy process to retrieve the validity settings for a particular cell

 public  void insertColumn(int col) 
{
    for (Iterator i = validitySettings.iterator(); i.hasNext() ; )
    {
      DataValiditySettingsRecord dv = (DataValiditySettingsRecord) i.next();
      dv.insertColumn(col);
    }
}

Inserts a column

 public  void insertRow(int row) 
{
    for (Iterator i = validitySettings.iterator(); i.hasNext() ; )
    {
      DataValiditySettingsRecord dv = (DataValiditySettingsRecord) i.next();
      dv.insertRow(row);
    }
}

Inserts a row

 public  void removeColumn(int col) 
{
    for (Iterator i = validitySettings.iterator(); i.hasNext() ; )
    {
      DataValiditySettingsRecord dv = (DataValiditySettingsRecord) i.next();
      if (dv.getFirstColumn() == col && dv.getLastColumn() == col)
      {
        i.remove();
        validityList.dvRemoved();
      }
      else
      {
        dv.removeColumn(col);
      }
    }
}

Removes a column

 public  void removeDataValidation(int col,
    int row) 
{
    for (Iterator i = validitySettings.iterator(); i.hasNext() ; )
    {
      DataValiditySettingsRecord dv = (DataValiditySettingsRecord) i.next();
      if (dv.getFirstColumn() == col && dv.getLastColumn() == col &&
          dv.getFirstRow() == row && dv.getLastRow() == row)
      {
        i.remove();
        validityList.dvRemoved();
        break;
      }
    }
}

Removes the data validation for a specific cell

 public  void removeRow(int row) 
{
    for (Iterator i = validitySettings.iterator(); i.hasNext() ; )
    {
      DataValiditySettingsRecord dv = (DataValiditySettingsRecord) i.next();
      if (dv.getFirstRow() == row && dv.getLastRow() == row)
      {
        i.remove();
        validityList.dvRemoved();
      }
      else
      {
        dv.removeRow(row);
      }
    }
}

Inserts a row

 public  void write(File outputFile) throws IOException 
{
    if (validityList == null)
    {
      DValParser dvp = new DValParser(comboBoxObjectId, 
                                      validitySettings.size());
      validityList = new DataValidityListRecord(dvp);
    }
    if (!validityList.hasDVRecords())
    {
      return;
    }
    outputFile.write(validityList);
    for (Iterator i = validitySettings.iterator(); i.hasNext() ; )
    {
      DataValiditySettingsRecord dvsr = (DataValiditySettingsRecord) i.next();
      outputFile.write(dvsr);
    }
}

Writes out the data validation