MindFusion.Spreadsheet.Wpf.Workbook Members

Workbook Members

Constructors Properties Methods Events

CollapseAll image

Members Options: Show All

Include Inherited Members
Include Protected Members

General Information

What's New in this Release

Version History

Programming Interface Overview

MindFusion.Spreadsheet.Wpf

AddItemCommand(T) Class

AdjustmentHandles Enumeration

Annotation Class

AutoFilter Class

AutoFilterOperator Enumeration

BaseMouseEventArgs Class

CalcExporter Class

CalcImporter Class

CellAnnotation Class

CellAnnotationPresenter Class

CellChangedEventArgs Class

CellCollection Class

CellEventArgs Class

CellIndex Class

CellMouseEventArgs Class

CellRange Class

CellRangeCollection Class

CellValidationEventArgs Class

ChangeWorksheetCommand Class

ColumnChangedEventArgs Class

ColumnCollection Class

ColumnEventArgs Class

ColumnHeader Class

ColumnMouseEventArgs Class

ColumnRange Class

ColumnRangeEventArgs Class

ColumnRangeMovingEventArgs Class

ColumnRangeResizingEventArgs Class

ComparisonOperator Enumeration

CompositeCommand Class

ConditionalFormatType Enumeration

Converter Class

CornerHeader Class

CsvExporter Class

CsvImporter Class

CurrencyCodeInfo Class

CurrencyCodes Class

CursorHint Enumeration

DefaultNumericFormats Class

DisposableCommand Class

DynamicFilterType Enumeration

ExcelExporter Class

ExcelImporter Class

FillDate Enumeration

FillDirection Enumeration

FillType Enumeration

FindWithin Enumeration

FormattedText Class

HatchBrush Class

HatchStyle Enumeration

HorizontalAlignment Enumeration

Hyperlink Class

HyperlinkType Enumeration

IColumnStyle Interface

IConditionalFormat Interface

IConditionalFormatCollection Interface

IHasName Interface

IInplaceEditable Interface

INotifyCollectionChanged Interface

INotifyPropertyValueChanged Interface

InplaceEditEventArgs Class

InplaceEditValidationEventArgs Class

InteractiveObject Class

InteractiveObjectPresenter Class

IRowStyle Interface

IStyle Interface

IValidation Interface

LookIn Enumeration

MeasureUnit Class

MergedCellsCollection Class

MoveItemCommand(T) Class

NamedCollection(T) Class

NamedRange Class

NamedRangeCollection Class

NotifyCollectionChangedAction Enumeration

NotifyCollectionChangedEventArgs Class

NumericFormatInfo Class

ObjectAnchor Enumeration

ObjectAnchorPosition Enumeration

ObjectEventArgs Class

ObjectInteractionEventArgs Class

ObjectInteractionValidationEventArgs Class

ObjectMouseEventArgs Class

ObjectValidationEventArgs Class

ObservableCollection(T) Class

OutlineEventArgs Class

PageOrder Enumeration

PaginationOptions Class

PdfExporter Class

PicturePresenter Class

PropertyEventArgs Class

PushDirection Enumeration

RemoveItemCommand(T) Class

ReplaceItemCommand(T) Class

ResetCollectionCommand(T) Class

RowChangedEventArgs Class

RowCollection Class

RowEventArgs Class

RowHeader Class

RowMouseEventArgs Class

RowRangeEventArgs Class

RowRangeMovingEventArgs Class

RowRangeResizingEventArgs Class

SearchDirection Enumeration

SearchOrder Enumeration

Selection Class

SerializeColumnTagEventArgs Class

SerializeDataEventArgs Class

SerializeRowTagEventArgs Class

SerializeTagEventArgs Class

ShiftDirection Enumeration

SortDirection Enumeration

SortOptions Class

SortOrder Enumeration

StyleData Class

TrackChangesCommand Class

UndoableCollection(T) Class

UndoEventArgs Class

ValidationErrorAction Enumeration

ValidationFailedEventArgs Class

ValidationType Enumeration

VerticalAlignment Enumeration

Workbook Members

Workbook Constructor

Workbook Methods

Workbook Properties

Workbook Events

WorkbookPrinter Class

WorkbookView Class

Worksheet Class

WorksheetChangedEventArgs Class

WorksheetCollection Class

WorksheetEventArgs Class

WorksheetMouseEventArgs Class

WorksheetTabMouseEventArgs Class

WorksheetValidationEventArgs Class

XmlContext Class

MindFusion.Spreadsheet.Wpf.Charts

MindFusion.Spreadsheet.Wpf.Expressions

MindFusion.Spreadsheet.Wpf.StandardForms

Function Reference

Online Resources

Technical Support

MindFusion Products

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

The following tables list the members exposed by the Workbook type.

Public Constructors

	Name	Description
	Workbook	Initializes a new instance of the Workbook class.

