Bug 46943

Summary: No display PromptBox in msExcel
Product: POI Reporter: Alcides Sánchez <alcidesmanos>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED WONTFIX    
Severity: normal    
Priority: P2    
Version: 3.5-dev   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   

Description Alcides Sánchez 2009-03-31 07:00:00 UTC
DVConstraint dataValidation = null;
CellRangeAddressList region = new CellRangeAddressList(1, 10,
1, 10);
dataValidation = DVConstraint.createNumericConstraint(
ValidationType.DECIMAL, OperatorType.BETWEEN, String.valueOf (-Double.MAX_VALUE),  String
.valueOf(Double.MAX_VALUE));
			
			HSSFDataValidation ret = new HSSFDataValidation(region, dataValidation);
			ret.createPromptBox("Escriba un numero en esta casilla",
					"");
			ret.createErrorBox("Error de tipo de dato", "Se espera!!!");
			ret.setShowPromptBox(true);
			ret.setShowErrorBox(true);
			currentSheet
			.addValidationData(ret);
			
			
			FileOutputStream fo= new FileOutputStream("excel.xls");
			me.save(fo);
			fo.close();
Comment 1 Dominik Stadler 2015-05-18 20:26:00 UTC
Sorry, but I could not find out what this quite old bug report is actually about and I am not sure if it is still an issue. 

Therefore I am closing this as WONTFIX for now. 

If this is still an issue for you with the latest version of POI, then please reopen this bug with more information, ideally a self-sufficient unit test as the code provided currently does not run without modifications and it is not clear to me what problem it should show.