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

            Bug ID: 54662
           Summary: HSSFDataValidation message size limit
           Product: POI
           Version: 3.9
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
          Assignee: [email protected]
          Reporter: [email protected]
    Classification: Unclassified

When a message with a size longer than 255 is added to a cell data validation,
the workbook is corrupted.
This limit comes from an excel limitation.

CellRangeAddressList addressList = new CellRangeAddressList(firstRow, lastRow,
firstCol, lastCol);
DataValidation dataValidation = new HSSFDataValidation(addressList,
DVConstraint.createCustomFormulaConstraint("1=1"));dataValidation.createPromptBox(title,
message);

createPromptBox() should throw an IllegalArgumentException() in this case
explaining the reason

Similary a limit of 33 characters is imposed to "title" argument in ME

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to