Bug 46943 - No display PromptBox in msExcel
Summary: No display PromptBox in msExcel
Status: RESOLVED WONTFIX
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.5-dev
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-03-31 07:00 UTC by Alcides Sánchez
Modified: 2015-05-18 20:26 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.