Public Properties

	Name	Description
	CalculationMaxIterations	Gets or sets the maximum number of iterations when calculating certain functions, such as IRR and RATE.
	CalculationPrecision	Gets or sets the precision when calculating certain functions, such as IRR and RATE.
	CanRedo	Gets a value indicating whether there is a command in the undo history which can be redone.
	CanUndo	Gets a value indicating whether there is a command in the undo history which can be undone.
	CustomNumericFormats	Gets the workbook user defined custom numeric formats.
	DefaultNumericFormats	Gets the workbook defined default numeric formats.
	DocumentPaginator	IDocumentPaginatorSource.DocumentPaginator implementation.
	EnableFormulaEvaluation	Gets or sets a value indicating whether formula evaluation is enabled.
	EnableTypeInference	Gets or sets a value indicating whether cell data is automatically interpreted as a value of a specific type, or accepted as text.
	ExtendedEvaluator	Gets or sets a custom expression evaluator. Identifier and function calls that cannot be resolved by the core are delegated to this evaluator.
	ExtendedInformationProvider	Gets or sets an information provider for custom functions.
	Locale	Gets or sets the workbook locale.
	NamedRanges	Gets an object that an be used to manage the named ranges in this workbook.
	PrintOptions	Gets an object which provides customization properties for printing and print-preview.
	ShowLeadingApostrophes	Gets or sets a value indicating whether cells should show their leading apostrophe.
	UndoEnabled	Gets or sets a value indicating whether saving action records for later undo is enabled.
	Worksheets	Gets an object that can be used to create and manage the worksheets in this workbook.

Public Methods

	Name	Description
	CancelChangeOperation	Stops tracking changes by the specified command and reverts all changes done so far.
	CancelCompositeOperation	Stops recording the most recently started composite operation and discards the records created so far.
	CommitChangeOperation	Stops tracking changes by the specified command and saves the command in the history queue.
	CommitCompositeOperation	Stops recording the most recently started composite operation and saves the composite in the history queue.
	EvaluateFormulas	Reevaluates all formulas containing custom and volatile functions and their dependent cells.
	ExecuteCommand	Executes the specified command on this workbook.
	Find	Performs a search for a cell containing the specified text, using the specified criteria.
	FindAll	Finds and returns all cells containing the specified text, using the specified criteria.
	LoadFromXml	Overloaded. Loads a workbook from an XML file or document.
	Redo	Executes again an action saved in the command history.
	Replace	Replaces the data of the specified cell if it matches the specified criteria and returns the next matching cell.
	ReplaceAll	Replaces the data of all cells matching the specified criteria.
	SaveToXml	Overloaded. Saves a workbook to an XML file or document.
	SetLocalizationInfo	Localizes the UI elements that are related to this workbook with the strings contained in the specified XML file.
	StartChangeOperation	Creates a Command object to track subsequent changes on the specified target. The returned command will be automatically executed when disposed.
	StartCompositeOperation	Starts recording undo/redo commands into a CompositeCommand.
	Undo	Undoes an action saved in the command history.

Protected Methods

	Name	Description
	OnActionRedone	Raises the ActionRedone event.
	OnActionUndone	Raises the ActionUndone event.
	OnDeserializeColumnTag	Raises the DeserializeColumnTag event.
	OnDeserializeData	Raises the DeserializeData event.
	OnDeserializeRowTag	Raises the DeserializeRowTag event.
	OnDeserializeTag	Raises the DeserializeData event.
	OnPropertyValueChanged	Raises the PropertyValueChanged event.
	OnSerializeColumnTag	Raises the SerializeColumnTag event.
	OnSerializeData	Raises the SerializeData event.
	OnSerializeRowTag	Raises the SerializeRowTag event.
	OnSerializeTag	Raises the SerializeTag event.
	OnWorksheetCellChanged	Raises the WorksheetCellChanged event.
	OnWorksheetCellChanging	Raises the WorksheetCellChanging event.
	OnWorksheetCellsCleared	Raises the WorksheetCellsCleared event.
	OnWorksheetChanged	Raises the WorksheetChanged event.
	OnWorksheetColumnChanged	Raises the WorksheetColumnChanged event.
	OnWorksheetRowChanged	Raises the WorksheetRowChanged event.
	OnWorksheetValidationFailed	Raises the WorksheetValidationFailed event.

Public Events

	Name	Description
	ActionRedone	Raised when an action is redone.
	ActionUndone	Raised when an action is undone.
	DeserializeColumnTag	Raised during XML deserialization to enable users to perform custom deserialization of tags.
	DeserializeData	Raised during XML deserialization to enable users to perform custom deserialization of the data values of cells.
	DeserializeRowTag	Raised during XML deserialization to enable users to perform custom deserialization of tags.
	DeserializeTag	Raised during XML deserialization to enable users to perform custom deserialization of tags.
	PropertyValueChanged	Raised when a property of this object is changed.
	SerializeColumnTag	Raised during XML serialization to enable users to perform custom serialization of tags.
	SerializeData	Raised during XML serialization to enable users to perform custom serialization of the data values of cells.
	SerializeRowTag	Raised during XML serialization to enable users to perform custom serialization of tags.
	SerializeTag	Raised during XML serialization to enable users to perform custom serialization of tags.
	WorksheetCellChanged	Raised when a cell of one of the worksheets is changed.
	WorksheetCellChanging	Raised when a cell of one of the worksheets is about to change.
	WorksheetCellsCleared	Raised when a range of cells in one of the worksheets has been cleared.
	WorksheetChanged	Raised when a property of one of the worksheets in this workbook is changed.
	WorksheetColumnChanged	Raised when a column in one of the worksheets is changed.
	WorksheetRowChanged	Raised when a row in one of the worksheets is changed.
	WorksheetValidationFailed	Raised when the validation of entered data has failed and the validation's ErrorAction property is set to RaiseEvent.

See Also

Workbook Class
MindFusion.Spreadsheet.Wpf Namespace