GridWorkbookSettings

GridWorkbookSettings class

Represents settings of the workbook.

public class GridWorkbookSettings

Constructors

Name Description
GridWorkbookSettings() The default constructor.

Properties

Name Description
Author { get; set; } Gets and sets the author of the file.
CheckCustomNumberFormat { get; set; } Indicates whether checking custom number format when setting Style.Custom.
CreateCalcChain { get; set; } Indicates whether create calculated formulas chain. Default is false.
Date1904 { get; set; } Gets or sets a value which represents if the workbook uses the 1904 date system.
EnableMacros { get; set; } Enable macros; Now it only works when copying a worksheet to other worksheet in a workbook.
ForceFullCalculate { get; set; } Indicates whether fully calculates every time when a calculation is triggered.
Iteration { get; set; } Indicates whether use iteration to resolve circular references.
MaxIteration { get; set; } Returns 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; } Indicates whether re-calculate all formulas on opening file.

Examples

[C#]

GridJsWorkbook g = new GridJsWorkbook();

GridWorkbookSettings gsettings = new GridWorkbookSettings();
g.Settings=gsettings;

//do your business

[Visual Basic]
Dim g as GridJsWorkbook = new GridJsWorkbook()

Dim gsettings as GridWorkbookSettings = new GridWorkbookSettings()
 g.Settings=gsettings;
 
'do your business

See Also