public interface ISpreadsheetOptions
Represents options which can be used to specify additional spreadsheets behavior.
Modifier and Type | Method and Description |
---|---|
java.util.Locale |
getPreferredCulture()
Gets or sets preferred culture information for calculating some functions intended for use with languages
that use the double-byte character set (DBCS).
|
boolean |
getRecoverWorkbookFromChartCache()
If data source for the chart is an external workbook and it's not available, it will be recovered from the chart cache.
|
void |
setPreferredCulture(java.util.Locale value)
Gets or sets preferred culture information for calculating some functions intended for use with languages
that use the double-byte character set (DBCS).
|
void |
setRecoverWorkbookFromChartCache(boolean value)
If data source for the chart is an external workbook and it's not available, it will be recovered from the chart cache.
|
java.util.Locale getPreferredCulture()
Gets or sets preferred culture information for calculating some functions intended for use with languages that use the double-byte character set (DBCS).
void setPreferredCulture(java.util.Locale value)
Gets or sets preferred culture information for calculating some functions intended for use with languages that use the double-byte character set (DBCS).
boolean getRecoverWorkbookFromChartCache()
If data source for the chart is an external workbook and it's not available, it will be recovered from the chart cache.
Example:SpreadsheetOptions spreadOptions = new SpreadsheetOptions(); spreadOptions.setRecoverWorkbookFromChartCache(true); LoadOptions loadOptions = new LoadOptions(); loadOptions.setSpreadsheetOptions(spreadOptions); Presentation pres = new Presentation("Presentation.pptx", loadOptions); try { IChart chart = (IChart)pres.getSlides().get_Item(0).getShapes().get_Item(0); IChartDataWorkbook recoveredWorkbook = chart.getChartData().getChartDataWorkbook(); } finally { if (pres != null) pres.dispose(); }
com.aspose.ms.System.InvalidOperationException
- Thrown when external workbook in unavailable and RecoverWorkbookFromChartCache property value is false.void setRecoverWorkbookFromChartCache(boolean value)
If data source for the chart is an external workbook and it's not available, it will be recovered from the chart cache.
Example:SpreadsheetOptions spreadOptions = new SpreadsheetOptions(); spreadOptions.setRecoverWorkbookFromChartCache(true); LoadOptions loadOptions = new LoadOptions(); loadOptions.setSpreadsheetOptions(spreadOptions); Presentation pres = new Presentation("Presentation.pptx", loadOptions); try { IChart chart = (IChart)pres.getSlides().get_Item(0).getShapes().get_Item(0); IChartDataWorkbook recoveredWorkbook = chart.getChartData().getChartDataWorkbook(); } finally { if (pres != null) pres.dispose(); }
com.aspose.ms.System.InvalidOperationException
- Thrown when external workbook in unavailable and RecoverWorkbookFromChartCache property value is false.