-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Normal
-
Affects Version/s: 3.6.0
-
Component/s: None
-
Security Level: Jimmy
-
None
Steps to Reproduce
- load attached Excel file
- export to Excel file without modifying
- open it with Excel
- in D9, the validation input message is lost
- its validation type is "any" which is the same as a cell without validation.
Root Cause:
For current design, it doesn't export a validation with type "any" (refer to ExcelXlsxExporter.exportValidation()). Because it treats it as no validation specified.
Extra Information
Although current design is reasonable, it's a little inconsistency because zss imports a validation with "any" constraint type but doesn't export it.