com.mindfusion.spreadsheet.Workbook 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 Methods

	Name	Description
	addPropertyChangedListener	Registers listener so that it will receive events from the workbook.
	addWorkbookListener	Registers listener so that it will receive events from the workbook.
	beginInit
	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.
	endInit
	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.
	getCalculationMaxIterations	Gets the maximum number of iterations when calculating certain functions, such as IRR and RATE.
	getCalculationPrecision	Gets the precision when calculating certain functions, such as IRR and RATE.
	getCanRedo	Gets a value indicating whether there is a command in the undo history which can be redone.
	getCanUndo	Gets a value indicating whether there is a command in the undo history which can be undone.
	getCustomNumericFormats	Gets the workbook user defined custom numeric formats.
	getDefaultNumericFormats	Gets the workbook defined default numeric formats.
	getEnableFormulaEvaluation	Gets a value indicating whether formula evaluation is enabled.
	getEnableTypeInference	Gets a value indicating whether cell data is automatically interpreted as a value of a specific type, or accepted as text.
	getExtendedEvaluator	Gets a custom expression evaluator. Identifier and function calls that cannot be resolved by the core are delegated to this evaluator.
	getExtendedInformationProvider	Gets an information provider for custom functions.
	getLocale	Gets the workbook locale.
	getLocalization	Gets the workbook localization object.
	getNamedRanges	Gets an object that an be used to manage the named ranges in this workbook.
	getPrintOptions	Returns a PrintOptions instance that allows customizing various aspects of printing and print-preview.
	getShowLeadingApostrophes	Gets a value indicating whether cells should show their leading apostrophe.
	getUndoEnabled	Gets a value indicating whether saving action records for later undo is enabled.
	getWorksheets	Gets an object that can be used to create and manage the worksheets in this workbook.
	loadFromXml	Overloaded.
	print	Overloaded. Prints the current workbook.
	redo	Executes again an action saved in the command history.
	removePropertyChangedListener	Unregisters listener so that it will no longer receive workbook events.
	removeWorkbookListener	Unregisters listener so that it will no longer receive workbook events.
	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 the workbook.
	setCalculationMaxIterations	Sets the maximum number of iterations when calculating certain functions, such as IRR and RATE.
	setCalculationPrecision	Sets the precision when calculating certain functions, such as IRR and RATE.
	setEnableFormulaEvaluation	Sets a value indicating whether formula evaluation is enabled.
	setEnableTypeInference	Sets a value indicating whether cell data is automatically interpreted as a value of a specific type, or accepted as text.
	setExtendedEvaluator	Sets a custom expression evaluator. Identifier and function calls that cannot be resolved by the core are delegated to this evaluator.
	setExtendedInformationProvider	Sets an information provider for custom functions.
	setLocale	Sets the workbook locale.
	setLocalizationInfo	Localizes the UI elements that are related to this workbook with the strings contained in the specified XML file.
	setShowLeadingApostrophes	Sets a value indicating whether cells should show their leading apostrophe.
	setUndoEnabled	Sets a value indicating whether saving action records for later undo is enabled.
	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 WorkbookListener.actionRedone event.
	onActionUndone	Raises the WorkbookListener.actionUndone event.
	onDeserializeColumnTag	Raises the WorkbookListener.deserializeColumnTag event.
	onDeserializeData	Raises the WorkbookListener.deserializeData event.
	onDeserializeRowTag	Raises the WorkbookListener.deserializeRowTag event.
	onDeserializeTag	Raises the WorkbookListener.deserializeTag event.
	onPropertyValueChanged	Raises the PropertyChangeListener.propertyChange event.
	onSerializeColumnTag	Raises the WorkbookListener.serializeColumnTag event.
	onSerializeData	Raises the WorkbookListener.serializeData event.
	onSerializeRowTag	Raises the WorkbookListener.serializeRowTag event.
	onSerializeTag	Raises the WorkbookListener.serializeTag event.
	onWorksheetCellChanged	Raises the WorkbookListener.worksheetCellChanged event.
	onWorksheetCellChangedPostCalc	Raises the WorkbookListener.worksheetCellChangedPostCalc event.
	onWorksheetCellChangedPreCalc	Raises the WorkbookListener.worksheetCellChangedPreCalc event.
	onWorksheetCellChanging	Raises the WorkbookListener.worksheetCellChanging event.
	onWorksheetCellParsing
	onWorksheetCellsCleared	Raises the WorkbookListener.worksheetCellsCleared event.
	onWorksheetCellStyleChanged	Raises the WorkbookListener.worksheetCellStyleChanged event.
	onWorksheetCellStyleChanging	Raises the WorkbookListener.worksheetCellStyleChanging event.
	onWorksheetChanged	Raises the WorkbookListener.worksheetChanged event.
	onWorksheetColumnChanged	Raises the WorkbookListener.worksheetColumnChanged event.
	onWorksheetRowChanged	Raises the WorkbookListener.worksheetRowChanged event.
	onWorksheetValidationFailed	Raises the WorkbookListener.worksheetValidationFailed event.

Public Constructors

Public Methods

Protected Methods

See Also