Cross sheet DataValidation

Dec 10, 2016 at 8:29 AM
I'm trying to read the datavalidation of a cell using NPOI.

It works fine with a list of explicit values, or a range reference from the same sheet, but when the range reference is from another sheet, the method getDataValidations() doesn't return that specific data validation (although it return all the other ones).

I looked into the sheet xml, and it seems that the data validation that reference other sheets are not stored under the same xml tags they use <x14:dataValidation> instead of <dataValidation>. Is there a way to get all of them?

Nic