org.apache.poi.xssf.usermodel

Class XSSFDataValidationConstraint

java.lang.Object

org.apache.poi.xssf.usermodel.XSSFDataValidationConstraint

All Implemented Interfaces:

DataValidationConstraint

public class XSSFDataValidationConstraint
extends Object
implements DataValidationConstraint

Author:

Radhakrishnan J

Nested Class Summary

Nested classes/interfaces inherited from interface org.apache.poi.ss.usermodel.DataValidationConstraint

DataValidationConstraint.OperatorType, DataValidationConstraint.ValidationType

Constructor Summary

Constructors

Constructor and Description
XSSFDataValidationConstraint(int validationType, int operator, String formula1)
XSSFDataValidationConstraint(int validationType, int operator, String formula1, String formula2)
XSSFDataValidationConstraint(int validationType, String formula1)
XSSFDataValidationConstraint(String[] explicitListOfValues)

Method Summary

Methods

Modifier and Type	Method and Description
String[]	getExplicitListValues()
String	getFormula1()
String	getFormula2()
int	getOperator()
int	getValidationType()
protected boolean	isFormulaEmpty(String formula1)
String	prettyPrint()
protected String	removeLeadingEquals(String formula1)
void	setExplicitListValues(String[] explicitListValues)
void	setFormula1(String formula1)
void	setFormula2(String formula2)
void	setOperator(int operator)
void	validate()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

XSSFDataValidationConstraint

public XSSFDataValidationConstraint(String[] explicitListOfValues)

XSSFDataValidationConstraint

public XSSFDataValidationConstraint(int validationType,
                            String formula1)

XSSFDataValidationConstraint

public XSSFDataValidationConstraint(int validationType,
                            int operator,
                            String formula1)

XSSFDataValidationConstraint

public XSSFDataValidationConstraint(int validationType,
                            int operator,
                            String formula1,
                            String formula2)

Method Detail

getExplicitListValues

public String[] getExplicitListValues()

Specified by:

getExplicitListValues in interface DataValidationConstraint

getFormula1

public String getFormula1()

Specified by:

getFormula1 in interface DataValidationConstraint

getFormula2

public String getFormula2()

Specified by:

getFormula2 in interface DataValidationConstraint

getOperator

public int getOperator()

Specified by:

getOperator in interface DataValidationConstraint

getValidationType

public int getValidationType()

Specified by:

getValidationType in interface DataValidationConstraint

setExplicitListValues

public void setExplicitListValues(String[] explicitListValues)

Specified by:

setExplicitListValues in interface DataValidationConstraint

setFormula1

public void setFormula1(String formula1)

Specified by:

setFormula1 in interface DataValidationConstraint

removeLeadingEquals

protected String removeLeadingEquals(String formula1)

setFormula2

public void setFormula2(String formula2)

Specified by:

setFormula2 in interface DataValidationConstraint

setOperator

public void setOperator(int operator)

Specified by:

setOperator in interface DataValidationConstraint

validate

public void validate()

isFormulaEmpty

protected boolean isFormulaEmpty(String formula1)

prettyPrint

public String prettyPrint()