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

a conditional formatting that references to a named range doesn't update

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 5.6.0
    • 5.5.0
    • None
    • Security Level: Jimmy
    • None

      Steps to Reproduce

      1. import the file
      2. select "source" sheet
      3. modify A2, A3 to the same value
      4. check the background color at conditional formatting!B3

      Current Result

      it's red

      Expected Result

      white

      Debug Information

      • Keikai displays the expected background initially but doesn't update after the referenced cell value change.
      • B3 contains conditional formatting that references cells with named ranges. Referencing a named range of another sheet is the only way to make conditional formatting reference to another sheet.

      Workaround

      modify B3 value and keikai will update the background-color

            RaymondChao RaymondChao
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: