| Name | Description | |
|---|---|---|
 | 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. |
| CustomLists | Gets or sets the custom lists used by IRange.AutoFill and IRange.DataSeries (null by default). |
| 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. |
| EnableWebService | Enables or disables the WEBSERVICE worksheet function (disabled by default). |
| Experimental | Provides the ability to enable experimental features for this workbook set. |
| Factory | Returns the IFactory which created this object or its parent. (Inherited from SpreadsheetGear.IFactoryChild) |
| HasLock | Returns true if the current thread has acquired a lock on this workbook set by calling IWorkbookSet.GetLock or one of the other methods which acquire a lock on a workbook set. |
| IsDisposed | Returns true if this workbook set has been disposed. |
| IsTrial | Returns true if this is an evaluation or trial version of SpreadsheetGear, 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 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 in a worksheet. |
| MaxWorksheets | Returns the maximum number of worksheets 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. |
| UserName | Gets or sets the user name for this workbook set which is used as the default value for IBuiltinDocumentProperties.Author and LastAuthor as well as the default value for IComment.Author. If this value has not been set and there is a WorkbookView attached to this workbook set then the current user name from the UI platform will be returned and will be used as the Author defaults. |
| Workbooks | Returns an instance of IWorkbooks which represents all of the workbooks in this workbook set. |
The following tables list the members exposed by IWorkbookSet.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | 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 IWorkbookSet.EndUpdate is called. |
| Calculate | Calculates formulas as needed. Volatile formulas and formulas involved in circular references are always calculated. |
| CalculateFull | Calculates all non-invariant formulas in a workbook set. |
| CalculateFullRebuild | Resets the calculation order and IRange.IsVolatileOrCircularFormula status of all cell formulas in this workbook set, and then calls CalculateFull>. |
| Dispose | (Inherited from System.IDisposable) |
| EndUpdate | Restores painting and events to the state they were in before the last call to IWorkbookSet.BeginUpdate, releases the lock acquired by BeginUpdate, and starts background calculation if appropriate. |
| GC | Attempts to optimize the amount and layout of memory used by this workbook set. |
| GetAddress | Overloaded. Returns a string representing the specified zero based row and column indexes. |
| GetLock | Interrupts background calculation if necessary and acquires an exclusive lock on the workbook set. |
| ReleaseLock | Releases a lock acquired with IWorkbookSet.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 IWorkbookSet.UnwindLock was called. |
| UnwindLock | Unwinds the locks for the workbook set and returns the rewind count. |
Public Events
| Name | Description | |
|---|---|---|
 | EndCalculate | Occurs when calculation of this workbook set has completed. See remarks for information about the calling thread. |
See Also