/* ====================================================================
   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.
==================================================================== */
package org.apache.poi.ss.usermodel;

import org.apache.poi.ss.util.CellRangeAddressList;


public interface DataValidation {
	
Error style constants for error box
/** * Error style constants for error box */
public static final class ErrorStyle {
STOP style
/** STOP style */
public static final int STOP = 0x00;
WARNING style
/** WARNING style */
public static final int WARNING = 0x01;
INFO style
/** INFO style */
public static final int INFO = 0x02; } public abstract DataValidationConstraint getValidationConstraint();
Sets the error style for error box
See Also:
  • ErrorStyle
/** * Sets the error style for error box * @see ErrorStyle */
public abstract void setErrorStyle(int error_style);
o
See Also:
Returns:the error style of error box
/**o * @return the error style of error box * @see ErrorStyle */
public abstract int getErrorStyle();
Sets if this object allows empty as a valid value
Params:
  • allowed – true if this object should treats empty as valid value , false otherwise
/** * Sets if this object allows empty as a valid value * * @param allowed <code>true</code> if this object should treats empty as valid value , <code>false</code> * otherwise */
public abstract void setEmptyCellAllowed(boolean allowed);
Retrieve the settings for empty cells allowed
Returns:True if this object should treats empty as valid value , false otherwise
/** * Retrieve the settings for empty cells allowed * * @return True if this object should treats empty as valid value , false * otherwise */
public abstract boolean getEmptyCellAllowed();
Useful for list validation objects .
Params:
  • 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
/** * Useful for list validation objects . * * @param 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 */
public abstract void setSuppressDropDownArrow(boolean suppress);
Useful only list validation objects . This method always returns false if the object isn't a list validation object
Returns:true if a list should display the values into a drop down list , false otherwise .
/** * Useful only list validation objects . This method always returns false if * the object isn't a list validation object * * @return <code>true</code> if a list should display the values into a drop down list , * <code>false</code> otherwise . */
public abstract boolean getSuppressDropDownArrow();
Sets the behaviour when a cell which belongs to this object is selected
Params:
  • show – true if an prompt box should be displayed , false otherwise
/** * Sets the behaviour when a cell which belongs to this object is selected * * @param show <code>true</code> if an prompt box should be displayed , <code>false</code> otherwise */
public abstract void setShowPromptBox(boolean show);
Returns:true if an prompt box should be displayed , false otherwise
/** * @return <code>true</code> if an prompt box should be displayed , <code>false</code> otherwise */
public abstract boolean getShowPromptBox();
Sets the behaviour when an invalid value is entered
Params:
  • show – true if an error box should be displayed , false otherwise
/** * Sets the behaviour when an invalid value is entered * * @param show <code>true</code> if an error box should be displayed , <code>false</code> otherwise */
public abstract void setShowErrorBox(boolean show);
Returns:true if an error box should be displayed , false otherwise
/** * @return <code>true</code> if an error box should be displayed , <code>false</code> otherwise */
public abstract boolean getShowErrorBox();
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 )
Params:
  • title – The prompt box's title
  • text – The prompt box's text
/** * 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 ) * * @param title The prompt box's title * @param text The prompt box's text */
public abstract void createPromptBox(String title, String text);
Returns:Prompt box's title or null
/** * @return Prompt box's title or <code>null</code> */
public abstract String getPromptBoxTitle();
Returns:Prompt box's text or null
/** * @return Prompt box's text or <code>null</code> */
public abstract String getPromptBoxText();
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 )
Params:
  • title – The error box's title
  • text – The error box's text
/** * 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 ) * * @param title The error box's title * @param text The error box's text */
public abstract void createErrorBox(String title, String text);
Returns:Error box's title or null
/** * @return Error box's title or <code>null</code> */
public abstract String getErrorBoxTitle();
Returns:Error box's text or null
/** * @return Error box's text or <code>null</code> */
public abstract String getErrorBoxText(); public abstract CellRangeAddressList getRegions(); }