Exemple #1
0
        public DVRecord CreateDVRecord(HSSFSheet sheet)
        {
            NPOI.HSSF.UserModel.DVConstraint.FormulaPair fp = _constraint.CreateFormulas(sheet);

            return(new DVRecord(_constraint.GetValidationType(),
                                _constraint.Operator,
                                _errorStyle, _emptyCellAllowed, SuppressDropDownArrow,
                                _constraint.GetValidationType() == ValidationType.LIST && _constraint.ExplicitListValues != null,
                                _ShowPromptBox, _prompt_title, _prompt_text,
                                _ShowErrorBox, _error_title, _error_text,
                                fp.Formula1, fp.Formula2,
                                _regions));
        }
Exemple #2
0
        public DVRecord CreateDVRecord(HSSFWorkbook workbook)
        {
            FormulaPair fp = _constraint.CreateFormulas(workbook);

            return(new DVRecord(_constraint.GetValidationType(),
                                _constraint.Operator,
                                (int)_error_style, _empty_cell_allowed, SuppressDropDownArrow,
                                _constraint.IsExplicitList,
                                this._show_prompt_box, _prompt_title, _prompt_text,
                                this._show_error_box, _error_title, _error_text,
                                fp.Formula1, fp.Formula2,
                                _regions));
        }