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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.9.6
    • 3.9.5
    • 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
          hawk

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

              Created:
              Updated:
              Resolved: