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

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

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Done
    • Icon: Normal Normal
    • 3.7.0
    • 3.6.0
    • 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.

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

              Created:
              Updated:
              Resolved: