auto fill produces incorrect formulas when dragging multiple rows at once

XMLWordPrintable

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

      Steps to Reproduce

      1. load the attached xlsx
      2. select C2:C3
      3. drag 1 column to right with auto fill
      4. check formulas in D2:D3

      Current Result

      D2 is =B3
      D3 is =B2

      Expected Result

      D2 is =B2
      D3 is =B3

      Debug Information

      • if you drag 1 cell at one time, the resulting formula is correct.
      • caused by KEIKAI-515
      • if you select C2:C4, do the same steps, it also produce the wrong formula

        1. keikai-625.jpg
          keikai-625.jpg
          21 kB
        2. keikai-625.xlsx
          9 kB

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

              Created:
              Updated:
              Resolved: