/* ==================================================================== Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for Additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. ==================================================================== */ namespace HH.WMS.Utils.NPOI.HSSF.UserModel { using System; using HH.WMS.Utils.NPOI.HSSF.Record; using HH.WMS.Utils.NPOI.HSSF.UserModel; using HH.WMS.Utils.NPOI.SS.UserModel; using HH.WMS.Utils.NPOI.SS.Util; /** *Utility class for creating data validation cells * * @author Dragos Buleandra (dragos.buleandra@trade2b.ro) */ public class HSSFDataValidation : IDataValidation { private String _prompt_title; private String _prompt_text; private String _error_title; private String _error_text; private int _errorStyle = ERRORSTYLE.STOP; private bool _emptyCellAllowed = true; private bool _suppress_dropdown_arrow = false; private bool _ShowPromptBox = true; private bool _ShowErrorBox = true; private CellRangeAddressList _regions; private DVConstraint _constraint; /** * Constructor which Initializes the cell range on which this object will be * applied * @param constraint */ public HSSFDataValidation(CellRangeAddressList regions, IDataValidationConstraint constraint) { _regions = regions; //FIXME: This cast can be avoided. _constraint = (DVConstraint)constraint; } /* (non-Javadoc) * @see HH.WMS.Utils.NPOI.HSSF.UserModel.DataValidation#getConstraint() */ public IDataValidationConstraint ValidationConstraint { get { return _constraint; } } public DVConstraint Constraint { get { return _constraint; } } public CellRangeAddressList Regions { get { return _regions; } } public int ErrorStyle { get { return _errorStyle; } set { _errorStyle = value; } } public bool EmptyCellAllowed { get { return _emptyCellAllowed; } set { _emptyCellAllowed = value; } } public bool SuppressDropDownArrow { get { if (_constraint.GetValidationType() == ValidationType.LIST) { return _suppress_dropdown_arrow; } return false; } set { _suppress_dropdown_arrow = value; } } public bool ShowPromptBox { get { return _ShowPromptBox; } set { _ShowPromptBox = value; } } public bool ShowErrorBox { get { return _ShowErrorBox; } set { _ShowErrorBox = value; } } /* (non-Javadoc) * @see HH.WMS.Utils.NPOI.HSSF.UserModel.DataValidation#CreatePromptBox(java.lang.String, java.lang.String) */ public void CreatePromptBox(String title, String text) { _prompt_title = title; _prompt_text = text; this.ShowPromptBox = (/*setter*/true); } /* (non-Javadoc) * @see HH.WMS.Utils.NPOI.HSSF.UserModel.DataValidation#getPromptBoxTitle() */ public String PromptBoxTitle { get { return _prompt_title; } } /* (non-Javadoc) * @see HH.WMS.Utils.NPOI.HSSF.UserModel.DataValidation#getPromptBoxText() */ public String PromptBoxText { get { return _prompt_text; } } /* (non-Javadoc) * @see HH.WMS.Utils.NPOI.HSSF.UserModel.DataValidation#CreateErrorBox(java.lang.String, java.lang.String) */ public void CreateErrorBox(String title, String text) { _error_title = title; _error_text = text; this.ShowErrorBox = (/*setter*/true); } /* (non-Javadoc) * @see HH.WMS.Utils.NPOI.HSSF.UserModel.DataValidation#getErrorBoxTitle() */ public String ErrorBoxTitle { get { return _error_title; } } /* (non-Javadoc) * @see HH.WMS.Utils.NPOI.HSSF.UserModel.DataValidation#getErrorBoxText() */ public String ErrorBoxText { get { return _error_text; } } public DVRecord CreateDVRecord(HSSFSheet sheet) { HH.WMS.Utils.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); } } }