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

Formula should change sheet name if reordered sheet goes beyond its the formula's sheet boundary.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.7.0
    • None
    • None
    • None

      =SUM(Sheet2:Sheet5!A1)

      1. Move Sheet2 to be after Sheet5, formula should become =SUM(Sheet3:Sheet5)
      2. Move Sheet5 to be before Sheet3, formula should become =SUM(Sheet3:Sheet4)

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

              Created:
              Updated:
              Resolved: