https://bugs.documentfoundation.org/show_bug.cgi?id=97424
Bug ID: 97424
Summary: Record macro does not work for "color scale" action
Product: LibreOffice
Version: 4.0.4.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
If I use the “record macro”, I get the following results for the color scale by
macro:
********************************************
sub colorscale
rem ----------------------------------------------------------------------
rem define variables
dim document as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem ----------------------------------------------------------------------
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "ToPoint"
args1(0).Value = "$C$3:$D$7"
dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())
rem ----------------------------------------------------------------------
rem dispatcher.executeDispatch(document, ".uno:ColorScaleFormatDialog", "", 0,
Array())
end sub
************************************************
=> Here however the 2nd and 3rd last lines have “rem” in front of the
dispatcher command and
if rems are removed the macro opens only the “dialog form” to make the color
scale rather
than making the color scale directly.
Intention is to find the macro commands that can make the “color scale”
conditional formatting.
— Jari
--
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
