[Bug 54662] New: HSSFDataValidation message size limit

[bu...@apache.org]

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: dev@poi.apache.org
          Reporter: igdevaal@hotmail.com
    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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org