Class GridWorkbookSettings

GridWorkbookSettings class

Represents settings of the workbook.

public class GridWorkbookSettings : ISerializable

Constructors

NameDescription
GridWorkbookSettings()default constructor

Properties

NameDescription
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
PreservePaddingSpaces { get; set; }Indicates whether preserve those spaces and line breaks that are padded between formula tokens while getting and setting formulas. Default value is false.
ReCalculateOnOpen { get; set; }Gets or sets whether re-calculate all formulas on opening file.

Examples

[C#]

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

//do your business

[Visual Basic]


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

See Also