[Libreoffice-bugs] [Bug 142201] New: EDITING: Cut paste transposed: formula references from wrong cells adjusted

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 142201
           Summary: EDITING: Cut paste transposed: formula references from
                    wrong cells adjusted
           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:
Formula references from wrong cells are adjusted after cut paste transposed.
Transposed location changes are not taken into account.

In version 7.1, it can only be reproduced if the cut cells start in A1 due to
bugs 68976, 71058. After these bugs have been fixed, it happens everywhere.

Technical background:
sc::RefUpdateResult ScTokenArray::AdjustReferenceOnMove() and
ScDocument::UpdateTranspose() are responsible for adjusting cell references for
cut and paste transposed. Location change due to transpose has to be taken into
account as well.

Steps to Reproduce:
1. Open an empty Calc spreadsheet.
2. Enter
    A1: 1
    B1: 11
    A2: 2
    B2: 12

    A4: =$A$1
    B4: =$B$1
    A5: =$A$2
    B5: =$B$2

    D4: 1
    E4: 11
    D5: 2
    E5: 12

3. Select A1:A2
4. Cut
5. Go to cell A7
6. Context menu > Special Paste > Special Paste > Transpose button

Actual Results:
i) LibreOffice 7.1.2.2:
A4: =$A$7 (value: 1)
B4: =$B$7 (value: 2)    <- wrong
A5: =$A$2 (value: 0)    <- wrong (bug 71058)
B5: =$B$2 (value: 12)

Displayed values changed

ii) LibreOffice 7.2 alpha (after fixing bug 71058):
A4: =$A$7 (value: 1)
B4: =$B$7 (value: 2)    <- wrong
A5: =$A$2 (value: 2)
B5: =$B$2 (value: 12)

Displayed values changed

Expected Results:
A4: =$A$7 (value: 1)    <- changed reference
B4: =$B$2 (value: 11)
A5: =$B$7 (value: 2)    <- changed reference
B5: =$B$2 (value: 12)

Displayed values stay the same, only 2 references change


Reproducible: Always


User Profile Reset: No



Additional Info:
I've discovered this bug while fixing and testing bugs 68976, 71058, 142065.

I document this bug 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: 4cc8406abaf8acd5dc2bdba8d46d6c3c44fbc985
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: x11
Locale: de-CH (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/20210510/bb0f125d/attachment-0001.htm>