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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 5.5.0
    • Fix Version/s: 5.6.0
    • Component/s: None
    • Security Level: Jimmy
    • Labels:
      None

      Description

      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

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: