Hi,
Did you find any solution for the issue. I am facing the same problem. I
am using 3.1 final version of apache poi api which is the latest release.
But I still have the issue.
Thanks in Advance
mbhatt wrote:
>
> 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-tp18706750p19190204.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]
