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
Error
| 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). |
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. |
Error
| Error | Condition |
|---|
| InvalidOperationException | Thrown when external workbook in unavailable and RecoverWorkbookFromChartCache property value is false. |