Framework:SetCellStyle: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
==[[Framework:Functions|Function]]== | ==[[Framework:Functions|Function]]== | ||
SetCellStyle(<Condition>,<Expression>,<Style>); | <span {{CoPFormel}}>SetCellStyle(<Condition>,<Expression>,<Style>);</span> | ||
| Line 23: | Line 23: | ||
==Example== | ==Example== | ||
SetCellStyle(UECond,GuV,style1);<br> | <span {{CoPFormel}}>SetCellStyle(UECond,GuV,style1);<br> | ||
SetCellStyle(GuV=631870768873600091 and Value0>=0,Value0,style1);<br> | SetCellStyle(GuV=631870768873600091 and Value0>=0,Value0,style1);<br> | ||
SetCellStyle(GuV=631870768873600091 and Value0<0,Value0,style1red);<br> | SetCellStyle(GuV=631870768873600091 and Value0<0,Value0,style1red);</span><br> | ||
'Level;<br> | 'Level;<br> | ||
SetCellStyle(GuV.Level=0 and Value0>=0,Value0,Level0);<br> | <span {{CoPFormel}}>SetCellStyle(GuV.Level=0 and Value0>=0,Value0,Level0);<br> | ||
SetCellStyle(GuV.Level=0 and Value0<0,Value0,Level0red);<br> | SetCellStyle(GuV.Level=0 and Value0<0,Value0,Level0red);</span><br> | ||
'Color dimension(left area);<br> | 'Color dimension(left area);<br> | ||
SetCellStyle(GuV.Level=0,GuV,Level0);<br> | <span {{CoPFormel}}>SetCellStyle(GuV.Level=0,GuV,Level0);<br> | ||
SetCellStyle(GuV.Level=1,GuV,Level1);<br> | SetCellStyle(GuV.Level=1,GuV,Level1);</span><br> | ||
Revision as of 16:10, 6 March 2012
Function
SetCellStyle(<Condition>,<Expression>,<Style>);
| Parameter | Description |
| Condition | Required. Expression. Must evaluate to True or False. |
| Expression | Statements that is executed |
| Style | Style to be used. |
Result
Formatting a cell according to instructions contained in a format expression.
Example
SetCellStyle(UECond,GuV,style1);
SetCellStyle(GuV=631870768873600091 and Value0>=0,Value0,style1);
SetCellStyle(GuV=631870768873600091 and Value0<0,Value0,style1red);
'Level;
SetCellStyle(GuV.Level=0 and Value0>=0,Value0,Level0);
SetCellStyle(GuV.Level=0 and Value0<0,Value0,Level0red);
'Color dimension(left area);
SetCellStyle(GuV.Level=0,GuV,Level0);
SetCellStyle(GuV.Level=1,GuV,Level1);
