Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-685

Keikai Match() formula causes class cast exception if searching a double in an array that contains numbers and strings

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 6.0.0
    • 5.12.2
    • None
    • Security Level: Jimmy
    • None
    • None

      Steps to Reproduce

      run attached repro.xlsx

      Current Result

      Cell A2 returns "error"

      Expected Result

      Cell A2 returns "3"

      Debug Information

      org.zkoss.poi.ss.formula.SortedValues.searchLessThanOrEqual(double, int, int)
      tries to read from a map<String, ...> with a Double as searched value.
      Causes ClassCastException

      Workaround

      Attached replacement SortedValues class

        1. repro.xlsx
          9 kB
        2. SortedValues.java
          5 kB

            DevChu DevChu
            MDuchemin MDuchemin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: