无法设置字体颜色。错误？ [英] 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屋！