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

conditional formatting triggers on formula errors

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.9.2
    • 3.9.1
    • ZSS Formula
    • Security Level: Jimmy

      Steps to Reproduce

      run the attached file

      Current Result

      the cells A6 B6 are incorrectly styled with their conditional styling even though the match-formula referencing a non existing sheet fails to evaluate

      Expected Result

      the conditional styles should not apply in case of formula errors

      Debug Info

      This only happens with negative operators
      "Not Equal", "Not Contains", "Greater Than Or Equal", "Less Than Or Equal"

      Root Cause

      the negation is applied after the formula evaluation - negating also errors results into "true" leading to styles being applied in case of errors

      https://github.com/zkoss/zkspreadsheet/blob/3.9.1/zssmodel/src/org/zkoss/zss/range/impl/CellMatch2.java#L100-L101

            henrichen henrichen
            cor3000 cor3000
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: