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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.6.0
    • 3.6.0
    • 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.

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

              Created:
              Updated:
              Resolved: