com.aspose.slides

Interfaces

Classes

Exceptions

Skip navigation links
com.aspose.slides

Class SpreadsheetOptions

  • java.lang.Object
    • com.aspose.slides.SpreadsheetOptions
  • All Implemented Interfaces:
    ISpreadsheetOptions

    public class SpreadsheetOptions
extends java.lang.Object
implements ISpreadsheetOptions

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

    • Method Summary

      All Methods Instance Methods Concrete Methods 
      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.

      • Methods inherited from class java.lang.Object

        equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

    • Constructor Detail

      • SpreadsheetOptions

        public SpreadsheetOptions()

        Initializes a new instance of the SpreadsheetOptions class.

    • Method Detail

      • getPreferredCulture

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

        Specified by:
        getPreferredCulture in interface ISpreadsheetOptions

      • setPreferredCulture

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

        Specified by:
        setPreferredCulture in interface ISpreadsheetOptions

      • 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();
  }
        Specified by:
        getRecoverWorkbookFromChartCache in interface ISpreadsheetOptions
        Throws:
        com.aspose.ms.System.InvalidOperationException - Thrown when external workbook in unavailable and RecoverWorkbookFromChartCache property value is false.

      • setRecoverWorkbookFromChartCache

        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();
  }
        Specified by:
        setRecoverWorkbookFromChartCache in interface ISpreadsheetOptions
        Throws:
        com.aspose.ms.System.InvalidOperationException - Thrown when external workbook in unavailable and RecoverWorkbookFromChartCache property value is false.