GridWorkbookSettings class
GridWorkbookSettings class
Represents the settings of the workbook.
The GridWorkbookSettings type exposes the following members:
Constructors
| Constructor | Description |
|---|---|
__init__(self) | Constructs a new instance of GridWorkbookSettings |
Properties
| Property | Description |
|---|---|
| max_iteration | Returns or sets the maximum number of iterations to resolve a circular reference, the default value is 100. |
| iteration | Indicates whether use iteration to resolve circular references. |
| force_full_calculate | Indicates whether fully calculates every time when a calculation is triggered. |
| create_calc_chain | Indicates whether create calculated formulas chain. Default is false. |
| re_calculate_on_open | Indicates whether re-calculate all formulas on opening file. Default is true. |
| precision_as_displayed | True if calculations in this workbook will be done using only the precision of the numbers as they’re displayed |
| date1904 | Gets or sets a value which represents if the workbook uses the 1904 date system. |
| enable_macros | Enable macros; Now it only works when copying a worksheet to other worksheet in a workbook. |
| check_custom_number_format | Indicates whether checking custom number format when setting Style.Custom, default is false. |
| check_excel_restriction | Whether check restriction of excel file when user modify cells related objects. For example, excel does not allow inputting string value longer than 32K. When you input a value longer than 32K such as by Cell.PutValue(string), if this property is true, you will get an Exception. If this property is false, we will accept your input string value as the cell’s value so that later you can output the complete string value for other file formats such as CSV. However, if you have set such kind of value that is invalid for excel file format, you should not save the workbook as excel file format later. Otherwise there may be unexpected error for the generated excel file. default is false. |
| author | Gets/sets the author of the file. |
Example
from aspose.cellsgridjs import GridJsWorkbook, GridWorkbookSettings
g = GridJsWorkbook()
gsettings = GridWorkbookSettings()
g.settings = gsettings
See Also
- module
aspose.cellsgridjs
