public class SpreadsheetOptions extends java.lang.Object implements ISpreadsheetOptions
Represents options which can be used to specify additional spreadsheets behavior.
Constructor and Description |
---|
SpreadsheetOptions()
Initializes a new instance of the
SpreadsheetOptions class. |
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.
|
public SpreadsheetOptions()
Initializes a new instance of the SpreadsheetOptions
class.
public final 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).
getPreferredCulture
in interface ISpreadsheetOptions
public final 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).
setPreferredCulture
in interface ISpreadsheetOptions
public final 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(); }
getRecoverWorkbookFromChartCache
in interface ISpreadsheetOptions
com.aspose.ms.System.InvalidOperationException
- Thrown when external workbook in unavailable and RecoverWorkbookFromChartCache property value is false.public final 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(); }
setRecoverWorkbookFromChartCache
in interface ISpreadsheetOptions
com.aspose.ms.System.InvalidOperationException
- Thrown when external workbook in unavailable and RecoverWorkbookFromChartCache property value is false.