https://bz.apache.org/bugzilla/show_bug.cgi?id=63999
Bug ID: 63999
Summary: Data validations that references another sheet don't
appear correctly
Product: POI
Version: 4.1.1-FINAL
Hardware: PC
OS: Mac OS X 10.1
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 36915
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36915&action=edit
Small sample workbook showing the error
Hi,
This is my first bug filed with Apache POI so apologies in advance if I fail to
follow any standard procedure.
When loading a workbook that contains a data validation with a direct reference
to another sheet, the validation does not appear in POI. (Direct, being it's
specified directly in the validation, versus using a defined name for the data
range, which works fine)
Pseudo code:
wb = WorkbookFactory.create(new FileInputStream(new File("test.xlsx")))
sheet = wb.getSheetAt(wb.getActiveSheetIndex)
validations = sheet.getDataValidations()
In the sample document (attached) there are three validations for cells A1,A2
and A3
A1 references another sheet using a defined name.
A2 references another sheet directly
and
A3 references a range in the same sheet.
When loading the workbook in POI 4.1.1, The A1 and A3 validations show up, but
no sign of A2.
--
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]
