HTML中condition属性,LastCondition 属性

此示例获取指定单元格的最后一个条件格式。FarPoint.Win.Spread.NamedStyle styleCold = new FarPoint.Win.Spread.NamedStyle();

FarPoint.Win.Spread.NamedStyle styleCool = new FarPoint.Win.Spread.NamedStyle();

FarPoint.Win.Spread.NamedStyle styleMild = new FarPoint.Win.Spread.NamedStyle();

FarPoint.Win.Spread.NamedStyle styleWarm = new FarPoint.Win.Spread.NamedStyle();

FarPoint.Win.Spread.NamedStyle styleHot = new FarPoint.Win.Spread.NamedStyle();

styleCold.BackColor = Color.Blue;

styleCold.ForeColor = Color.White;

styleCool.BackColor = Color.Cyan;

styleMild.BackColor = Color.Lime;

styleWarm.BackColor = Color.Yellow;

styleHot.BackColor = Color.Red;

fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCold, FarPoint.Win.Spread.ComparisonOperator.LessThan, "32");

fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCool, FarPoint.Win.Spread.ComparisonOperator.Between, "32", "55");

fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleMild, FarPoint.Win.Spread.ComparisonOperator.Between, "55", "75");

fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleWarm, FarPoint.Win.Spread.ComparisonOperator.Between, "75", "85");

fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleHot, FarPoint.Win.Spread.ComparisonOperator.GreaterThan, "85");

fpSpread1.ActiveSheet.Cells[1, 1].Value = 38;

FarPoint.Win.Spread.ConditionalFormat[]cf;

cf = fpSpread1.ActiveSheet.GetConditionalFormats(1, 1, false);

foreach (FarPoint.Win.Spread.ConditionalFormat item in cf)

{

MessageBox.Show(item.LastCondition.ToString());

}Dim styleCold As New FarPoint.Win.Spread.NamedStyle

Dim styleCool As New FarPoint.Win.Spread.NamedStyle

Dim styleMild As New FarPoint.Win.Spread.NamedStyle

Dim styleWarm As New FarPoint.Win.Spread.NamedStyle

Dim styleHot As New FarPoint.Win.Spread.NamedStyle

styleCold.BackColor = Color.Blue

styleCold.ForeColor = Color.White

styleCool.BackColor = Color.Cyan

styleMild.BackColor = Color.Lime

styleWarm.BackColor = Color.Yellow

styleHot.BackColor = Color.Red

Dim co As New FarPoint.Win.Spread.ComparisonOperator

FpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCold, co.LessThan, "32")

FpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCool, co.Between, "32", "55")

FpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleMild, co.Between, "55", "75")

FpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleWarm, co.Between, "75", "85")

FpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleHot, co.GreaterThan, "85")

FpSpread1.ActiveSheet.Cells(1, 1).Value = 38

Dim cf As FarPoint.Win.Spread.ConditionalFormat()

Dim item As New FarPoint.Win.Spread.ConditionalFormat(styleCool)

cf = FpSpread1.ActiveSheet.GetConditionalFormats(1, 1, False)

For Each item In cf

MessageBox.Show(item.LastCondition.ToString())

Next