Hi,
I am trying to use HSSFDataValidation to generate lists in my workbook
dynamically. The drop-down is populated correctly when i use cell/area
references that are within the same sheet. But if i use a formula that
contains another sheet name - e.g. "sheet2!$a$1:$a$10" , then the drop
down doesn't work.
Following is the code snippet that I am using:
String strFormula = "metadata!$A$1:$A$10";
int start_row = (short)0;
HSSFDataValidation data_validation = new
HSSFDataValidation((short)(start_row),(short)0,(short)(start_row),(short)0);
data_validation.setDataValidationType(HSSFDataValidation.DATA_TYPE_LIST);
data_validation.setFirstFormula(strFormula);
data_validation.setSecondFormula(null);
data_validation.setExplicitListFormula(false);
data_validation.setSurppressDropDownArrow(false);
data_validation.setEmptyCellAllowed(false);
data_validation.setShowPromptBox(false);
data_validation.createErrorBox("Invalid input !", "Something is
wrong ; check condition !");
first_sheet.addValidationData(data_validation);
Can anyone please help me on this?
Thanks.
--
View this message in context:
http://www.nabble.com/query-regarding-HSSFDataValidation-tp18706750p18706750.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
