com.aspose.slides

Interfaces

Classes

Exceptions

com.aspose.slides

Interface ISpreadsheetOptions

  • All Known Implementing Classes:
    SpreadsheetOptions


    public interface ISpreadsheetOptions

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

    • Method Summary

      All Methods Instance Methods Abstract 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.
    • Method Detail

      • getPreferredCulture

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

      • setPreferredCulture

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

      • getRecoverWorkbookFromChartCache

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

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