DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=44304>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=44304 Summary: How to use the String with comma seperated as Data Validation for Cell Product: POI Version: 3.0 Platform: Other OS/Version: Windows XP Status: NEW Severity: normal Priority: P1 Component: HSSF AssignedTo: [email protected] ReportedBy: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Please Provide the solution for giving the String having comma seperated list of words as the Data Validation for the Cell in Excel Sheet. I am working fine with the follwoing code String strFormula = "$A$10:$A$20"; int start_row = (short)0; 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(true); data_validation.setSurppressDropDownArrow(false); data_validation.setEmptyCellAllowed(false); data_validation.setShowPromptBox(false); data_validation.createErrorBox("Invalid input !", "Something is wrong ; check condition !"); data_validation.createPromptBox("Hi , dear user !", "So , you just selected me ! Thanks !"); fSheet.addValidationData(data_validation); BUT------------------ I need to pass the string having comma seperated , to validate the cell .... Thanks & Regards Lakshmi Narayana -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
