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 [EMAIL PROTECTED] changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|[email protected] |[EMAIL PROTECTED] Status|NEW |ASSIGNED ------- Additional Comments From [EMAIL PROTECTED] 2008-01-27 23:51 ------- Created an attachment (id=21434) --> (http://issues.apache.org/bugzilla/attachment.cgi?id=21434&action=view) Please Help me- How to use POI for data validation with Source as String (having comma seperated strings) instead of formula Hi, Please Help me- How to use POI for dqatavalidation with Source as String (having comma seperated strings) instead of formula 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(false); 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); this is working fine,,,, but i want to pass the string as comma seperated as the SOURCE for data validation -- 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]
