/** * Used during the copy process to retrieve the validity settings for * a particular cell */ 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 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; }
/** * Removes row * * @param row the row to be removed */ 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); } } }
/** * Removes row * * @param row the row to be removed */ 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); } } }
/** * Removes the data validation for a specific cell * * @param col the column * @param row the row */ 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 * * @param col1 the first column * @param row1 the first row */ public void removeSharedDataValidation (int col1, int row1, int col2, int row2) { for (Iterator i = validitySettings.iterator(); i.hasNext() ; ) { DataValiditySettingsRecord dv = (DataValiditySettingsRecord) i.next(); if (dv.getFirstColumn() == col1 && dv.getLastColumn() == col2 && dv.getFirstRow() == row1 && dv.getLastRow() == row2) { i.remove(); validityList.dvRemoved(); break; } } }
/** * Removes the data validation for a specific cell * * @param col1 the first column * @param row1 the first row */ public void removeSharedDataValidation (int col1, int row1, int col2, int row2) { for (Iterator i = validitySettings.iterator(); i.hasNext() ; ) { DataValiditySettingsRecord dv = (DataValiditySettingsRecord) i.next(); if (dv.getFirstColumn() == col1 && dv.getLastColumn() == col2 && dv.getFirstRow() == row1 && dv.getLastRow() == row2) { i.remove(); validityList.dvRemoved(); break; } } }
/** * Removes the data validation for a specific cell * * @param col the column * @param row the row */ 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; } } }
dvsr.getFirstRow(), dvsr.getLastColumn(), dvsr.getLastRow(),
dvsr.getFirstRow(), dvsr.getLastColumn(), dvsr.getLastRow(),