[Bug 56599] getDataValidations does not return dataValidations referring to different sheets.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[Bug 56599] getDataValidations does not return dataValidations referring to different sheets.

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=56599

--- Comment #1 from [hidden email] ---
This problem still exists. I looked inside the .xlsx file internals and noticed
that data validations refering to other sheets are stored at a different place.

If you call XSSFSheet.getDataValidations(), the data validations will be
extracted from CTWorksheet.getDataValidations(). But the data validations
refering to other sheets are stored in CTWorksheet.getExtList(), which cannot
be accessed by POI users.

In general it would be great if there would be a possibility to support these
type of data validations.

I also think that at the moment such data validations are stored at the wrong
place if you create it directly with POI.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]