Examples of org.apache.poi.hssf.record.DVRecord

org.apache.poi.hssf.record.DVRecord
Title: DATAVALIDATION Record (0x01BE)
Description: This record stores data validation settings and a list of cell ranges which contain these settings. The data validation settings of a sheet are stored in a sequential list of DV records. This list is followed by DVAL record(s) @author Dragos Buleandra (dragos.buleandra@trade2b.ro) @version 2.0-pre


  public DVRecord createDVRecord(HSSFWorkbook workbook) {


    FormulaPair fp = _constraint.createFormulas(workbook);
    
    return new DVRecord(_constraint.getValidationType(),
        _constraint.getOperator(),
        _errorStyle, _emptyCellAllowed, getSuppressDropDownArrow(),
        _constraint.isExplicitList(),
        _showPromptBox, _prompt_title, _prompt_text,
        _showErrorBox, _error_title, _error_text,

View Full Code Here

       if (dataValidation == null) {
           throw new IllegalArgumentException("objValidation must not be null");
       }
       DataValidityTable dvt = sheet.getOrCreateDataValidityTable();


       DVRecord dvRecord = dataValidation.createDVRecord(workbook);
       dvt.addDataValidation(dvRecord);
    }

View Full Code Here

           throw new IllegalArgumentException("objValidation must not be null");
       }
       HSSFDataValidation hssfDataValidation = (HSSFDataValidation)dataValidation;
       DataValidityTable dvt = _sheet.getOrCreateDataValidityTable();


       DVRecord dvRecord = hssfDataValidation.createDVRecord(this);
       dvt.addDataValidation(dvRecord);
    }

View Full Code Here


  public DVRecord createDVRecord(HSSFSheet sheet) {


    FormulaPair fp = _constraint.createFormulas(sheet);
    
    return new DVRecord(_constraint.getValidationType(),
        _constraint.getOperator(),
        _errorStyle, _emptyCellAllowed, getSuppressDropDownArrow(),
        _constraint.getValidationType()==ValidationType.LIST && _constraint.getExplicitListValues()!=null,
        _showPromptBox, _prompt_title, _prompt_text,
        _showErrorBox, _error_title, _error_text,

View Full Code Here

            @Override
            public void visitRecord(Record r) {
                if (!(r instanceof DVRecord)) {
                    return;
                }
                DVRecord dvRecord = (DVRecord) r;
                CellRangeAddressList regions = dvRecord.getCellRangeAddress().copy();
                DVConstraint constraint = DVConstraint.createDVConstraint(dvRecord, book);
                HSSFDataValidation hssfDataValidation = new HSSFDataValidation(regions, constraint);
                hssfDataValidation.setErrorStyle(dvRecord.getErrorStyle());
                hssfDataValidation.setEmptyCellAllowed(dvRecord.getEmptyCellAllowed());
                hssfDataValidation.setSuppressDropDownArrow(dvRecord.getSuppressDropdownArrow());
                hssfDataValidation.createPromptBox(dvRecord.getPromptTitle(), dvRecord.getPromptText());
                hssfDataValidation.setShowPromptBox(dvRecord.getShowPromptOnCellSelected());
                hssfDataValidation.createErrorBox(dvRecord.getErrorTitle(), dvRecord.getErrorText());
                hssfDataValidation.setShowErrorBox(dvRecord.getShowErrorOnInvalidValue());
                hssfValidations.add(hssfDataValidation);
            }
        };
        dvt.visitContainedRecords(visitor);
        return hssfValidations;

View Full Code Here

            throw new IllegalArgumentException("objValidation must not be null");
        }
        HSSFDataValidation hssfDataValidation = (HSSFDataValidation) dataValidation;
        DataValidityTable dvt = _sheet.getOrCreateDataValidityTable();


        DVRecord dvRecord = hssfDataValidation.createDVRecord(this);
        dvt.addDataValidation(dvRecord);
    }

View Full Code Here

       if (dataValidation == null) {
           throw new IllegalArgumentException("objValidation must not be null");
       }
       DataValidityTable dvt = sheet.getOrCreateDataValidityTable();


       DVRecord dvRecord = dataValidation.createDVRecord(workbook);
       dvt.addDataValidation(dvRecord);
    }

View Full Code Here


  public DVRecord createDVRecord(HSSFWorkbook workbook) {


    FormulaPair fp = _constraint.createFormulas(workbook);
    
    return new DVRecord(_constraint.getValidationType(),
        _constraint.getOperator(),
        _errorStyle, _emptyCellAllowed, getSuppressDropDownArrow(),
        _constraint.isExplicitList(),
        _showPromptBox, _prompt_title, _prompt_text,
        _showErrorBox, _error_title, _error_text,

View Full Code Here

       if (dataValidation == null) {
           throw new IllegalArgumentException("objValidation must not be null");
       }
       DataValidityTable dvt = sheet.getOrCreateDataValidityTable();


       DVRecord dvRecord = dataValidation.createDVRecord(workbook);
       dvt.addDataValidation(dvRecord);
    }

View Full Code Here


  public DVRecord createDVRecord(HSSFWorkbook workbook) {


    FormulaPair fp = _constraint.createFormulas(workbook);
    
    return new DVRecord(_constraint.getValidationType(),
        _constraint.getOperator(),
        _errorStyle, _emptyCellAllowed, getSuppressDropDownArrow(),
        _constraint.isExplicitList(),
        _showPromptBox, _prompt_title, _prompt_text,
        _showErrorBox, _error_title, _error_text,

View Full Code Here

0 1

TOP

Related Classes of org.apache.poi.hssf.record.DVRecord

org.apache.poi.hssf.record.common.UnicodeString

org.apache.poi.hssf.record.formula.Ptg

org.apache.poi.hssf.record.UnicodeString.UnicodeRecordStats

org.apache.poi.hssf.usermodel.HSSFDataValidation

org.apache.poi.hssf.usermodel.HSSFSheet

org.apache.poi.hssf.util.CellRangeAddress

org.apache.poi.hssf.util.CellRangeAddressList

org.apache.poi.hssf.util.HSSFCellRangeAddress

org.apache.poi.ss.util.CellRangeAddress

org.apache.poi.ss.util.CellRangeAddressList

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.