https://bugs.freedesktop.org/show_bug.cgi?id=44383
Bug #: 44383
Summary: cut plus paste special with move cells incorrectly
updates formulas
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.4 release
Platform: Other
OS/Version: All
Status: NEW
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 55043
--> https://bugs.freedesktop.org/attachment.cgi?id=55043
document to illustrate the described problem
This bug is a bit difficult to show because of bug 42265, but can be reproduced
by using a macro that bypasses the problem of bug 42265.
-use the simple document that I have attached;
-select columns D,E,F;
-cut;
-select cell A1;
-use paste special with 'move cells to right' or use following basic macro with
the following code to bypass the disabled option problem:
sub insCol
dim document as object
dim dispatcher as object
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
dim args2(5) as new com.sun.star.beans.PropertyValue
args2(0).Name = "Flags"
args2(0).Value = "A"
args2(1).Name = "FormulaCommand"
args2(1).Value = 0
args2(2).Name = "SkipEmptyCells"
args2(2).Value = false
args2(3).Name = "Transpose"
args2(3).Value = false
args2(4).Name = "AsLink"
args2(4).Value = false
args2(5).Name = "MoveMode"
args2(5).Value = 1
dispatcher.executeDispatch(document, ".uno:InsertContents", "", 0, args2())
end sub 'insCol
-note that the formulas that were in C1 and C2 and are now in F1 and F2 no
longer produce the sum of the two cells to their left.
Bug is also present in master, and occurs with Windows and with Linux.
I suspect a connection with bugs 42261 and 27987 as these also report problems
after inserting/delting/moving columns/rows.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
