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