ZSS doesn't update formula's cell reference of different sheet after renaming

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 3.6.0
    • Affects Version/s: 3.6.0
    • Component/s: None
    • None

      Step to Reproduce

      1. load attached xlsx file in 3.6.0.FL.20140930-Eval
      2. check content of B1 in Sheet2, it should be "=Sheet1!B1"
      3. rename "Sheet1" to "St1"
      4. insert a row in row 1

      Actual Result

      B1 in sheet2 still contain "=St1!B1". It should be shifted.
      formula in the same sheet is shifted.

      Expected Result

      B1 in sheet2 should contain "=St1!B2".

      Debug information:

      zss 3.5.0 doesn't have this issue.
      If we don't rename sheet 1, this issue doesn't happen.

        1. refUpdate.xlsx
          8 kB

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

              Created:
              Updated:
              Resolved: