AsposeCellsCloud-CellsApi

 view release on metacpan or  search on metacpan

docs/model/FormulaSettings.md  view on Meta::CPAN

## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**CalculateOnOpen** | **boolean** | Indicates whether the application is required to perform a full calculation when the workbook is opened.  |
**CalculateOnSave** | **boolean** | Indicates whether recalculate the workbook before saving the document, when in manual calculation mode.  |
**ForceFullCalculation** | **boolean** | Indicates whether calculates all formulas every time when a calculation is triggered.  |
**CalculationMode** | **string** | Gets or sets the mode for workbook calculation in ms excel.  |
**CalculationId** | **string** | Specifies the version of the calculation engine used to calculate values in the workbook.  |
**EnableIterativeCalculation** | **boolean** | Indicates whether enable iterative calculation to resolve circular references.  |
**MaxIteration** | **int** | The maximum iterations to resolve a circular reference.  |
**MaxChange** | **double** | The maximum change to resolve a circular reference.  |
**PrecisionAsDisplayed** | **boolean** | Whether the precision of calculated result be set as they are displayed while calculating formulas  |
**EnableCalculationChain** | **boolean** | Whether enable calculation chain for formulas. Default is false.  |
**PreservePaddingSpaces** | **boolean** | Indicates whether preserve those spaces and line breaks that are padded between formula tokens            while getting and setting formulas.            Default value is false.  |  


[[Back to Model list]](../DeveloperGuide.md#model-reference)  
[[Back to README]](../../README.md)

docs/model/WorkbookSettings.md  view on Meta::CPAN

**FirstVisibleTab** | **int** | Gets or sets the first visible worksheet tab.  |
**HidePivotFieldList** | **boolean** | Gets and sets whether hide the field list for the PivotTable.  |
**IsDefaultEncrypted** | **boolean** | Indicates whether encrypting the workbook with default password if Structure and Windows of the workbook are locked.  |
**IsHidden** | **boolean** | Indicates whether this workbook is hidden.  |
**IsHScrollBarVisible** | **boolean** | Gets or sets a value indicating whether the generated spreadsheet will contain a horizontal scroll bar.  |
**IsMinimized** | **boolean** | Represents whether the generated spreadsheet will be opened Minimized.  |
**IsVScrollBarVisible** | **boolean** | Gets or sets a value indicating whether the generated spreadsheet will contain a vertical scroll bar.  |
**Iteration** | **boolean** | Indicates whether enable iterative calculation to resolve circular references.  |
**LanguageCode** | **string** | Gets or sets the user interface language of the Workbook version based on CountryCode that has saved the file.  |
**MaxChange** | **double** | Returns or sets the maximum number of change to resolve a circular reference.  |
**MaxIteration** | **int** | Returns or sets the maximum number of iterations to resolve a circular reference.  |
**MemorySetting** | **string** | Gets or sets the memory usage options. The new option will be taken as the default option for newly created worksheets but does not take effect for existing worksheets.  |
**NumberDecimalSeparator** | **string** | Gets or sets the decimal separator for formatting/parsing numeric values. Default is the decimal separator of current Region.  |
**NumberGroupSeparator** | **string** | Gets or sets the character that separates groups of digits to the left of the decimal in numeric values. Default is the group separator of current Region.  |
**ParsingFormulaOnOpen** | **boolean** | Indicates whether parsing the formula when reading the file.  |
**PrecisionAsDisplayed** | **boolean** | True if calculations in this workbook will be done using only the precision of the numbers as they're displayed  |
**RecalculateBeforeSave** | **boolean** | Indicates whether to recalculate before saving the document.  |
**ReCalculateOnOpen** | **boolean** | Indicates whether re-calculate all formulas on opening file.  |
**RecommendReadOnly** | **boolean** | Indicates if the Read Only Recommended option is selected.             |
**Region** | **string** | Gets or sets the regional settings for workbook.  |
**RemovePersonalInformation** | **boolean** | True if personal information can be removed from the specified workbook.  |

lib/AsposeCellsCloud/Object/FormulaSettings.pm  view on Meta::CPAN

     'enable_iterative_calculation' => {
     	datatype => 'boolean',
     	base_name => 'EnableIterativeCalculation',
     	description => 'Indicates whether enable iterative calculation to resolve circular references. ',
     	format => '',
     	read_only => '',
     		},
     'max_iteration' => {
     	datatype => 'int',
     	base_name => 'MaxIteration',
     	description => 'The maximum iterations to resolve a circular reference. ',
     	format => '',
     	read_only => '',
     		},
     'max_change' => {
     	datatype => 'double',
     	base_name => 'MaxChange',
     	description => 'The maximum change to resolve a circular reference. ',
     	format => '',
     	read_only => '',
     		},

lib/AsposeCellsCloud/Object/WorkbookSettings.pm  view on Meta::CPAN

     'max_change' => {
     	datatype => 'double',
     	base_name => 'MaxChange',
     	description => 'Returns or sets the maximum number of change to resolve a circular reference. ',
     	format => '',
     	read_only => '',
     		},
     'max_iteration' => {
     	datatype => 'int',
     	base_name => 'MaxIteration',
     	description => 'Returns or sets the maximum number of iterations to resolve a circular reference. ',
     	format => '',
     	read_only => '',
     		},
     'memory_setting' => {
     	datatype => 'string',
     	base_name => 'MemorySetting',
     	description => 'Gets or sets the memory usage options. The new option will be taken as the default option for newly created worksheets but does not take effect for existing worksheets. ',
     	format => '',
     	read_only => '',
     		},