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. |