Hi,
No, this is still a bug that is existing in the 3.1 version. They haven't
fixed that yet.
Thanks.
AnuB wrote:
>
> 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-tp18706750p19194009.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]
