ExcelSparklineSetting Class

Represents a setting of an Excel-like sparkline.

Inheritance

object

ExcelSparklineSetting

Implements

ISparklineSetting

INotifyPropertyChanged

ISerializeSupport

ISerializable

ISheetCellRangeSupport

ICloneable

IDisposable

Namespace: FarPoint.Win.Spread

Assembly: FarPoint.Win.Spread.dll

Syntax

[TypeConverter(typeof(_ajz))]
public class ExcelSparklineSetting : ISparklineSetting, INotifyPropertyChanged, ISerializeSupport, ISerializable, ISheetCellRangeSupport, ICloneable, IDisposable

<TypeConverter(GetType(_ajz))>
Public Class ExcelSparklineSetting
    Implements ISparklineSetting, INotifyPropertyChanged, ISerializeSupport, ISerializable, ISheetCellRangeSupport, ICloneable, IDisposable

Constructors

Name	Description
ExcelSparklineSetting()	Initializes a new instance of the ExcelSparklineSetting class.
ExcelSparklineSetting(SerializationInfo, StreamingContext)	Initializes a new instance of the ExcelSparklineSetting class.

Properties

Name	Description
AxisColor	Gets or sets the color of the axis.
DateAxis	Gets or sets a value that indicates whether the sparkline is using the date axis.
DisplayEmptyCellsAs	Gets or sets what to display empty cells as.
DisplayHidden	Gets or sets a value that indicates whether data in hidden cells is plotted for the sparklines in this sparkline group.
DisplayXAxis	Gets or sets a value that indicates whether the horizontal axis is displayed for each sparkline in this sparkline group.
FirstMarkerColor	Gets or sets the color of the first data point for each sparkline in this sparkline group.
Formula	Gets or sets a value that specifies the date range for the sparkline group.
HighMarkerColor	Gets or sets the color of the highest data point for each sparkline in this sparkline group.
LastMarkerColor	Gets or sets the color of the last data point for each sparkline in this sparkline group.
LineWeight	Gets 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).
LowMarkerColor	Gets or sets the color of the lowest data point for each sparkline in this sparkline group.
ManualMax	Gets 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.
ManualMin	Gets 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.
MarkersColor	Gets or sets a value that specifies the color of the data markers for each sparkline in this sparkline group.
MaxAxisType	Gets or sets a value that specifies how the vertical axis maximums for the sparklines in this sparkline group are calculated.
MinAxisType	Gets or sets a value that specifies how the vertical axis minimums for the sparklines in this sparkline group are calculated.
NegativeColor	Gets or sets a value that specifies the color of the negative data points for each sparkline in this sparkline group.
ReferenceError	Gets a value that indicates whether the current cell range is an invalid reference.
RightToLeft	Gets or sets a value that specifies whether each sparkline in the sparkline group is displayed in a right-to-left manner.
SeriesColor	Gets or sets a value that specifies the color for each sparkline in this sparkline group.
ShowFirst	Gets or sets a value that indicates whether the first data point is formatted differently for each sparkline in this sparkline group.
ShowHigh	Gets or sets a value that specifies whether the data points with the highest value are formatted differently for each sparkline in this sparkline group.
ShowLast	Gets or sets a value that indicates whether the last data point is formatted differently for each sparkline in this sparkline group.
ShowLow	Gets or sets a value that specifies whether the data points with the lowest value are formatted differently for each sparkline in this sparkline group.
ShowMarkers	Gets or sets a value that specifies whether data markers are displayed for each sparkline in this sparkline group.
ShowNegative	Gets or sets a value that specifies whether the negative data points are formatted differently for each sparkline in this sparkline group.

Methods

Name	Description
Clone()	Creates a new object that is a copy of the current instance.
Deserialize(XmlNodeReader)	Loads the object from XML.
Dispose()	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
FireChanged(string)	Fires the changed event.
FireFormulaChanged()	Fires the formula changed.
FireUpdated()	Fires the updated event.
GetObjectData(SerializationInfo, StreamingContext)	Populates a SerializationInfo with the data needed to serialize the target object.
OnPropertyChanged(PropertyChangedEventArgs)	Raises the PropertyChanged event.
OnUpdated(EventArgs)	Raises the Updated event.
ReLoadFormula(FpSpread, SheetView)	Reevaluates the formula.
Serialize(XmlTextWriter)	Saves the object to XML.
ShouldSerializeAxisColor()	Sets whether to serialize the axis color.
ShouldSerializeDateAxis()	Sets whether to serialize the date axis.
ShouldSerializeDisplayEmptyCellsAs()	Sets whether to serialize the display empty cells as option.
ShouldSerializeDisplayHidden()	Sets whether to serialize the display hidden option.
ShouldSerializeDisplayXAxis()	Sets whether to serialize the display X axis option.
ShouldSerializeFirstMarkerColor()	Sets whether to serialize the first marker color.
ShouldSerializeFormula()	Sets whether to serialize the formula.
ShouldSerializeHighMarkerColor()	Sets whether to serialize the high marker color.
ShouldSerializeLastMarkerColor()	Sets whether to serialize the last marker color.
ShouldSerializeLineWeight()	Sets whether to serialize line weight.
ShouldSerializeLowMarkerColor()	Sets whether to serialize the low marker color.
ShouldSerializeManualMax()	Sets whether to serialize the manual max setting.
ShouldSerializeManualMin()	Sets whether to serialize the manual min setting.
ShouldSerializeMarkersColor()	Sets whether to serialize the markers color.
ShouldSerializeMaxAxisType()	Sets whether to serialize the maximum axis type setting.
ShouldSerializeMinAxisType()	Sets whether to serialize the minimum axis type setting.
ShouldSerializeNegativeColor()	Sets whether to serialize the negative color.
ShouldSerializeRightToLeft()	Sets whether to serialize the right to left setting.
ShouldSerializeSeriesColor()	Sets whether to serialize the series color.
ShouldSerializeShowFirst()	Sets whether to serialize the show first option.
ShouldSerializeShowHigh()	Sets whether to serialize the show high option.
ShouldSerializeShowLast()	Sets whether to serialize the show last option.
ShouldSerializeShowLow()	Sets whether to serialize the show low option.
ShouldSerializeShowMarkers()	Sets whether to serialize show markers.
ShouldSerializeShowNegative()	Sets whether to serialize the show negative setting.

Events

Name	Description
FormulaChanged	Occurs when the formula is changed.
PropertyChanged	Occurs when a property value changes.
Updated	Occurs when data has been updated.