Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet.Commands Namespace / FormatConditionalCommand Class / CreateDatabarCfRuleCommand Method


In This Topic
CreateDatabarCfRuleCommand Method
In This Topic
Syntax
'Declaration
 
Public Shared Function CreateDatabarCfRuleCommand( _
   ByVal worksheet As Worksheet, _
   ByVal references() As Reference, _
   ByVal values() As String, _
   ByVal valueTypes() As CfValueType, _
   ByVal barFillType As DatabarFillType, _
   ByVal fillColor As Color, _
   ByVal borderType As DatabarBorderType, _
   ByVal borderColor As Color, _
   ByVal negativeColorType As DatabarNegativeColorType, _
   ByVal negativeFillColor As Color, _
   ByVal negativeBorderColorType As DatabarNegativeColorType, _
   ByVal negativeBorderColor As Color, _
   ByVal axisPosition As DatabarAxisPosition, _
   ByVal axisColor As Color, _
   ByVal showValue As Boolean, _
   ByVal direction As DatabarDirection _
) As FormatConditionalCommand
 
'Usage
 
Dim worksheet As Worksheet
Dim references() As Reference
Dim values() As String
Dim valueTypes() As CfValueType
Dim barFillType As DatabarFillType
Dim fillColor As Color
Dim borderType As DatabarBorderType
Dim borderColor As Color
Dim negativeColorType As DatabarNegativeColorType
Dim negativeFillColor As Color
Dim negativeBorderColorType As DatabarNegativeColorType
Dim negativeBorderColor As Color
Dim axisPosition As DatabarAxisPosition
Dim axisColor As Color
Dim showValue As Boolean
Dim direction As DatabarDirection
Dim value As FormatConditionalCommand
 
value = FormatConditionalCommand.CreateDatabarCfRuleCommand(worksheet, references, values, valueTypes, barFillType, fillColor, borderType, borderColor, negativeColorType, negativeFillColor, negativeBorderColorType, negativeBorderColor, axisPosition, axisColor, showValue, direction)

Parameters

worksheet
references
values
valueTypes
barFillType
fillColor
borderType
borderColor
negativeColorType
negativeFillColor
negativeBorderColorType
negativeBorderColor
axisPosition
axisColor
showValue
direction
See Also