Class GridWorkbookSettings

GridWorkbookSettings class

Represents settings of the workbook.

public class GridWorkbookSettings


GridWorkbookSettings()The default constructor.


Author { get; set; }Gets and sets the author of the file.
CheckCustomNumberFormat { get; set; }Gets or sets whether checking custom number format when setting Style.Custom.
CreateCalcChain { get; set; }Gets or sets whether create calculated formulas chain. Default is false.
Date1904 { get; set; }Gets or sets the value which represents if the workbook uses the 1904 date system.
EnableMacros { get; set; }Gets or sets whether enable macros; Now it only works when copying a worksheet to other worksheet in a workbook.
ForceFullCalculate { get; set; }Gets or sets whether fully calculates every time when a calculation is triggered.
Iteration { get; set; }Gets or sets whether use iteration to resolve circular references.
MaxIteration { get; set; }Gets or sets the maximum number of iterations to resolve a circular reference,the default value is 100.
PrecisionAsDisplayed { get; set; }True if calculations in this workbook will be done using only the precision of the numbers as they’re displayed
ReCalculateOnOpen { get; set; }Gets or sets whether re-calculate all formulas on opening file.



GridWeb gridweb = new GridWeb();
GridWorkbookSettings gsettings = new GridWorkbookSettings();

//do your business

[Visual Basic]

Dim gsettings as GridWorkbookSettings = new GridWorkbookSettings()
'do your business

See Also