Settings for workbook

Contents
[ ]

There are some settings we can specified by set 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 use iteration to resolve circular references.
ForceFullCalculate Gets or sets whether fully calculates every time when a calculation is triggered.
CreateCalcChain Gets or sets whether create calculated formulas chain. Default is false.
ReCalculateOnOpen Gets or sets whether re-calculate all formulas on opening 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 which represents if the workbook uses the 1904 date system.
CheckCustomNumberFormat Gets or sets whether checking custom number format when setting Style.Custom.
Author Gets and sets the author of the file.

For example, the following code set the ReCalculateOnOpen to false to stop the caculate on opening the file :

the following code set the author for the file :