SpreadsheetGear 2023
IWorkbookSet Interface Methods

SpreadsheetGear Namespace : IWorkbookSet Interface

For a list of all members of this type, see IWorkbookSet members.

Public Methods
 NameDescription
 MethodAdds a custom function to the workbook set.  
 MethodInterrupts background calculation if necessary, acquires an exclusive lock on the workbook set, and suspends painting and events until IWorkbookSet.EndUpdate is called.  
 MethodCalculates formulas as needed. Volatile formulas and formulas involved in circular references are always calculated.  
 MethodCalculates all non-invariant formulas in a workbook set.  
 MethodResets the calculation order and IRange.IsVolatileOrCircularFormula status of all cell formulas in this workbook set, and then calls CalculateFull>.  
 Method (Inherited from System.IDisposable)
 MethodRestores 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.  
 MethodAttempts to optimize the amount and layout of memory used by this workbook set.  
 MethodOverloaded. Returns a string representing the specified zero based row and column indexes.  
 MethodInterrupts background calculation if necessary and acquires an exclusive lock on the workbook set.  
 MethodReleases a lock acquired with IWorkbookSet.GetLock and starts background calculation if appropriate.  
 MethodRemoves a custom function from the workbook set.  
 MethodInterrupts background calculation if necessary and restores locks to the state they were in before IWorkbookSet.UnwindLock was called.  
 MethodUnwinds the locks for the workbook set and returns the rewind count.  
Top
See Also

Reference

IWorkbookSet Interface
SpreadsheetGear Namespace
Factory
IWorkbooks
IWorkbook