[Libreoffice-bugs] [Bug 142065] New: EDITING: Cut paste transposed with formula reference within range leads to #REF

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142065

            Bug ID: 142065
           Summary: EDITING: Cut paste transposed with formula reference
                    within range leads to #REF
           Product: LibreOffice
           Version: 7.1.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: info at scito.ch

Description:
Cutting and transposing a range with formula reference within range leads to
#REF in pasted formula. However, copying and transposing works correctly.

Interestingly, cut and transpose, 1x undo 1x and 1x redo, then it works as well
correctly.

Steps to Reproduce:
1. Create new spread sheet.
2. Insert cells:
    A1: 1
    B1: =A1+10
3. Select A1 and B1
4. Cut
5. Go to cell A3
6. Paste

Actual Results:
Cell A4 shows #REF and contains =#REF!2+10

Expected Results:
Cell A4 shows 11 and contains =A3+10

(I.e. the same result as from copy and paste transposed is expected.)


Reproducible: Always


User Profile Reset: No



Additional Info:
I've discovered this bug while writing unit tests for bug 68976 and bug 71058.
Creating a bug report for QA.

Version: 7.1.1.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 4; OS: Linux 5.3; UI render: GL; VCL: kf5
Locale: de-CH (en_US.UTF-8); UI: de-DE
Calc: threaded

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: aa38eede9d340cbb11a792ab1ebbe681521a4489
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: x11
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210503/958020f1/attachment-0001.htm>