[Libreoffice-bugs] [Bug 126058] No inner borders after replaying a recorded macro
https://bugs.documentfoundation.org/show_bug.cgi?id=126058
--- Comment #5 from Igor ---
No, it doesn't work. Can't set the vertical inner border double line. 2-columns
range is previously selected.
Sub SetBorderInnerVertical()
Dim document As Object
Dim dispatcher As Object
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
Dim args(4) as new com.sun.star.beans.PropertyValue
args(0).Name = "BorderInner.Horizontal"
args(0).Value = Array(0, 0, 0, 0, 0, 0)
args(1).Name = "BorderInner.Vertical"
args(1).Value = Array(0, 18, 18, 4, 15, 2)
args(2).Name = "BorderInner.Flags"
args(2).Value = 2
args(3).Name = "BorderInner.ValidFlags"
args(3).Value = 127
args(4).Name = "BorderInner.DefaultDistance"
args(4).Value = 0
dispatcher.executeDispatch(document, ".uno:BorderInner", "", 0, args())
End Sub
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 126058] No inner borders after replaying a recorded macro
https://bugs.documentfoundation.org/show_bug.cgi?id=126058 --- Comment #3 from b. --- pls. look at: https://ask.libreoffice.org/en/question/253532/calc-setting-borders-via-a-macro/?comment=253617#post-id-253617 the OP there found a solution, citation: 1 'The clue I had been missing was the use of the Table2 and Border2 objects rather than the more obvious Table and Border objects.' recorded macros are often not 'perfect', but a base to build own solutions, together with above solution i'd close as 'wfm' if nobody objects. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126058] No inner borders after replaying a recorded macro
https://bugs.documentfoundation.org/show_bug.cgi?id=126058 b. changed: What|Removed |Added CC||newbie...@gmx.de --- Comment #2 from b. --- repro, additional observation, if you select different styles for the borders (outer, didn't test inner as they are omitted anyway) the macro applies only on of them ... see also: https://ask.libreoffice.org/en/question/253532/calc-setting-borders-via-a-macro/?comment=253617#post-id-253617 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126058] No inner borders after replaying a recorded macro
https://bugs.documentfoundation.org/show_bug.cgi?id=126058 raal changed: What|Removed |Added Blocks||64314 CC||r...@post.cz Ever confirmed|0 |1 Version|6.2.4.2 release |4.2.0.4 release Status|UNCONFIRMED |NEW Whiteboard| QA:needsComment| --- Comment #1 from raal --- confirm with Version: 6.4.0.0.alpha0+ Build ID: 63889d3d465e9b4292dd5bb630bd3394494c8a6d CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=64314 [Bug 64314] [META] Macro recording issues -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126058] No inner borders after replaying a recorded macro
https://bugs.documentfoundation.org/show_bug.cgi?id=126058 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
