[upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells
Bug #1388491 reported by
Koichi Akabe
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
High
|
|||
libreoffice (Ubuntu) |
Fix Released
|
High
|
Unassigned |
Bug Description
Step to reproduce:
1. Open the attached ods file.
2. Select I12 to L16 and cut this region (Ctrl+X). (This bug doesn't occur with copy)
3. Select I5 and open Paste Special dialog (Shift+Ctrl+V).
4. Enable "Transpose" option and Click "OK"
Then, values of some cells in C9 to E10, which are not related to blank cells are changed:
C9: =C3/SUM(C$3:C$6) -> K7/SUM(C$3:C$6)
D9: =D3/SUM(D$3:D$6) -> L7/SUM(D$3:D6)
E9: =E3/SUM(E$3:E$6) -> M7/SUM(E$3:E$6)
C10: =C4/SUM(C$3:C$6) -> K8/SUM(C$3:C$6)
D10: =D4/SUM(D$3:D$6) -> L8/SUM(D$3:D6)
E10: =E4/SUM(E$3:E$6) -> M8/SUM(E$3:E$6)
My environment is Ubuntu 14.04 LibreOffice 4.2.6.3
description: | updated |
summary: |
- calc: "Cut" and "Paste special" -> "Transport" effects other cells + calc: "Cut" and "Paste special" -> "Transpose" effects other cells |
description: | updated |
Changed in df-libreoffice: | |
importance: | Unknown → High |
status: | Unknown → Confirmed |
tags: | added: trusty |
summary: |
- [upstream] calc: "Cut" and "Paste special" -> "Transpose" effects other + [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells |
Changed in libreoffice (Ubuntu): | |
status: | Triaged → Incomplete |
Changed in df-libreoffice: | |
importance: | High → Unknown |
status: | Confirmed → Unknown |
Changed in libreoffice (Ubuntu): | |
status: | Incomplete → Triaged |
Changed in df-libreoffice: | |
importance: | Unknown → High |
status: | Unknown → Confirmed |
Changed in df-libreoffice: | |
status: | Confirmed → In Progress |
Changed in libreoffice (Ubuntu): | |
status: | Confirmed → Fix Committed |
Changed in df-libreoffice: | |
status: | In Progress → Fix Released |
Changed in libreoffice (Ubuntu): | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
I was working with the spreadsheets and noticed this little gem. The value in the formula with the anchored cells (e.g. $A$1) are updated when i cut and paste in unrelated rows.
Steps to reproduce:
Enter value 1234 in cell A1
Enter values 5,2,3 in cells A3, A4 and A5 respectively
Enter formula ($A$1-ABS(A3))*-1 in cell B3
Drag the formula to fill other 2 cells
Now you have values -1229, -1232 and -1231 in cells B3, B4 and B5
Enter values 2, 3, 4 in cells A7, B7 and C7
Select these cells and cut them.
Click on A7 cell
Paste special: Number and Transpose checked, Operations: None, Shift Cells: Don't shift
Values in cells B3, B4 and B5 change to 2, 0 and 1 respectively
Formulas are updated to ($A$7-ABS(A9))*-1, ($A$7-ABS(A4))*-1, ($A$7-ABS(A5))*-1 in those cells.
I am running opensuse 12.1 and official repository and Build ID: 350m1(Build:413)
This also happens on Windows OS