Affects Version/s: None
Fix Version/s: 5.9.0
Security Level: Jimmy
Run attached excel file in keikai
Go to sheet1 B2, it has a validation dropdown (list from Sheet1!A4:A6)
Go to sheet2 B2, it has a validation dropdown (list from Sheet1!A4:A6)
Sheet1 validation list works
Sheet2 validation list is not found
Validation lists are found in both cases
XslxExtractor is unable to load validations that contain a reference to a different sheet:
Doesn't find the sheet2 validation
Excel stores normal validations in:
Excel stores validations referencing a different sheet in
Declare the target range as a named range, then use that named range as the datasource for the validation list.
Named ranges do not cause the validation to be stored in the extList event if they reference a different sheet.