Settings for workbook
Contents
[
Hide
]
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 :