SpreadsheetOptions

Inheritance: java.lang.Object

All Implemented Interfaces: com.aspose.slides.ISpreadsheetOptions

public class SpreadsheetOptions implements ISpreadsheetOptions

Represents options which can be used to specify additional spreadsheets behavior.

Constructors

ConstructorDescription
SpreadsheetOptions()Initializes a new instance of the SpreadsheetOptions class.

Methods

MethodDescription
getPreferredCulture()Gets or sets preferred culture information for calculating some functions intended for use with languages that use the double-byte character set (DBCS).
setPreferredCulture(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).
getRecoverWorkbookFromChartCache()If data source for the chart is an external workbook and it’s not available, it will be recovered from the chart cache.
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.

SpreadsheetOptions()

public SpreadsheetOptions()

Initializes a new instance of the SpreadsheetOptions class.

getPreferredCulture()

public final 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).

Returns: java.util.Locale

setPreferredCulture(Locale value)

public final void setPreferredCulture(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).

Parameters:

ParameterTypeDescription
valuejava.util.Locale

getRecoverWorkbookFromChartCache()

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();
  }

Returns: boolean

setRecoverWorkbookFromChartCache(boolean value)

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();
  }

Parameters:

ParameterTypeDescription
valueboolean