DataValidation errorBox not showing

[mgk <mg...@gmail.com>]

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org