ExcelSparklineGroup Class

Represents a group of Excel-like sparklines.

Inheritance

object

ExcelSparklineGroup

Implements

ISparklineGroup

ICollection<ISparkline>

IEnumerable<ISparkline>

ISheetCellRangeSupport

IDisposable

Namespace: FarPoint.Win.Spread

Assembly: FarPoint.Win.Spread.dll

Syntax

public class ExcelSparklineGroup : ISparklineGroup, ICollection<ISparkline>, IEnumerable<ISparkline>, IEnumerable, ISerializeSupport, ISerializable, INotifyItemChanged, ICloneable, ISheetCellRangeSupport, IDisposable

Public Class ExcelSparklineGroup
    Implements ISparklineGroup, ICollection(Of ISparkline), IEnumerable(Of ISparkline), IEnumerable, ISerializeSupport, ISerializable, INotifyItemChanged, ICloneable, ISheetCellRangeSupport, IDisposable

Constructors

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

Properties

Name	Description
Count	Gets the number of elements contained in the ICollection<T>.
IsReadOnly	Gets a value that indicates whether the ICollection<T> is read-only.
this[int]	Gets the ISparkline at the specified index.
ReferenceError	Gets a value that indicates whether the current cell range is an invalid reference.
Renderer	Gets or sets the renderer.
Setting	Gets or sets the setting.

Methods

Name	Description
Add(ISparkline)	Adds an item to the ICollection<T>.
Clear()	Removes all items from the ICollection<T>.
Clone()	Creates a new object that is a copy of the current instance.
CloneSetting()	Clones a new sparkline group that copies the setting of the current sparkline group.
Contains(ISparkline)	Determines whether the ICollection<T> contains a specific value.
CopyTo(ISparkline[], int)	Copies the elements of the ICollection<T> to a Array, starting at a particular Array index.
Deserialize(XmlNodeReader)	Loads the object from XML.
Dispose()	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
Equals(object)	Determines whether the specified object, is equal to this instance.
FireClearItems(ISparklineGroup)	Fires the clear items event.
FireFormulaChanged()	Fires the formula changed.
FireItemAdded(ISparkline)	Fires the item added event.
FireItemRemoved(ISparkline)	Fires the item removed event.
FireItemUpdated(ISparkline)	Fires the item updated event.
FireItemUpdated(ISparkline, string, object, object)	Fires the item updated event.
FireUpdated()	Fires the updated event.
GetEnumerator()	Returns an enumerator that iterates through the collection.
GetExcelSetting()	Gets the excel setting.
GetHashCode()	Serves as the default hash function.
GetObjectData(SerializationInfo, StreamingContext)	Populates a SerializationInfo with the data needed to serialize the target object.
IsSwitchable()	Checks if the group is switchable.
OnClearItems(ItemEventArgs)	Raises the ClearItems event.
OnItemAdded(ItemEventArgs)	Raises the ItemAdded event.
OnItemRemoved(ItemEventArgs)	Raises the ItemRemoved event.
OnItemUpdated(ItemEventArgs)	Raises the ItemUpdated event.
OnUpdated(EventArgs)	Raises the Updated event.
ReLoadFormula(FpSpread, SheetView)	Reevaluates the formula which depends on the spread.
Remove(ISparkline)	Removes the first occurrence of a specific object from the ICollection<T>.
Serialize(XmlTextWriter)	Saves the object to XML.
ShowSelectDataForm(Form, FpSpread, ExcelSparkline, bool)	Shows the select data form.
ShowSelectDataForm(Form, FpSpread, ExcelSparklineGroup, bool, bool)	Shows the select data form.
ShowSelectDataForm(Form, FpSpread, SparklineType, bool)	Shows the select data form.
ShowSelectDataForm(Form, FpSpread, string, bool)	Shows the select data form.
SwitchRowColumn()	Switches sparkline rows or columns.

Events

Name	Description
ClearItems	Occurs when a sparkline is added.
FormulaChanged	Occurs when the date formula has changed.
ItemAdded	Occurs when a sparkline is added.
ItemRemoved	Occurs when a sparkline is added.
ItemUpdated	Occurs when a property value changes.
Updated	Occurs when a group has been updated.