Class GridWorkbookSettings

GridWorkbookSettings class

Represents the settings of the workbook.

public class GridWorkbookSettings

Constructors

NameDescription
GridWorkbookSettings()The default constructor.

Properties

NameDescription
Author { get; set; }Gets/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. Default is true.

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