WorkbookSettings Class
Represents all seetings of the workbook.
Inheritance Hierarchy
SystemObject
  Aspose.CellsWorkbookSettings

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 19.11.0.0 (19.11)
Syntax
public class WorkbookSettings : IDisposable

The WorkbookSettings type exposes the following members.

Properties
  NameDescription
Public propertyAutoCompressPictures
Specifies a boolean value that indicates the application automatically compressed pictures in the workbook.
Public propertyAutoRecover
Indicates whether the file is mark for auto-recovery.
Public propertyBuildVersion
Specifies the incremental public release of the application.
Public propertyCalcMode
It specifies whether to calculate formulas manually, automatically or automatically except for multiple table operations.
Public propertyCalcStackSize
Specifies the stack size for calculating cells recursively. The large value for this size will give better performance when there are lots of cells need to be calculated recursively. On the other hand, larger value will raise the risk of StackOverflowException. If user gets StackOverflowException when calculating formulas, this value should be decreased.
Public propertyCalculationId
Specifies the version of the calculation engine used to calculate values in the workbook.
Public propertyCheckCompatibility
Indicates whether check compatiliblity when saving workbook.
Public propertyCheckComptiliblity Obsolete.
Indicates whether check compatiliblity when saving workbook.
Public propertyCheckCustomNumberFormat
Indicates whether checking custom number format when setting Style.Custom.
Public propertyCheckExcelRestriction
Whether check restriction of excel file when user modify cells related objects. For example, excel does not allow inputting string value longer than 32K. When you input a value longer than 32K such as by Cell.PutValue(string), if this property is true, you will get an Exception. If this property is false, we will accept your input string value as the cell's value so that later you can output the complete string value for other file formats such as CSV. However, if you have set such kind of value that is invalid for excel file format, you should not save the workbook as excel file format later. Otherwise there may be unexpected error for the generated excel file.
Public propertyCompliance
Specifies the OOXML version for the output document. The default value is Ecma376_2006.
Public propertyCrashSave
indicates whether the application last saved the workbook file after a crash.
Public propertyCreateCalcChain
Indicates whether create calculated formulas chain. Default is false.
Public propertyCultureInfo
Gets or sets the system culture info.
Public propertyDataExtractLoad
indicates whether the application last opened the workbook for data recovery.
Public propertyDate1904
Gets or sets a value which represents if the workbook uses the 1904 date system.
Public propertyDisplayDrawingObjects
Indicates whether and how to show objects in the workbook.
Public propertyEnableMacros
Enable macros;
Public propertyFirstVisibleTab
Gets or sets the first visible worksheet tab.
Public propertyGlobalizationSettings
Gets and sets the globalization settings.
Public propertyHidePivotFieldList
Gets and sets whether hide the field list for the PivotTable.
Public propertyIsDefaultEncrypted
Indicates whether encrypting the workbook with default password if Structure and Windows of the workbook are locked.
Public propertyIsEncrypted
Gets a value that indicates whether a password is required to open this workbook.
Public propertyIsHidden
Indicates whether this workbook is hidden.
Public propertyCode exampleIsHScrollBarVisible
Gets or sets a value indicating whether the generated spreadsheet will contain a horizontal scroll bar.
Public propertyIsMinimized
Represents whether the generated spreadsheet will be opened Minimized.
Public propertyIsProtected
Gets a value that indicates whether the structure or window of the Workbook is protected.
Public propertyCode exampleIsVScrollBarVisible
Gets or sets a value indicating whether the generated spreadsheet will contain a vertical scroll bar.
Public propertyIsWriteProtected Obsolete.
Indicates whether this workbook is write protected.
Public propertyIteration
Indicates if Aspose.Cells will use iteration to resolve circular references.
Public propertyLanguageCode
Gets or sets the user interface language of the Workbook version based on CountryCode that has saved the file.
Public propertyMaxChange
Returns or sets the maximum number of change that Microsoft Excel can use to resolve a circular reference.
Public propertyMaxColumn
Gets the max column index, zero-based.
Public propertyMaxIteration
Returns or sets the maximum number of iterations that Aspose.Cells can use to resolve a circular reference.
Public propertyMaxRow
Gets the max row index, zero-based.
Public propertyMaxRowsOfSharedFormula
Gets and sets the max row number of shared formula.
Public propertyMemorySetting
Gets or sets the memory usage options. The new option will be taken as the default option for newly created worksheets but does not take effect for existing worksheets.
Public propertyNumberDecimalSeparator
Gets or sets the decimal separator for formatting/parsing numeric values. Default is the decimal separator of current Region.
Public propertyNumberGroupSeparator
Gets or sets the character that separates groups of digits to the left of the decimal in numeric values. Default is the group separator of current Region.
Public propertyPaperSize
Gets and sets the default print paper size.
Public propertyParsingFormulaOnOpen
Indicates whether parsing the formula when reading the file.
Public propertyPassword
Represents Workbook file encryption password.
Public propertyPrecisionAsDisplayed
True if calculations in this workbook will be done using only the precision of the numbers as they're displayed
Public propertyProtectionType
Gets the protection type of the workbook.
Public propertyRecalculateBeforeSave
Indicates whether to recalculate before saving the document.
Public propertyReCalculateOnOpen
Indicates whether re-calculate all formulas on opening file.
Public propertyRecommendReadOnly Obsolete.
Indicates if the Read Only Recommended option is selected.
Public propertyRegion
Gets or sets the regional settings for workbook.
Public propertyRemovePersonalInformation
True if personal information can be removed from the specified workbook.
Public propertyRepairLoad
Indicates whether the application last opened the workbook in safe or repair mode.
Public propertyShared
Gets or sets a value that indicates whether the Workbook is shared.
Public propertySheetTabBarWidth
Width of worksheet tab bar (in 1/1000 of window width).
Public propertyCode exampleShowTabs
Get or sets a value whether the Workbook tabs are displayed.
Public propertySignificantDigits
Gets and sets the number of significant digits. The default value is SignificantDigits.
Public propertyStreamProvider
Gets and sets the stream provider for external resource.
Public propertyUpdateAdjacentCellsBorder
Indicates whether update adjacent cells' border.
Public propertyUpdateLinksType
Gets and sets how updates external links when the workbook is opened.
Public propertyWarningCallback
Gets or sets warning callback.
Public propertyWindowHeight
The height of the window, in unit of point.
Public propertyWindowHeightCM
The height of the window, in unit of centimeter.
Public propertyWindowHeightInch
The height of the window, in unit of inch.
Public propertyWindowLeft
The distance from the left edge of the client area to the left edge of the window, in unit of point.
Public propertyWindowLeftCM
The distance from the left edge of the client area to the left edge of the window. In unit of centimeter.
Public propertyWindowLeftInch
The distance from the left edge of the client area to the left edge of the window. In unit of inch.
Public propertyWindowTop
The distance from the top edge of the client area to the top edge of the window, in unit of point.
Public propertyWindowTopCM
The distance from the top edge of the client area to the top edge of the window, in unit of centimeter.
Public propertyWindowTopInch
The distance from the top edge of the client area to the top edge of the window, in unit of inch.
Public propertyWindowWidth
The width of the window, in unit of point.
Public propertyWindowWidthCM
The width of the window, in unit of centimeter.
Public propertyWindowWidthInch
The width of the window, in unit of inch.
Public propertyWriteProtectedPassword Obsolete.
Sets the protected password to modify the file.
Public propertyWriteProtection
Provides access to the workbook write protection options.
Methods
  NameDescription
Public methodDispose
Releases resources.
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
See Also