SpreadsheetOptions
SpreadsheetOptions class
Represents options which can be used to specify additional spreadsheets behavior.
SpreadsheetOptions
| Name | Description |
|---|---|
| SpreadsheetOptions() | Initializes a new instance of the SpreadsheetOptions class. |
Returns: SpreadsheetOptions
getPreferredCulture
| Name | Description |
|---|---|
| getPreferredCulture () | Gets or sets preferred culture information for calculating some functions intended for use with languages that use the double-byte character set (DBCS). |
Returns: Locale
getRecoverWorkbookFromChartCache
| Name | Description |
|---|---|
| getRecoverWorkbookFromChartCache () | If data source for the chart is an external workbook and it’s not available, it will be recovered from the chart cache. |
Returns: boolean
Exception
| Error | Condition |
|---|---|
| InvalidOperationException | Thrown when external workbook in unavailable and RecoverWorkbookFromChartCache property value is false. |
setPreferredCulture
| Name | Description |
|---|---|
| setPreferredCulture (Locale) | Gets or sets preferred culture information for calculating some functions intended for use with languages that use the double-byte character set (DBCS). |
Returns: void
setRecoverWorkbookFromChartCache
| Name | Description |
|---|---|
| setRecoverWorkbookFromChartCache (boolean) | If data source for the chart is an external workbook and it’s not available, it will be recovered from the chart cache. |
Returns: void
Exception
| Error | Condition |
|---|---|
| InvalidOperationException | Thrown when external workbook in unavailable and RecoverWorkbookFromChartCache property value is false. |