Framework:SetCellStyle: Difference between revisions

From CoPlanner 11
Jump to navigationJump to search
No edit summary
mNo edit summary
 
(One intermediate revision by one other user not shown)
Line 20: Line 20:


==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);