-
Bug
-
Resolution: Fixed
-
Normal
-
3.6.0
-
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.