Example usage for org.apache.poi.xssf.usermodel XSSFDataValidation setShowErrorBox

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFDataValidation setShowErrorBox.

Prototype

public void setShowErrorBox(boolean show) 

Source Link

Usage

From source file:com.plugin.excel.util.ExcelFileHelper.java

License:Apache License

private static void addNumberValidation(Cell cell) {

    if (cell != null) {

        Sheet sheet = cell.getSheet();//  ww w  . ja va  2s. c o  m
        DataValidationHelper dvHelper = sheet.getDataValidationHelper();
        XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint) dvHelper
                .createNumericConstraint(ValidationType.DECIMAL, DVConstraint.OperatorType.BETWEEN, "1.00",
                        "1000000000000.00");
        CellRangeAddressList addressList = new CellRangeAddressList(cell.getRowIndex(), cell.getRowIndex(),
                cell.getColumnIndex(), cell.getColumnIndex());
        XSSFDataValidation validation = (XSSFDataValidation) dvHelper.createValidation(dvConstraint,
                addressList);
        validation.setErrorStyle(ErrorStyle.STOP);
        validation.createErrorBox("Error", "Only numeric values are allowed");
        validation.setShowErrorBox(true);
        sheet.addValidationData(validation);
    }

}

---

From source file:de.bund.bfr.knime.openkrise.db.imports.custom.bfrnewformat.TraceGenerator.java

License:Open Source License

private void insertDropBox(XSSFDataValidationHelper dvHelper, XSSFSheet sheetTracing, int row, int col,
        String ref) {//  w  w w  .j  a v  a2s  .  c  o  m
    XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint) dvHelper
            .createFormulaListConstraint(ref);
    CellRangeAddressList addressList = new CellRangeAddressList(row, row, col, col);
    XSSFDataValidation validation = (XSSFDataValidation) dvHelper.createValidation(dvConstraint, addressList);
    validation.setShowErrorBox(true);
    validation.setSuppressDropDownArrow(true);
    validation.setShowPromptBox(true);
    sheetTracing.addValidationData(validation);
}

---

From source file:de.bund.bfr.knime.openkrise.db.imports.custom.bfrnewformat.TraceGenerator.java

License:Open Source License

private void insertCondition(XSSFDataValidationHelper dvHelper, XSSFSheet sheetTracing, int row, int col,
        String min, String max) {
    XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint) dvHelper
            .createIntegerConstraint(OperatorType.BETWEEN, min, max);
    // dvConstraint = (XSSFDataValidationConstraint) dvHelper.createExplicitListConstraint(new String[]{"0000011", "0000021", "0000031"});
    CellRangeAddressList addressList = new CellRangeAddressList(row, row, col, col);
    XSSFDataValidation validation = (XSSFDataValidation) dvHelper.createValidation(dvConstraint, addressList);
    validation.setShowErrorBox(true);
    validation.setSuppressDropDownArrow(true);
    validation.setShowPromptBox(true);//from   ww  w.ja va  2  s  . com
    sheetTracing.addValidationData(validation);
}

---

From source file:de.bund.bfr.knime.openkrise.db.imports.custom.bfrnewformat.TraceGenerator.java

License:Open Source License

private void insertDecCondition(XSSFDataValidationHelper dvHelper, XSSFSheet sheetTracing, int row, int col) {
    XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint) dvHelper
            .createDecimalConstraint(OperatorType.GREATER_OR_EQUAL, "0", "");
    // dvConstraint = (XSSFDataValidationConstraint) dvHelper.createExplicitListConstraint(new String[]{"0000011", "0000021", "0000031"});
    CellRangeAddressList addressList = new CellRangeAddressList(row, row, col, col);
    XSSFDataValidation validation = (XSSFDataValidation) dvHelper.createValidation(dvConstraint, addressList);
    validation.setShowErrorBox(true);
    validation.setSuppressDropDownArrow(true);
    validation.setShowPromptBox(true);/*  ww  w  .j a  va 2  s  .  c o m*/
    sheetTracing.addValidationData(validation);
}

---