MindFusion.Spreadsheet.Wpf.Workbook Members

MindFusion.Wpf Pack Programmer's Guide

Workbook Members

Constructors Properties Methods Events

CollapseAll image

Members Options: Show All

Include Inherited Members
Include Protected Members

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