Class GridWorkbookSettings
Contents
[
Hide
]GridWorkbookSettings class
Represents the settings of the workbook.
public class GridWorkbookSettings
Constructors
| Name | Description |
|---|---|
| GridWorkbookSettings() | The default constructor. |
Properties
| Name | Description |
|---|---|
| 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
- namespace Aspose.Cells.GridJs
- assembly Aspose.Cells.GridJs
