asposecells.api

Constructor Detail

• CalculationOptions

  CalculationOptions()

Property Getters/Setters Detail

• getIgnoreError/setIgnoreError : boolean 

  boolean getIgnoreError() / setIgnoreError(value)
  

  Indicates if you need to hide the error in calculating formulas. The error may be unsupported function, external links, etc.

• getRecursive/setRecursive : boolean 

  boolean getRecursive() / setRecursive(value)
  

  Indicates whether calculate the dependent cells recursively when calculating one cell and it depends on other cells. The default value if true.

• getCalculationMonitor/setCalculationMonitor : AbstractCalculationMonitor 

  AbstractCalculationMonitor getCalculationMonitor() / setCalculationMonitor(value)
  

  The monitor for user to track the progress of formula calculation.

• getCalcStackSize/setCalcStackSize : int 

  int getCalcStackSize() / setCalcStackSize(value)
  

  Specifies the stack size for calculating cells recursively.

  When there are large amount of cells need to be calculated recursively in the dependency tree, StackOverflowException may be caused in the calculation process. If so, user should specify smaller value for this property. For such situation, user should determine the proper value for this property according to the actual formulas and data. Too small value may cause performance degradation for the formula calculation.

• getPrecisionStrategy/setPrecisionStrategy : int 

  int getPrecisionStrategy() / setPrecisionStrategy(value)
  

  Specifies the strategy for processing precision of calculation. The value of the property is CalculationPrecisionStrategy integer constant.

• getLinkedDataSources/setLinkedDataSources : Workbook[] 

  Workbook[] getLinkedDataSources() / setLinkedDataSources(value)
  

  Specifies the data sources for external links used in formulas.

  Like Workbook.updateLinkedDataSource(com.aspose.cells.Workbook[]), here you may specify data sources for external links used in formulas to be calculated, especially those used in INDIRECT function. For those external links used in INDIRECT function, they are not taken as part of the external links of the workbook and cannot be updated by Workbook.updateLinkedDataSource(com.aspose.cells.Workbook[]).

• getCharacterEncoding/setCharacterEncoding : Encoding 

  Encoding getCharacterEncoding() / setCharacterEncoding(value)
  

  Specifies the encoding used for encoding/decoding characters when calculating formulas. For functions such as CHAR, CODE, the calculated result depends on the region settings and default charset of the environment. With this property user can specify the proper encoding used for those function to get the expected result.