/** * Public function which removes any data validation, if present */ public virtual void removeDataValidation() { if (!dataValidation) { return; } // If the data validation is shared, then generate a warning DVParser dvp = getDVParser(); if (dvp.extendedCellsValidation()) { //logger.warn("Cannot remove data validation from " + // CellReferenceHelper.getCellReference(writableCell) + // " as it is part of the shared reference " + // CellReferenceHelper.getCellReference(dvp.getFirstColumn(), // dvp.getFirstRow()) + // "-" + // CellReferenceHelper.getCellReference(dvp.getLastColumn(), // dvp.getLastRow())); return; } // Remove the validation from the WritableSheet object if present writableCell.removeDataValidation(); clearValidationSettings(); }
/** * Constructor called when doing a cell deep copy */ public DVParser(DVParser copy) { wasCopied = true; type = copy.type; errorStyle = copy.errorStyle; condition = copy.condition; stringListGiven = copy.stringListGiven; emptyCellsAllowed = copy.emptyCellsAllowed; suppressArrow = copy.suppressArrow; showPrompt = copy.showPrompt; showError = copy.showError; promptTitle = copy.promptTitle; promptText = copy.promptText; errorTitle = copy.errorTitle; errorText = copy.errorText; hasExtendedCellsValidation = copy.extendedCellsValidation(); row1 = copy.row1; row2 = copy.row2; column1 = copy.column1; column2 = copy.column2; // Don't copy the formula parsers - just take their string equivalents if (copy.formula1String != null) { formula1String = copy.formula1String; formula2String = copy.formula2String; } else { try { formula1String = copy.formula1.getFormula(); formula2String = (copy.formula2 != null) ? copy.formula2.getFormula() : null; } catch (FormulaException e) { //logger.warn("Cannot parse validation formula: " + e.Message); } } // Don't copy the cell references - these will be added later }
/** * Constructor called when doing a cell deep copy */ public DVParser(DVParser copy) { wasCopied = true; type = copy.type; errorStyle = copy.errorStyle; condition = copy.condition; stringListGiven = copy.stringListGiven; emptyCellsAllowed = copy.emptyCellsAllowed; suppressArrow = copy.suppressArrow; showPrompt = copy.showPrompt; showError = copy.showError; promptTitle = copy.promptTitle; promptText = copy.promptText; errorTitle = copy.errorTitle; errorText = copy.errorText; hasExtendedCellsValidation = copy.extendedCellsValidation(); row1 = copy.row1; row2 = copy.row2; column1 = copy.column1; column2 = copy.column2; // Don't copy the formula parsers - just take their string equivalents if (copy.formula1String != null) { formula1String = copy.formula1String; formula2String = copy.formula2String; } else { try { formula1String = copy.formula1.getFormula(); formula2String = (copy.formula2 != null) ? copy.formula2.getFormula() : null; } catch (FormulaException e) { //logger.warn("Cannot parse validation formula: " + e.Message); } } // Don't copy the cell references - these will be added later }