Framework:SetCellStyle: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 39: | Line 39: | ||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Functions|SetCellStyle]] | |||
[[Category:Functions - client-side|SetCellStyle]] | [[Category:Functions - client-side|SetCellStyle]] | ||
[[de:Framework:SetCellStyle]] | [[de:Framework:SetCellStyle]] | ||
Revision as of 15:43, 23 May 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);