You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2009/03/31 16:00:03 UTC

DO NOT REPLY [Bug 46943] New: No display PromptBox in msExcel

https://issues.apache.org/bugzilla/show_bug.cgi?id=46943

           Summary: No display PromptBox in msExcel
           Product: POI
           Version: 3.5-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: alcidesmanos@gmail.com


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();

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org