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 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 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 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 UnwindLock was called.  
 MethodUnwinds the locks for the workbook set and returns the rewind count.  
 MethodOverloaded. Calls GetLock(), runs the specified Action and then calls ReleaseLock().  
Top
See Also

Reference

IWorkbookSet Interface
SpreadsheetGear Namespace
Factory
IWorkbooks
IWorkbook