wood burning stoves*
The moose likes Other Open Source Projects and the fly likes POI - unable to create custom validation for a range of cells Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "POI - unable to create custom validation for a range of cells" Watch "POI - unable to create custom validation for a range of cells" New topic
Author

POI - unable to create custom validation for a range of cells

anish joseph
Greenhorn

Joined: May 16, 2007
Posts: 4
I need to check if the user has entered a valid number in a cells A1:A10. In Excel i would choose the cells, and then create a custom validator, and set the formula to =isNumber("$A$1:$A10") Trying do this using POI is getting me all tied in knots: Here is what i have tried:
CellRangeAddressList addressList = new CellRangeAddressList(0, 10, 0, 0);
XSSFDataValidationHelper dvHelper = new XSSFDataValidationHelper(sheet);
DataValidationConstraint customConstraint = dvHelper.createCustomConstraint("isNumber(\"$A$0:$A$10\"");
XSSFDataValidation validation = (XSSFDataValidation)dvHelper.createValidation(customConstraint, addressList);
validation.setShowErrorBox(true);
sheet.addValidationData(validation);

When i try and open this in Excel, i get an error, and Excel disables the validation

thanks in advance -anish
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: POI - unable to create custom validation for a range of cells
 
Similar Threads
Apache POI- HSSFDataValidation Formula Validation
inserting image in excel using POI api
messy decimal when reading from excel
Read Excel Sheet Using Java
Please help for this Problem in creating excel sheet using java