Support auto update for Cells refer other cells via INDIRECT() function

XMLWordPrintable

    • Type: New Feature
    • Resolution: Done
    • Priority: Normal
    • 3.7.0
    • Affects Version/s: 3.6.0
    • Component/s: None
    • None

      1. A1:A5 =

      {1, 2, 3, 4, 5}

      set as Name "item_1"
      2. B1 = "item 1"
      3. B2 = "=INDIRECT(=SUM(INDIRECT(SUBSTITUTE(B1," ", "_")))

      B2 value is 15

      Now change A1 to 11
      B2 value should be 25; but it is not.

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

              Created:
              Updated:
              Resolved: