无法设置字体颜色。错误? [英] Can't set font color. Bug?
问题描述
我这样做:
range.Font.ThemeColor = XlThemeColor.xlThemeColorDark1;
range.Font.TintAndShade = -0.5;
但是,字体颜色变为白色(不是灰色,按预期)。并且 TintAndShade在分配后立即为零。想法?
However, font color becomes white (not gray, as intended). And TintAndShade is zero immediately after assignment. Ideas?
推荐答案
<我可以确认这个错误。以下常量在类型库中定义:
I can confirm the bug. The following constants are defined in the type library:
Const xlThemeColorDark1 = 1
Const xlThemeColorLight1 = 2
Const xlThemeColorDark2 = 3 < br $>
Const xlThemeColorLight2 = 4
Const xlThemeColorAccent1 = 5
Const xlThemeColorAccent2 = 6
Const xlThemeColorAccent3 = 7
Const xlThemeColorAccent4 = 8
Const xlThemeColorAccent5 = 9
Const xlThemeColorAccent6 = 10
Const xlThemeColorHyperlink = 11
Const xlThemeColorFollowedHyperlink = 12
Const xlThemeColorDark1 = 1
Const xlThemeColorLight1 = 2
Const xlThemeColorDark2 = 3
Const xlThemeColorLight2 = 4
Const xlThemeColorAccent1 = 5
Const xlThemeColorAccent2 = 6
Const xlThemeColorAccent3 = 7
Const xlThemeColorAccent4 = 8
Const xlThemeColorAccent5 = 9
Const xlThemeColorAccent6 = 10
Const xlThemeColorHyperlink = 11
Const xlThemeColorFollowedHyperlink = 12
以下赋值按预期工作:
Const xlThemeColorLight1 = 1
Const xlThemeColorDark1 = 2 b
Const xlThemeColorLight2 = 3
Const xlThemeColorDark2 = 4
Const xlThemeColorLight1 = 1
Const xlThemeColorDark1 = 2
Const xlThemeColorLight2 = 3
Const xlThemeColorDark2 = 4
TinteAndShade仅适用于形状:
TinteAndShade only works for shapes:
ActiveSheet.Shapes(1).TextFrame.Characters.Font.TintAndShade = -0.5
ActiveSheet.Shapes(1).TextFrame.Characters.Font.TintAndShade = -0.5
这篇关于无法设置字体颜色。错误?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!