Framework:SetCellStyle: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
Created page with "==Function== SetCellStyle(<Condition>,<Expression>,<Style>); {| cellspacing="1" cellpadding="3" width={{{breite|80%}}} border="1" |- | style=backgrou..." |
No edit summary |
||
| Line 4: | Line 4: | ||
{| | {| class="wikitable" width="80%" | ||
|- | |-{{Tabellentitel}} | ||
| | | Parameter | ||
| | | Description | ||
|- | |- | ||
|Condition | |Condition | ||
Revision as of 10:05, 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);
