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

Cut Formula shouldn't be shifted when it is not in cut range

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 3.5.0 RC
    • Fix Version/s: 3.5.0
    • Component/s: ZSS Range & Model
    • Labels:
      None

      Description

      In put C3 value =A1, D3 value = B2
      cut and paste B2 : D3 to E2,
      F3 should be =A1, but G3 should change to =E2

        Activity

        dennis dennis created issue -
        dennis dennis made changes -
        Field Original Value New Value
        Description In put A1 value =C1
        cut and paste A1 to A2, it's formula should remain =C1, not C2
        In put C3 value =A1, D3 value = B2
        cut and paste B2:D3 to E2,
        F3 should be =A1, but G3 should change to =E2
        dennis dennis made changes -
        Summary Formula shouldn't be shifted when cut. Cut Formula shouldn't be shifted when it is not in cut range
        Description In put C3 value =A1, D3 value = B2
        cut and paste B2:D3 to E2,
        F3 should be =A1, but G3 should change to =E2
        In put C3 value =A1, D3 value = B2
        cut and paste B2 : D3 to E2,
        F3 should be =A1, but G3 should change to =E2
        Hide
        dennis dennis added a comment -

        fixed since 2014/4/3.
        currently, if you cut cross a sheet, the outer formula will not append the original sheet name automatically.
        for example, if you cut and paste to Sheet2!E2, F3's formula will not append "Sheet1" automatically.

        Show
        dennis dennis added a comment - fixed since 2014/4/3. currently, if you cut cross a sheet, the outer formula will not append the original sheet name automatically. for example, if you cut and paste to Sheet2!E2, F3's formula will not append "Sheet1" automatically.
        dennis dennis made changes -
        Status Open [ 1 ] Closed [ 6 ]
        Fix Version/s 3.5.0 RC [ 12602 ]
        Resolution Fixed [ 1 ]
        dennis dennis made changes -
        Fix Version/s 3.5.0 [ 12609 ]
        Fix Version/s 3.5.0 RC [ 12602 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved: