SpreadsheetGear
IWorkbookSet Interface Members
See Also  Properties  Methods  Events Send Feedback
SpreadsheetGear Namespace : IWorkbookSet Interface


The following tables list the members exposed by IWorkbookSet.

Public Properties

 NameDescription
PropertyAltStartupPath Gets or sets the alternate startup path, which is referred to by some external formula references.  
PropertyBackgroundCalculation 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.  
PropertyCalculateBeforeSave Gets or sets the property which specifies whether workbooks should be calculated as needed before saving.  
PropertyCalculation Gets or sets the property which determines whether this workbook set is automatically calculated as needed.  
PropertyCalculationOnDemand Gets or sets the property which determines whether individual cells are calculated on demand. This feature is turned off by default.  
PropertyCulture Gets the CultureInfo of this workbook set.  
PropertyCustomLists Gets or sets the custom lists used by IRange.AutoFill and IRange.DataSeries (null by default).  
PropertyDefaultFontName Gets or sets the font name to use in the default font when new workbooks are created.  
PropertyDefaultFontSize Gets or sets the font size in points to use in the default font when new workbooks are created.  
PropertyExperimental Provides the ability to enable experimental features for this workbook set.  
PropertyHasLock 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.  
PropertyIsTrial Returns true if this is an evaluation or trial version of SpreadsheetGear, otherwise false is returned.  
PropertyIteration Gets or sets the property which specifies whether iteration will be used when a workbook set is calculated.  
PropertyLibraryPath Gets or sets the library path which is referred to by some external formula references.  
PropertyMaxChange Gets or sets the maximum change allowed if iteration is to stop.  
PropertyMaxColumnsReturns the maximum number of columns allowed in a worksheet.  
PropertyMaxIterations Gets or sets the maximum number of calculation iterations.  
PropertyMaxRecursions Gets or sets the maximum number of recursive calculations allowed when references to cells still needing calculation are detected during workbook set calculation.  
PropertyMaxRowsReturns the maximum number of rows allowed in a worksheet.  
PropertyMaxWorksheetsReturns the maximum number of worksheets allowed in a workbook.  
PropertyNeverRecalc 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.  
PropertyReadObjects Gets or sets the property which specifies whether charts, pictures and drawing objects should be read when reading a workbook.  
PropertyReadVBA Gets or sets the property which specifies whether VBA Macros should be read when reading a workbook.  
PropertyReferenceStyle Gets or sets the property which specifies whether to use A1 style or R1C1 style in cell and range references.  
PropertySheetsInNewWorkbook Gets or sets the number of worksheets in a newly created workbook.  
PropertyStartupPath Gets or sets the startup path, which is referred to by some external formula references.  
PropertyWorkbooks Returns an instance of IWorkbooks which represents all of the workbooks in this workbook set.  
Top

Public Methods

 NameDescription
MethodAdd Adds a custom function to the workbook set.  
MethodBeginUpdate Interrupts background calculation if necessary, acquires an exclusive lock on the workbook set, and suspends painting and events until EndUpdate is called.  
MethodCalculate Calculates formulas as needed. Volatile formulas and formulas involved in circular references are always calculated.  
MethodCalculateFull Calculates all formulas in a workbook set.  
MethodCalculateFullRebuild Optimizes the internal representation of formulas and data in this workbook set and calculates all of the formulas.  
MethodEndUpdate 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.  
MethodGetAddressOverloaded.   
MethodGetLock Interrupts background calculation if necessary and acquires an exclusive lock on the workbook set.  
MethodReleaseLock Releases a lock acquired with GetLock and starts background calculation if appropriate.  
MethodRemove Removes a custom function from the workbook set.  
MethodRewindLock Interrupts background calculation if necessary and restores locks to the state they were in before UnwindLock was called.  
MethodUnwindLockUnwinds the locks for the workbook set and returns the rewind count.  
Top

Public Events

 NameDescription
EventEndCalculate Occurs when calculation of this workbook set has completed. See remarks for information about the calling thread.  
Top

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.