To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=47892
Issue #:|47892
Summary:|setting font color with a recorded macro doesn't work
Component:|Spreadsheet
Version:|OOo 2.0 Beta
Platform:|PC
URL:|
OS/Version:|Windows XP
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|ui
Assigned to:|spreadsheet
Reported by:|jerryferguson
------- Additional comments from [EMAIL PROTECTED] Thu Apr 21 08:32:08 -0700
2005 -------
I ran the macro recorder to learn how to set the font color in my spreadsheet
and got the following code:
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 args2(0) as new com.sun.star.beans.PropertyValue
args2(0).Name = "Color"
args2(0).Value = 8388608
dispatcher.executeDispatch(document, ".uno:Color", "", 0, args2())
rem ----------------------------------------------------------------------
During the recording of the macro the text in the selected cell changed color as
requested. When I execute this macro in a different cell, nothing happens.
Using the same procedure for setting the cell background or turning the text to
bold works just fine while trying to center the text fails.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
