Hi,
I'm a newbie using poi version 3.0.2 and am having trouble with HSSFDataValidation. I was wondering if there is any example code that uses this functionality. I am not sure how to access the object from a cell. I create the HSSFDataValidation object like (pulled from a previous email in the dev-mailing list): String strFormula = "Lists!$A$1:$A$2"; HSSFDataValidation dval = new HSSFDataValidation((short)0,(short)0,(short)1,(short)0); dval.setDataValidationType(HSSFDataValidation.DATA_TYPE_LIST); dval.setFirstFormula(strFormula); dval.setExplicitListFormula(true); dval.setSurppressDropDownArrow(false); dval.setEmptyCellAllowed(true); dval.setShowPromptBox(false); sheet.addValidationData(dval); How can I place the data validation in a specific cell, say A3 if that row and cell have been created? If someone could help me out, it would be really appreciated.
