Please Help me- How to use POI for data validation with Source as String (having comma seperated strings) instead of formula

datavalid.txt (text/plain), 994 bytes, created by Lakshmi Narayana on 2008-01-27 23:51:00 UTC

(hide)

Description: Please Help me- How to use POI for data validation with Source as String (having comma seperated strings) instead of formula

Filename:

MIME Type:

Creator: Lakshmi Narayana

Created: 2008-01-27 23:51:00 UTC

Size: 994 bytes

patch

obsolete

>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 View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]