ISpreadsheetOptions

public interface ISpreadsheetOptions

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

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.

getPreferredCulture()

public abstract 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 abstract 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 abstract 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 abstract 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