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

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 3.7.0
    • Affects Version/s: None
    • Component/s: 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)

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

              Created:
              Updated:
              Resolved: