excel - NPOI - Reading Data Validation for sheet returns empty set if lone validation is a formula to another sheet

Question

Reading Data Validation for sheet returns empty set if validation is a formula to another sheet.

Mainly, I have

My code is as follows:

IWorkbook workbook = WorkbookFactory.Create(@"test.xlsx");
ISheet sheet = workbook.GetSheetAt(0);
var dvs = sheet.GetDataValidations();

At runtime, dvs is empty (count is 0). If I do the exact same thing within the same sheet, all works fine.

question from:https://stackoverflow.com/questions/65650355/npoi-reading-data-validation-for-sheet-returns-empty-set-if-lone-validation-is

Answer 1

Waitting for answers