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

Incorrect validation error for a string contains a percentage symbol

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.7.0
    • 3.6.0
    • None
    • None

      Steps to Reproduce

      1. load attached zul with blank.xlsx
      2. select "8%" on A1

      Actual Result

      "Validation Error" message shows up.
      If you select "8 %" on B1, no error shows.

      Initial Diagnosis

      In DataValidationHelper.validateListOperation(), input is converted to a double, but validation list are all string. So validation fails.

      Debug Information

      Excel will keep double quote to keep the input text as a string. You can see listValidation-cellType.xlsx.

        1. Excel-DataValidation.png
          7 kB
          hawk
        2. listValidation-cellType.png
          12 kB
          hawk
        3. listValidation-cellType.xlsx
          8 kB
          hawk
        4. validation-percentage.zul
          1 kB
          hawk

            henrichen henrichen
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: