Framework:SetCellStyle: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
mNo edit summary |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==[[Framework:Functions|Function]]== | ==[[Framework:Functions|Function]]== | ||
SetCellStyle(<Condition>,<Expression>,<Style>); | <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== | ||
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> | ||
| Line 39: | Line 41: | ||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Functions|SetCellStyle]] | |||
[[Category:Functions - client-side|SetCellStyle]] | [[Category:Functions - client-side|SetCellStyle]] | ||
[[de:Framework:SetCellStyle]] | [[de:Framework:SetCellStyle]] | ||
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);
