'Usage Dim name As String Dim instance As New CustomImageInfo(name)
Parameters
- name
- Name of custom image in spread's custom image list.
'Usage Dim name As String Dim instance As New CustomImageInfo(name)
System.Drawing.Icon resource1 = new System.Drawing.Icon("C:\\SpreadWin7\\SpWin7CSharp\\fpicon.ico"); System.Drawing.Icon resource2 = new System.Drawing.Icon("C:\\SpreadWin7\\SpWin7CSharp\\cat.ico"); fpSpread1.CustomIconContainer.AddIcon("fpicon", resource1); fpSpread1.CustomIconContainer.AddIcon("cat", resource2); FarPoint.Win.Spread.IconSetConditionalFormattingRule iconRule = new FarPoint.Win.Spread.IconSetConditionalFormattingRule(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.Custom); iconRule.IconRuleSet.Add(new FarPoint.Win.Spread.ConditionalFormattingIconValue(0, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, false, new FarPoint.Win.Spread.CustomImageInfo("fpicon"))); iconRule.IconRuleSet.Add(new FarPoint.Win.Spread.ConditionalFormattingIconValue(1, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, false, new FarPoint.Win.Spread.CustomImageInfo("cat"))); fpSpread1_Sheet1.SetValue(0, 0, 0); fpSpread1_Sheet1.SetValue(1, 0, 1); fpSpread1_Sheet1.SetValue(2, 0, 2); fpSpread1_Sheet1.SetConditionalFormatting(0, 0, 3, 1, new FarPoint.Win.Spread.IConditionalFormattingRule[] { iconRule });
Dim resource1 As New System.Drawing.Icon("C:\SpreadWin7\SpWin7CSharp\fpicon.ico") Dim resource2 As New System.Drawing.Icon("C:\SpreadWin7\SpWin7CSharp\cat.ico") FpSpread1.CustomIconContainer.AddIcon("fpicon", resource1) FpSpread1.CustomIconContainer.AddIcon("cat", resource2) Dim iconRule As New FarPoint.Win.Spread.IconSetConditionalFormattingRule(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.Custom) iconRule.IconRuleSet.Add(New FarPoint.Win.Spread.ConditionalFormattingIconValue(0, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, False, New FarPoint.Win.Spread.CustomImageInfo("fpicon"))) iconRule.IconRuleSet.Add(New FarPoint.Win.Spread.ConditionalFormattingIconValue(1, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, False, New FarPoint.Win.Spread.CustomImageInfo("cat"))) FpSpread1_Sheet1.SetValue(0, 0, 0) FpSpread1_Sheet1.SetValue(1, 0, 1) FpSpread1_Sheet1.SetValue(2, 0, 2) FpSpread1_Sheet1.SetConditionalFormatting(0, 0, 3, 1, New FarPoint.Win.Spread.IConditionalFormattingRule() {iconRule})