Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bug in Comment.Shape.TextFrame.Characters.Font.Color in Excel 2007
Hi.
Ive found what seems to be a bug in the Comment.Shape.TextFrame.Characters.Font.Color. The ColorIndex works fine, but not the .Color. When setting the .Color with RGB() the result is simply wrong. There might be a pattern but I have not researched enough to find one. A simple test to confirm the bug is to set the Color and then read it back. Examples: Comment.Shape.TextFrame.Characters.Font.Color=RGB( 1,0,0) €˜becomes RGB(0,255,255) Comment.Shape.TextFrame.Characters.Font.Color=RGB( 65,0,0) €˜becomes RGB(128,128,128) Comment.Shape.TextFrame.Characters.Font.Color=RGB( 192,0,0) €˜becomes RGB(0,128,0) Regards, -Terry ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why can I no longer change Font colors in an Excel 2007 Comment? | Excel Discussion (Misc queries) | |||
Center text in a shape textframe | Excel Programming | |||
How to retrieve text from the textframe of an oval shape in Excel? | Excel Programming | |||
Interesting problem with VBA generated textbox (or textframe of shape) length | Excel Programming | |||
Hyperlink within the TextFrame of Shape Object..? | Excel Programming |