MindFusion.Wpf Pack Programmer's Guide
MindFusion.Spreadsheet.Wpf Namespace
Classes Interfaces Enumerations
 

 Classes

  Class Description

AddItemCommand(T)

Implements addition of items to a collection.

Annotation

Represents a comment of a cell within a worksheet.

AutoFilter

Represents autofiltering inside a worksheet.

BaseMouseEventArgs

Contains the arguments passed to mouse-related events.

CalcExporter

CalcExporter lets you export Workbook objects to OpenOffice Calc spreadsheets.

CalcImporter

CalcImporter lets you import OpenOffice Calc spreadsheets into a Workbook.

Cell

Identifies a single cell in a Worksheet.

CellAnnotation

Represents the interactive object containing a comment for a cell within a worksheet.

CellAnnotationPresenter

Defines the presentation of cell annotations in the WorkbookView control.

CellChangedEventArgs

Provides data for the CellChanged event.

CellCollection

Represents a specialized collection for worksheet cells.

CellData

Represents a copy of the cell data in a worksheet region. Instances of this class can be obtained by calling the CopyData method of a Worksheet.

CellEventArgs

Provides data for events related to individual cells.

CellIndex

An immutable representation of a cell reference.

CellMouseEventArgs

Contains the arguments passed to cell-related mouse events.

CellRange

Identifies a range of cells in a Worksheet.

CellRangeCollection

Represents a specialized collection for cell ranges.

CellValidationEventArgs

Provides data for validation events related to individual cells.

ChangeWorksheetCommand

Represents a command that can track and undo changes of a Worksheet.

Column

Identifies a column in a worksheet.

ColumnChangedEventArgs

Provides data for the ColumnChanged event.

ColumnCollection

Represents a specialized collection for worksheet columns.

ColumnEventArgs

Contains the arguments passed to column-related events.

ColumnHeader

Defines the presentation of column headers in the WorkbookView control.

ColumnMouseEventArgs

Contains the arguments passed to column-related mouse events.

ColumnRange

Identifies a range of columns in a Worksheet.

ColumnRangeEventArgs

Contains the arguments passed to events related to multiple column.

ColumnRangeMovingEventArgs

Contains the arguments passed to validation events related to multiple columns.

ColumnRangeResizingEventArgs

Contains the arguments passed to validation events related to multiple columns.

Command

Represents an action that modifies the workbook and whose effects can be undone.

CompositeCommand

Represents a set of Command instances as a single operation. Undoing or redoing the composite action, respectively undoes or redoes all its constituent subactions at the same time.

Converter

Provides capabilities to convert various types to and from strings in a culture-independent way.

CornerHeader

Defines the presentation of the are in the top-left corner of the WorkbookView control.

CsvExporter

CsvExporter lets you export Worksheet data into .csv file.

CsvImporter

CsvImporter lets you import .csv files into a Worksheet.

CurrencyCodeInfo

Represents a currency ISO code to locale relationship.

CurrencyCodes

Represents a helper class containing the definitions of currency ISO codes to locale relationships.

DefaultNumericFormats

Contains predefined format strings for different numeric formats.

DisposableCommand

Represents a command that implements the IDisposable interface.

Drawing

Represents a drawing within a worksheet. A drawing can contain unlimited number of visual elements such as pictures, diagrams and charts.

ExcelExporter

ExcelExporter lets you export Workbook objects to Excel Open XML documents.

ExcelImporter

ExcelImporter lets you import Excel Open XML documents into a Workbook.

Filter

Represents a filter for a single column.

FormattedText

Represents a sequence of text fragments with different formatting (font, size, color).

HatchBrush

Emulates GDI+ hatch brushes using the WPF ImageBrush class.

Header

Defines the presentation of headers in the WorkbookView control.

Hyperlink

Represents a hyperlink associated with a worksheet cell.

InplaceEditEventArgs

Contains the arguments passed to the InplaceEditStarted and InplaceEditEnded event handlers.

InplaceEditValidationEventArgs

Contains the arguments passed to the InplaceEditStarting and InplaceEditEnding event handlers.

InteractiveObject

Represents a worksheet object that can be modified interactively by the user.

InteractiveObjectPresenter

Defines the presentation of interactive objects in the WorkbookView control.

Measure

Represents amounts of specific units.

MeasureUnit

Specifies units of measure.

MergedCellsCollection

Represents a specialized collection for merged cells in a worksheet, each merged cell is represented by a CellRange object.

MoveItemCommand(T)

Implements moving of items within a collection.

NamedCollection(T)

Represents a collection of objects that can be manipulated by name. The objects in the collection are required to have unique names.

NamedRange

Represents a named range of cells.

NamedRangeCollection

Represents a specialized collection of NamedRange objects.

NotifyCollectionChangedEventArgs

Provides data for the CollectionChanged event.

NumericFormatInfo

Represents a numeric format within a workbook.

ObjectEventArgs

Provides data for events related to interactive objects.

ObjectInteractionEventArgs

Provides data for events related to interactive objects.

ObjectInteractionValidationEventArgs

Contains the arguments passed to handlers of object validation events.

ObjectMouseEventArgs

Contains the arguments passed to object-related mouse events.

ObjectValidationEventArgs

Contains the arguments passed to handlers of object validation events.

ObservableCollection(T)

Represents a strongly-typed collection that provides notifications when items get added, removed, or when the whole list is refreshed.

OutlineEventArgs

Contains the arguments passed to the RowOutlineLevelToggled and ColumnOutlineLevelToggled event handlers.

PaginationOptions

Provides properties that allow customization of various aspects of printing and print-preview.

PdfExporter

