Hi all,
I'm having the following problem that the error box is not showing whenever
i pass the name of a list into a createFormulaListConstraint().....
What i'm expecting is that the errorbox will pop-up whenever the user inputs
anything in the cell that does not make part of the list passed as an
argument. btw i'm using POI 3.9 and the following is my code:
Name mgkName = dctmWorkSheet.getWorkbook().createName();
mgkName.setSheetIndex(1);
mgkName.setNameName(cell.getStringCellValue());
mgkName.setRefersToFormula(getRangeRefersToFormula(valueAssSheet,
firstRow, rowIndex, insertCol));
Name mgkName2 = dctmWorkSheet.getWorkbook().createName();
mgkName2.setSheetIndex(0);
mgkName2.setNameName(mgkName.getNameName());
mgkName2.setRefersToFormula(mgkName.getRefersToFormula());
validationHelper = dctmWorkSheet.getDataValidationHelper();
constraint =
validationHelper.createFormulaListConstraint(mgkName2.getNameName());
dataValidation = validationHelper.createValidation(constraint,
cral);
dataValidation.setSuppressDropDownArrow(false);
dataValidation.setEmptyCellAllowed(true);
dataValidation.setShowErrorBox(true);
dataValidation.setErrorStyle(DataValidation.ErrorStyle.STOP);
dataValidation.createErrorBox("Error", "Please use Pick List
Value");
dctmWorkSheet.addValidationData(dataValidation);
Thanks in advance for any assistance given.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/DataValidation-errorBox-not-showing-tp5713221.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
