Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-835

if validation type is "any", its Input message will be lost when exporting


    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.7.0
    • 3.6.0
    • None
    • Security Level: Jimmy
    • None

      Steps to Reproduce

      1. load attached Excel file
      2. export to Excel file without modifying
      3. open it with Excel
      4. in D9, the validation input message is lost
        1. 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.

            henrichen henrichen
            hawk hawk
            0 Vote for this issue
            0 Start watching this issue