Exports worksheets to Adobe Portable Document Format (PDF) files.

Picture

Represents a picture in a drawing within a worksheet.

PicturePresenter

Defines the presentation of pictures in the WorkbookView control.

PropertyEventArgs

Provides data for the PropertyValueChanged event.

RemoveItemCommand(T)

Implements deletion of items from a collection.

ReplaceItemCommand(T)

Implements replacement of items in a collection.

ResetCollectionCommand(T)

Implements clearing of a collection.

Row

Identifies a row in a worksheet.

RowChangedEventArgs

Provides data for the RowChanged event.

RowCollection

Represents a specialized collection for worksheet rows.

RowEventArgs

Contains the arguments passed to row-related events.

RowHeader

Defines the presentation of row headers in the WorkbookView control.

RowMouseEventArgs

Contains the arguments passed to row-related mouse events.

RowRange

Identifies a range of rows in a Worksheet.

RowRangeEventArgs

Contains the arguments passed to events related to multiple rows.

RowRangeMovingEventArgs

Contains the arguments passed to validation events related to multiple rows.

RowRangeResizingEventArgs

Contains the arguments passed to validation events related to multiple rows.

Run

Represents a fragment of text with uniform formatting in a FormattedText object.

Selection

Represents a set of selected cells and objects within a grid view.

SerializeColumnTagEventArgs

Provides data for the SerializeColumnTag and DeserializeColumnTag event handlers.

SerializeDataEventArgs

Provides data for the SerializeData and DeserializeData event handlers.

SerializeRowTagEventArgs

Provides data for the SerializeRowTag and DeserializeRowTag event handlers.

SerializeTagEventArgs

Provides data for the SerializeTag and DeserializeTag event handlers.

SortKey

Represents a key in a sorting operation.

SortOptions

Specifies the order of a sorting operation, ascending or descending.

StyleData

Represents a copy of the cell styles in a worksheet region. Instances of this class can be obtained by calling the CopyStyles method of a Worksheet.

TrackChangesCommand

Represents a command that can track and undo changes of INotifyPropertyValueChanged objects.

UndoableCollection(T)

Represents a strongly-typed collection that supports undo and redo.

UndoEventArgs

Contains the arguments passed to the ActionUndone and ActionRedone event handlers.

ValidationFailedEventArgs

Provides data for the ValidationFailed event.

Workbook

The main document class, contains a collection of worksheets, named ranges and other related objects.

WorkbookPrinter

Provides print and print preview for Workbook objects.

WorkbookView

Represents a control that can display Workbook objects.

Worksheet

Represents a worksheet in a workbook, that is, a rectangular grid of cells containing data.

WorksheetChangedEventArgs

Provides data for the WorksheetChanged event.

WorksheetCollection

Represents a specialized collection of Worksheet objects.

WorksheetEventArgs

Contains the arguments passed to Worksheet-related events.

WorksheetMouseEventArgs

Contains the arguments passed to Worksheet-related mouse events.

WorksheetTabMouseEventArgs

Contains the arguments passed to Worksheet-related mouse events.

WorksheetValidationEventArgs

Contains the arguments passed to Worksheet-related validation events.

XmlContext

Contains methods that help serializing and deserializing complex objects to and from XML documents.

 Interfaces

  Interface Description

IColumnStyle

Represents the style of a column.

IConditionalFormat

Represents conditional format associated with a range of cells.

IConditionalFormatCollection

Represents a collection of IConditionalFormat objects.

IHasName

Defines a name for the type that implements this interface.

IInplaceEditable

Represents an inplace-editable object within a worksheet.

INotifyCollectionChanged

Notifies listeners of dynamic changes, such as when items get added and removed or the whole list is refreshed.

INotifyPropertyValueChanged

Provides notification for property changes.

IRowStyle

Represents the style of a row.

IStyle

Represents the style of an element.

IValidation

Represents data validation associated with a range of cells.

 Enumerations

  Enumeration Description

AdjustmentHandles

Identifies the distinct selection handles of an interactive object.

AutoFilterOperator

Indicates an autofiltering operator.

ComparisonOperator

Specifies an operator for value comparison.

ConditionalFormatType

Specifies the type of a conditional format.

CursorHint

Specifies what mouse cursor to display while a user interacts with the view controls.

DynamicFilterType

Specifies the type of a dynamic autofilter.

FillDate

Specifies the date component to increment when filling dates.

FillDirection

Specifies the direction of a data fill operation.

FillType

Specifies the method used to fill series of cells.

FindWithin

Specifies the target of find and replace operations.

HatchStyle

Represents hatch patterns corresponding to GDI+ HatchBrush objects.

HorizontalAlignment

Specifies the horizontal alignment of an element.

HyperlinkType

Specifies the type of a hyperlink.

LookIn

Specifies whether a find operation should search in cell formulas or values.

NotifyCollectionChangedAction

Describes the action that caused a CollectionChanged event.

ObjectAnchor

Specifies the anchor of a worksheet object.

ObjectAnchorPosition

Specifies the anchor position of a worksheet object.

PageOrder

Specifies the order of printed pages.

PushDirection

Specifies how the existing cells are moved when inserting new cells in a CellRange object.

SearchDirection

Specifies the direction of find and replace operations.

SearchOrder

Specifies the order of find and replace operations.

ShiftDirection

Specifies how the cells are moved when removing cells from a CellRange object.

SortDirection

Specifies the direction of a sorting operation.

SortOrder

Specifies the order of a sorting operation, ascending or descending.

ValidationErrorAction

Specifies the action to perform when data validation fails.

ValidationType

Specifies the type of data validation.

VerticalAlignment

Specifies the vertical alignment of an element.