40913_zh-TW

liliconcom

[腳本]如何添加顏色漸變

你好，

 

我被困在這裡，我想用顏色漸變來格式化我的列。 但是，使用下面的腳本，我的“N”列仍然沒有應用顏色漸變。 謝謝

 

 

 

 

R1=(dt<< 製表(
顯示控制面板（0），
顯示工具提示（ 1 ），
添加表格(
列表（統計（N）），
列表（分組列（：名稱（“test@7721”）），統計（行％，N）），
行表（分組列（：半徑））
)
)) << 製作成數據表；

R1<<列（
"N",
Set Property("Color Gradient",{"Blue to Green to Red", Range( {0, 547, 187.945945945946})}),
按值給單元格上色
);

回复：[腳本]如何添加顏色漸變

當你改變話題時，請開始新的討論。 謝謝！

回复：[腳本]如何添加顏色漸變

這是一種方法：

NamesDefaultToHere(1);

dt = NewTable("Test", << addMultipleColumns("N", 20, Numeric));

// Add some data
Wait(3);
cols = dt << getColumnNames("String");
for(c=1, c<=NItems(cols), c++,
 Column(dt, cols[c]) << Formula(RandomNormal());
);
dt << addRows(50);

// Add the colour gradient
Wait(3);
for(c=1, c<=NItems(cols), c++,
 Column(dt, cols[c]) << Set Property( "Color Gradient", {"Blue to Green to Red", Range( {0, 547, 188} )} ) << Color Cell by Value;
);

回复：[腳本]如何添加顏色漸變

你好，另一個問題：

 

目前我有 20 個“N”，有沒有辦法修改腳本，這樣我就不需要更改 20 個“N”

 

 

R1<SPAN class="token punctuation">:</SPAN>N <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN> Set Property<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Color Gradient"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token punctuation">{</SPAN><SPAN class="token string">"Blue to Green to Red"</SPAN><SPAN class="token punctuation">,</SPAN> Range<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">{</SPAN><SPAN class="token number">0</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">547</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">187.945945945946</SPAN><SPAN class="token punctuation">}</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">}</SPAN> <SPAN class="token punctuation">)</SPAN> 
     <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN> Color Cell by Value<SPAN class="token punctuation">;</SPAN>

 

R1<SPAN class="token punctuation">:</SPAN>N1 <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN> Set Property<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Color Gradient"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token punctuation">{</SPAN><SPAN class="token string">"Blue to Green to Red"</SPAN><SPAN class="token punctuation">,</SPAN> Range<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">{</SPAN><SPAN class="token number">0</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">547</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">187.945945945946</SPAN><SPAN class="token punctuation">}</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">}</SPAN> <SPAN class="token punctuation">)</SPAN> 
     <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN> Color Cell by Value<SPAN class="token punctuation">;</SPAN>

 

R1<SPAN class="token punctuation">:</SPAN>N2 <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN> Set Property<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Color Gradient"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token punctuation">{</SPAN><SPAN class="token string">"Blue to Green to Red"</SPAN><SPAN class="token punctuation">,</SPAN> Range<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">{</SPAN><SPAN class="token number">0</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">547</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">187.945945945946</SPAN><SPAN class="token punctuation">}</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">}</SPAN> <SPAN class="token punctuation">)</SPAN> 
     <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN> Color Cell by Value<SPAN class="token punctuation">;<BR /></SPAN>

R1<SPAN class="token punctuation">:</SPAN>N3 <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN> Set Property<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Color Gradient"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token punctuation">{</SPAN><SPAN class="token string">"Blue to Green to Red"</SPAN><SPAN class="token punctuation">,</SPAN> Range<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">{</SPAN><SPAN class="token number">0</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">547</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">187.945945945946</SPAN><SPAN class="token punctuation">}</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">}</SPAN> <SPAN class="token punctuation">)</SPAN> 
     <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN> Color Cell by Value<SPAN class="token punctuation">;</SPAN>

<SPAN class="token punctuation">&nbsp;</SPAN>

回复：[腳本]如何添加顏色漸變嗨 txnelson，
我從來沒想過這點。 非常感謝您提供的信息。 你幫了大忙回复：[腳本]如何添加顏色漸變

“Color Cell by Value”是一個單獨的消息，因此不需要作為 Color Gradient 屬性的一部分進行處理。

R1 = (dt << Tabulate(
 Show Control Panel( 0 ),
 Show Tooltip( 1 ),
 Add Table(
  Column Table( Statistics( N ) ),
  Column Table( Grouping Columns( :Name( "test@7721" ) ), Statistics( Row %, N ) ),
  Row Table( Grouping Columns( :Radius ) )
 )
)) << Make Into Data Table;
R1:N << Set Property( "Color Gradient", {"Blue to Green to Red", Range( {0, 547, 187.945945945946} )} ) 
     << Color Cell by Value;