insert a row turns a whole column address into a absolute address

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 3.9.6
    • Affects Version/s: 3.9.5
    • Component/s: None
    • Security Level: Jimmy
    • None

      Steps to Reproduce

      1. load the attached file
      2. check C1 is =SUM(A:B)
      3. inert a row at row 2

      Current Result

      C1 now is =SUM(A$1:B$65537)

      Expected Result

      C1 is still =SUM(A:B)

        1. zss-1411.xlsx
          9 kB

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

              Created:
              Updated:
              Resolved: