Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / ExcelSparklineSetting Class
Properties Methods Events


In This Topic
    ExcelSparklineSetting Class Members
    In This Topic

    The following tables list the members exposed by ExcelSparklineSetting.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded.   
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets the color of the axis.  
    Public PropertyGets or sets a value that indicates whether the sparkline is using the date axis.  
    Public PropertyGets or sets what to display empty cells as.  
    Public PropertyGets or sets a value that indicates whether data in hidden cells is plotted for the sparklines in this sparkline group.  
    Public PropertyGets or sets a value that indicates whether the horizontal axis is displayed for each sparkline in this sparkline group.  
    Public PropertyGets or sets the color of the first data point for each sparkline in this sparkline group.  
    Public PropertyGets or sets a value that specifies the date range for the sparkline group.  
    Public PropertyGets or sets the color of the highest data point for each sparkline in this sparkline group.  
    Public PropertyGets or sets the color of the last data point for each sparkline in this sparkline group.  
    Public PropertyGets or sets a value that specifies the line weight for each sparkline in the sparkline group, where the line weight is measured in points. The weight must be greater than or equal to zero, and must be less than or equal to 3 (LineSeries only supports a line weight value in the range of 0.0->3.0).  
    Public PropertyGets or sets the color of the lowest data point for each sparkline in this sparkline group.  
    Public PropertyGets or sets a value that specifies the maximum for the vertical axis that is shared across all sparklines in this sparkline group. The value must be zero if maxAxisType does not equal custom.  
    Public PropertyGets or sets a value that specifies the minimum for the vertical axis that is shared across all sparklines in this sparkline group. The value must be zero if minAxisType does not equal custom.  
    Public PropertyGets or sets a value that specifies the color of the data markers for each sparkline in this sparkline group.  
    Public PropertyGets or sets a value that specifies how the vertical axis maximums for the sparklines in this sparkline group are calculated.  
    Public PropertyGets or sets a value that specifies how the vertical axis minimums for the sparklines in this sparkline group are calculated.  
    Public PropertyGets or sets a value that specifies the color of the negative data points for each sparkline in this sparkline group.  
    Public PropertyGets a value that indicates whether the current cell range is an invalid reference.  
    Public PropertyGets or sets a value that specifies whether each sparkline in the sparkline group is displayed in a right-to-left manner.  
    Public PropertyGets or sets a value that specifies the color for each sparkline in this sparkline group.  
    Public PropertyGets or sets a value that indicates whether the first data point is formatted differently for each sparkline in this sparkline group.  
    Public PropertyGets or sets a value that specifies whether the data points with the highest value are formatted differently for each sparkline in this sparkline group.  
    Public PropertyGets or sets a value that indicates whether the last data point is formatted differently for each sparkline in this sparkline group.  
    Public PropertyGets or sets a value that specifies whether the data points with the lowest value are formatted differently for each sparkline in this sparkline group.  
    Public PropertyGets or sets a value that specifies whether data markers are displayed for each sparkline in this sparkline group.  
    Public PropertyGets or sets a value that specifies whether the negative data points are formatted differently for each sparkline in this sparkline group.  
    Top
    Public Methods
     NameDescription
    Public MethodCreates a new object that is a copy of the current instance.  
    Public MethodLoads the object from XML.  
    Public MethodPerforms application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.  
    Public MethodPopulates a System.Runtime.Serialization.SerializationInfo with the data needed to serialize the target object.  
    Public MethodReevaluates the formula.  
    Public MethodSaves the object to XML.  
    Top
    Protected Methods
     NameDescription
    Protected MethodFires the changed event.  
    Protected MethodFires the updated event.  
    Protected MethodRaises the PropertyChanged event.  
    Protected MethodRaises the Updated event.  
    Protected MethodSets whether to serialize the axis color.  
    Protected MethodSets whether to serialize the date axis.  
    Protected MethodSets whether to serialize the display empty cells as option.  
    Protected MethodSets whether to serialize the display hidden option.  
    Protected MethodSets whether to serialize the display X axis option.  
    Protected MethodSets whether to serialize the first marker color.  
    Protected MethodSets whether to serialize the formula.  
    Protected MethodSets whether to serialize the high marker color.  
    Protected MethodSets whether to serialize the last marker color.  
    Protected MethodSets whether to serialize line weight.  
    Protected MethodSets whether to serialize the low marker color.  
    Protected MethodSets whether to serialize the manual max setting.  
    Protected MethodSets whether to serialize the manual min setting.  
    Protected MethodSets whether to serialize the markers color.  
    Protected MethodSets whether to serialize the maximum axis type setting.  
    Protected MethodSets whether to serialize the minimum axis type setting.  
    Protected MethodSets whether to serialize the negative color.  
    Protected MethodSets whether to serialize the right to left setting.  
    Protected MethodSets whether to serialize the series color.  
    Protected MethodSets whether to serialize the show first option.  
    Protected MethodSets whether to serialize the show high option.  
    Protected MethodSets whether to serialize the show last option.  
    Protected MethodSets whether to serialize the show low option.  
    Protected MethodSets whether to serialize show markers.  
    Protected MethodSets whether to serialize the show negative setting.  
    Top
    Public Events
     NameDescription
    Public EventOccurs when the formula is changed.  
    Public EventOccurs when a property value changes.  
    Public EventOccurs when data has been updated.  
    Top
    See Also