Settings for workbook

There are some settings we can specify by setting GridWorkbookSettings:

Name	Description
MaxIteration	Gets or sets the maximum number of iterations to resolve a circular reference; the default value is 100.
Iteration	Gets or sets whether to use iteration to resolve circular references.
ForceFullCalculate	Gets or sets whether to fully calculate every time a calculation is triggered.
CreateCalcChain	Gets or sets whether to create a calculated formulas chain. Default is false.
ReCalculateOnOpen	Gets or sets whether to recalculate all formulas when opening a file.
PrecisionAsDisplayed	True if calculations in this workbook will be done using only the precision of the numbers as they’re displayed.
Date1904	Gets or sets a value that indicates whether the workbook uses the 1904 date system.
CheckCustomNumberFormat	Gets or sets whether to check custom number format when setting Style.Custom.
Author	Gets and sets the author of the file.

For example, the following code sets ReCalculateOnOpen to false to stop the calculation when opening the file:

The following code sets the author for the file: