SpreadsheetGear 2012
IWorkbookSet Interface Properties

SpreadsheetGear Namespace : IWorkbookSet Interface

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

Public Properties
 NameDescription
PropertyAltStartupPathGets or sets the alternate startup path, which is referred to by some external formula references.  
PropertyBackgroundCalculationGets 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.  
PropertyCalculateBeforeSaveGets or sets the property which specifies whether workbooks should be calculated as needed before saving.  
PropertyCalculationGets or sets the property which determines whether this workbook set is automatically calculated as needed.  
PropertyCalculationOnDemandGets or sets the property which determines whether individual cells are calculated on demand. This feature is turned off by default.  
PropertyCultureGets the CultureInfo of this workbook set.  
PropertyCustomListsGets or sets the custom lists used by IRange.AutoFill and IRange.DataSeries (null by default).  
PropertyDefaultFontNameGets or sets the font name to use in the default font when new workbooks are created.  
PropertyDefaultFontSizeGets or sets the font size in points to use in the default font when new workbooks are created.  
PropertyExperimentalProvides the ability to enable experimental features for this workbook set.  
PropertyHasLockReturns 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.  
PropertyIsTrialReturns true if this is an evaluation or trial version of SpreadsheetGear, otherwise false is returned.  
PropertyIterationGets or sets the property which specifies whether iteration will be used when a workbook set is calculated.  
PropertyLibraryPathGets or sets the library path which is referred to by some external formula references.  
PropertyMaxChangeGets or sets the maximum change allowed if iteration is to stop.  
PropertyMaxColumnsReturns the maximum number of columns allowed in a worksheet.  
PropertyMaxIterationsGets or sets the maximum number of calculation iterations.  
PropertyMaxRecursionsGets 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.  
PropertyNeverRecalcGets 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.  
PropertyReadObjectsGets or sets the property which specifies whether charts, pictures and drawing objects should be read when reading a workbook.  
PropertyReadVBAGets or sets the property which specifies whether VBA Macros should be read when reading a workbook.  
PropertyReferenceStyleGets or sets the property which specifies whether to use A1 style or R1C1 style in cell and range references.  
PropertySheetsInNewWorkbookGets or sets the number of worksheets in a newly created workbook.  
PropertyStartupPathGets or sets the startup path, which is referred to by some external formula references.  
PropertyWorkbooksReturns an instance of IWorkbooks which represents all of the workbooks in this workbook set.  
Top
See Also

Reference

IWorkbookSet Interface
SpreadsheetGear Namespace
Factory
IWorkbooks
IWorkbook

Send Feedback