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.