Package org.apache.poi.hssf.usermodel

Class HSSFDataValidation

  • All Implemented Interfaces:
    DataValidation
    public final class HSSFDataValidation
extends Object
implements DataValidation
    Utility class for creating data validation cells

    • Constructor Detail

      • HSSFDataValidation

        public HSSFDataValidation​(CellRangeAddressList regions,
                          DataValidationConstraint constraint)
        Constructor which initializes the cell range on which this object will be applied
        Parameters:
        regions - A list of regions where the constraint is validated.
        constraint - The constraints to apply for this validation.

    • Method Detail

      • setEmptyCellAllowed

        public void setEmptyCellAllowed​(boolean allowed)
        Description copied from interface: DataValidation
        Sets if this object allows empty as a valid value
        Specified by:
        setEmptyCellAllowed in interface DataValidation
        Parameters:
        allowed - true if this object should treats empty as valid value , false otherwise

      • getEmptyCellAllowed

        public boolean getEmptyCellAllowed()
        Description copied from interface: DataValidation
        Retrieve the settings for empty cells allowed
        Specified by:
        getEmptyCellAllowed in interface DataValidation
        Returns:
        True if this object should treats empty as valid value , false otherwise

      • setSuppressDropDownArrow

        public void setSuppressDropDownArrow​(boolean suppress)
        Description copied from interface: DataValidation
        Useful for list validation objects .
        Specified by:
        setSuppressDropDownArrow in interface DataValidation
        Parameters:
        suppress - True if a list should display the values into a drop down list , false otherwise . In other words , if a list should display the arrow sign on its right side

      • getSuppressDropDownArrow

        public boolean getSuppressDropDownArrow()
        Description copied from interface: DataValidation
        Useful only list validation objects . This method always returns false if the object isn't a list validation object
        Specified by:
        getSuppressDropDownArrow in interface DataValidation
        Returns:
        true if a list should display the values into a drop down list , false otherwise .

      • setShowPromptBox

        public void setShowPromptBox​(boolean show)
        Description copied from interface: DataValidation
        Sets the behaviour when a cell which belongs to this object is selected
        Specified by:
        setShowPromptBox in interface DataValidation
        Parameters:
        show - true if an prompt box should be displayed , false otherwise

      • getShowPromptBox

        public boolean getShowPromptBox()
        Specified by:
        getShowPromptBox in interface DataValidation
        Returns:
        true if an prompt box should be displayed , false otherwise

      • setShowErrorBox

        public void setShowErrorBox​(boolean show)
        Description copied from interface: DataValidation
        Sets the behaviour when an invalid value is entered
        Specified by:
        setShowErrorBox in interface DataValidation
        Parameters:
        show - true if an error box should be displayed , false otherwise

      • getShowErrorBox

        public boolean getShowErrorBox()
        Specified by:
        getShowErrorBox in interface DataValidation
        Returns:
        true if an error box should be displayed , false otherwise

      • createPromptBox

        public void createPromptBox​(String title,
                            String text)
        Description copied from interface: DataValidation
        Sets the title and text for the prompt box . Prompt box is displayed when the user selects a cell which belongs to this validation object . In order for a prompt box to be displayed you should also use method setShowPromptBox( boolean show )
        Specified by:
        createPromptBox in interface DataValidation
        Parameters:
        title - The prompt box's title
        text - The prompt box's text

      • createErrorBox

        public void createErrorBox​(String title,
                           String text)
        Description copied from interface: DataValidation
        Sets the title and text for the error box . Error box is displayed when the user enters an invalid value int o a cell which belongs to this validation object . In order for an error box to be displayed you should also use method setShowErrorBox( boolean show )
        Specified by:
        createErrorBox in interface DataValidation
        Parameters:
        title - The error box's title
        text - The error box's text