Framework:SetCellStyle: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
mNo edit summary |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
<span {{CoPFormel}}>SetCellStyle(<Condition>,<Expression>,<Style>);</span> | <span {{CoPFormel}}>SetCellStyle(<Condition>,<Expression>,<Style>);</span> | ||
{| class="wikitable" width="80%" | {| class="wikitable" width="80%" | ||
| Line 18: | Line 17: | ||
|Style to be used. | |Style to be used. | ||
|} | |} | ||
This function belongs to [[:Category:Functions_-_client-side|client-side functions]]. | |||
==Result== | ==Result== | ||
Formatting a cell according to instructions contained in a format expression. | Formatting a cell according to instructions contained in a format expression. | ||
The function has to be defined in the SpecialDefinition section of the mask. | |||
==Example== | ==Example== | ||
Latest revision as of 11:44, 13 June 2022
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. |
This function belongs to client-side functions.
Result
Formatting a cell according to instructions contained in a format expression.
The function has to be defined in the SpecialDefinition section of the mask.
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);
