Spread ASP.NET 6.0 Product Documentation
ExcelSparklineSetting Class Members
See Also  Properties  Methods  Events Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : ExcelSparklineSetting Class


Glossary Item Box

The following tables list the members exposed by ExcelSparklineSetting.

Public Constructors

 NameDescription
Public ConstructorExcelSparklineSetting ConstructorOverloaded.   
Top

Public Properties

 NameDescription
Public PropertyAxisColorGets or sets the color of the axis.  
Public PropertyDisplayEmptyCellsAsGets or sets what to display empty cells as.  
Public PropertyDisplayHiddenGets or sets a value that indicates whether data in hidden cells is plotted for the sparklines in this sparkline group.  
Public PropertyDisplayXAxisGets or sets a value that indicates whether the horizontal axis is displayed for each sparkline in this sparkline group.  
Public PropertyFirstMarkerColorGets or sets the color of the first data point for each sparkline in this sparkline group.  
Public PropertyFormulaGets or sets a value that specifies the date range for the sparkline group.  
Public PropertyHighMarkerColorGets or sets the color of the highest data point for each sparkline in this sparkline group.  
Public PropertyLastMarkerColorGets or sets the color of the last data point for each sparkline in this sparkline group.  
Public PropertyLineWeightGets 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 PropertyLowMarkerColorGets or sets the color of the lowest data point for each sparkline in this sparkline group.  
Public PropertyManualMaxGets 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 PropertyManualMinGets 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 PropertyMarkersColorGets or sets a value that specifies the color of the data markers for each sparkline in this sparkline group.  
Public PropertyMaxAxisTypeGets or sets a value that specifies how the vertical axis maximums for the sparklines in this sparkline group are calculated.  
Public PropertyMinAxisTypeGets or sets a value that specifies how the vertical axis minimums for the sparklines in this sparkline group are calculated.  
Public PropertyNegativeColorGets or sets a value that specifies the color of the negative data points for each sparkline in this sparkline group.  
Public PropertyReferenceErrorGets a value that indicates whether the current cell range is an invalid reference.  
Public PropertyRightToLeftGets or sets a value that specifies whether each sparkline in the sparkline group is displayed in a right-to-left manner.  
Public PropertySeriesColorGets or sets a value that specifies the color for each sparkline in this sparkline group.  
Public PropertyShowFirstGets or sets a value that indicates whether the first data point is formatted differently for each sparkline in this sparkline group.  
Public PropertyShowHighGets 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 PropertyShowLastGets or sets a value that indicates whether the last data point is formatted differently for each sparkline in this sparkline group.  
Public PropertyShowLowGets 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 PropertyShowMarkersGets or sets a value that specifies whether data markers are displayed for each sparkline in this sparkline group.  
Public PropertyShowNegativeGets 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 MethodCloneCreates a new object that is a copy of the current instance.  
Public MethodDeserializeLoads the object from XML.  
Public MethodDisposePerforms application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.  
Public MethodGetObjectDataPopulates a System.Runtime.Serialization.SerializationInfo with the data needed to serialize the target object.  
Public MethodReLoadFormulaReevaluates the formula.  
Public MethodSerializeSaves the object to XML.  
Top

Protected Methods

 NameDescription
Protected MethodFireChangedFires the changed.  
Protected MethodFireUpdatedFires the updated.  
Protected MethodOnPropertyChangedRaises the PropertyChanged event.  
Protected MethodOnUpdatedRaises the Updated event.  
Protected MethodShouldSerializeAxisColorSets whether to serialize the axis color.  
Protected MethodShouldSerializeDateAxisSets whether to serialize the date axis.  
Protected MethodShouldSerializeDisplayEmptyCellsAsSets whether to serialize the display empty cells as.  
Protected MethodShouldSerializeDisplayHiddenSets whether to serialize the display hidden option.  
Protected MethodShouldSerializeDisplayXAxisSets whether to serialize the display X axis.  
Protected MethodShouldSerializeFirstMarkerColorSets whether to serialize the first marker color.  
Protected MethodShouldSerializeFormulaSets whether to serialize the formula.  
Protected MethodShouldSerializeHighMarkerColorSets whether to serialize the high marker color.  
Protected MethodShouldSerializeLastMarkerColorSets whether to serialize the last marker color.  
Protected MethodShouldSerializeLineWeightSets whether to serialize line weight.  
Protected MethodShouldSerializeLowMarkerColorSets whether to serialize the low marker color.  
Protected MethodShouldSerializeManualMaxSets whether to serialize manual max.  
Protected MethodShouldSerializeManualMinSets whether to serialize manual min.  
Protected MethodShouldSerializeMarkersColorSets whether to serialize the markers color.  
Protected MethodShouldSerializeMaxAxisTypeSets whether to serialize the max axis type.  
Protected MethodShouldSerializeMinAxisTypeSets whether to serialize the min axis type.  
Protected MethodShouldSerializeNegativeColorSets whether to serialize the negative color.  
Protected MethodShouldSerializeRightToLeftSets whether to serialize right to left.  
Protected MethodShouldSerializeSeriesColorSets whether to serialize the series color.  
Protected MethodShouldSerializeShowFirstSets whether to serialize show first.  
Protected MethodShouldSerializeShowHighSets whether to serialize show high.  
Protected MethodShouldSerializeShowLastSets whether to serialize show last.  
Protected MethodShouldSerializeShowLowSets whether to serialize show low.  
Protected MethodShouldSerializeShowMarkersSets whether to serialize show markers.  
Protected MethodShouldSerializeShowNegativeSets whether to serialize show negative.  
Top

Public Events

 NameDescription
Public EventFormulaChangedOccurs when the formula is changed.  
Public EventPropertyChangedOccurs when a property value changes.  
Public EventUpdatedOccurs when data has been updated.  
Top

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.