FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > ConditionalFormat Class : LastConditionExpression Property |
'Declaration Public Property LastConditionExpression As Expression
'Usage Dim instance As ConditionalFormat Dim value As Expression instance.LastConditionExpression = value value = instance.LastConditionExpression
public Expression LastConditionExpression {get; set;}
FarPoint.Win.Spread.NamedStyle above = new FarPoint.Win.Spread.NamedStyle(); FarPoint.Win.Spread.NamedStyle below = new FarPoint.Win.Spread.NamedStyle(); above.BackColor = Color.Red; below.BackColor = Color.Yellow; FarPoint.CalcEngine.Expression one; FarPoint.CalcEngine.Expression two; FarPoint.CalcEngine.Expression oneplustwo; one = new FarPoint.CalcEngine.DoubleExpression(100.0); two = new FarPoint.CalcEngine.DoubleExpression(20.0); oneplustwo = new FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, one, two); fpSpread1.ActiveSheet.SetExpression(1, 1, oneplustwo); fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, above, FarPoint.Win.Spread.ComparisonOperator.GreaterThan, one, two); fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, below, FarPoint.Win.Spread.ComparisonOperator.LessThan, one, two); FarPoint.Win.Spread.ConditionalFormat[]cf; cf = fpSpread1.ActiveSheet.GetConditionalFormats(1, 1); foreach (FarPoint.Win.Spread.ConditionalFormat item in cf) { MessageBox.Show(item.LastConditionExpression.ToString()); }
Dim above As New FarPoint.Win.Spread.NamedStyle Dim below As New FarPoint.Win.Spread.NamedStyle above.BackColor = Color.Red below.BackColor = Color.Yellow Dim one As FarPoint.CalcEngine.Expression Dim two As FarPoint.CalcEngine.Expression Dim oneplustwo As FarPoint.CalcEngine.Expression one = New FarPoint.CalcEngine.DoubleExpression(100.0) two = New FarPoint.CalcEngine.DoubleExpression(20.0) oneplustwo = New FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, one, two) FpSpread1.ActiveSheet.SetExpression(1, 1, oneplustwo) Dim co As New FarPoint.Win.Spread.ComparisonOperator FpSpread1.ActiveSheet.SetConditionalFormat(1, 1, above, co.GreaterThan, one, two) FpSpread1.ActiveSheet.SetConditionalFormat(1, 1, below, co.LessThan, one, two) Dim cf As FarPoint.Win.Spread.ConditionalFormat() Dim item As New FarPoint.Win.Spread.ConditionalFormat cf = FpSpread1.ActiveSheet.GetConditionalFormats(1, 1) For Each item In cf MessageBox.Show(item.LastConditionExpression.ToString()) Next
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8