https://bugs.freedesktop.org/show_bug.cgi?id=68976
Priority: medium
Bug ID: 68976
Assignee: [email protected]
Summary: Formulas change after cut and paste action
Severity: critical
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.5 all versions
Component: Spreadsheet
Product: LibreOffice
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
