IWorkbookSet Interface Members

Public Properties

AltStartupPath	Gets or sets the alternate startup path, which is referred to by some external formula references.
BackgroundCalculation	Gets or sets the property which specifies whether interruptible background calculation will be initiated as needed when the last lock on a workbook set is released.
CalculateBeforeSave	Gets or sets the property which specifies whether workbooks should be calculated as needed before saving.
Calculation	Gets or sets the property which determines whether this workbook set is automatically calculated as needed.
CalculationOnDemand	Gets or sets the property which determines whether individual cells are calculated on demand. This feature is turned off by default.
Culture	Gets the CultureInfo of this workbook set.
DefaultFontName	Gets or sets the font name to use in the default font when new workbooks are created.
DefaultFontSize	Gets or sets the font size in points to use in the default font when new workbooks are created.
Experimental	Provides the ability to enable experimental features for this workbook set.
HasLock	Returns true if the current thread has acquired a lock on this workbook set by calling GetLock or one of the other methods which acquire a lock on a workbook set.
IsTrial	Returns true if this is an evaluation or trial version of SpreadsheetGear for .NET, otherwise false is returned.
Iteration	Gets or sets the property which specifies whether iteration will be used when a workbook set is calculated.
LibraryPath	Gets or sets the library path which is referred to by some external formula references.
MaxChange	Gets or sets the maximum change allowed if iteration is to stop.
MaxColumns	Returns the maximum number of columns allowed in a worksheet.
MaxIterations	Gets or sets the maximum number of calculation iterations.
MaxRecursions	Gets or sets the maximum number of recursive calculations allowed when references to cells still needing calculation are detected during workbook set calculation.
MaxRows	Returns the maximum number of rows allowed in a worksheet.
MaxWorksheets	Returns the maximum number of worksheets allowed in a workbook.
NeverRecalc	Gets or sets the property which specifies that formulas in this workbook set should never be calculated. This property must be set before any workbook exists in the workbook set.
ReadObjects	Gets or sets the property which specifies whether charts, pictures and drawing objects should be read when reading a workbook.
ReadVBA	Gets or sets the property which specifies whether VBA Macros should be read when reading a workbook.
ReferenceStyle	Gets or sets the property which specifies whether to use A1 style or R1C1 style in cell and range references.
SheetsInNewWorkbook	Gets or sets the number of worksheets in a newly created workbook.
StartupPath	Gets or sets the startup path, which is referred to by some external formula references.
Workbooks	Returns an instance of IWorkbooks which represents all of the workbooks in this workbook set.

Public Methods

Add	Adds a custom function to the workbook set.
BeginUpdate	Interrupts background calculation if necessary, acquires an exclusive lock on the workbook set, and suspends painting and events until EndUpdate is called.
Calculate	Calculates formulas as needed. Volatile formulas and formulas involved in circular references are always calculated.
CalculateFull	Calculates all formulas in a workbook set.
CalculateFullRebuild	Optimizes the internal representation of formulas and data in this workbook set and calculates all of the formulas.
EndUpdate	Restores painting and events to the state they were in before the last call to BeginUpdate, releases the lock acquired by BeginUpdate, and starts background calculation if appropriate.
GetAddress	Overloaded.
GetLock	Interrupts background calculation if necessary and acquires an exclusive lock on the workbook set.
ReleaseLock	Releases a lock acquired with GetLock and starts background calculation if appropriate.
Remove	Removes a custom function from the workbook set.
RewindLock	Interrupts background calculation if necessary and restores locks to the state they were in before UnwindLock was called.
UnwindLock	Unwinds the locks for the workbook set and returns the rewind count.

See Also

IWorkbookSet Interface Members

Public Properties

Public Methods

See Also