Incorrect validation error for a string contains a percentage symbol

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 3.7.0
    • Affects Version/s: 3.6.0
    • Component/s: 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.

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

              Created:
              Updated:
              Resolved: