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