Framework:SetCellStyle

From CoPlanner 11
Revision as of 16:32, 18 November 2010 by Admin (talk | contribs) (Created page with "==Function== SetCellStyle(<Condition>,<Expression>,<Style>); {| cellspacing="1" cellpadding="3" width={{{breite|80%}}} border="1" |- | style=backgrou...")

(diff) ← Older revision | Approved revision (diff) | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

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