aspose.cells

Class CalculationOptions

Represents options for calculation.

Constructor Summary
 
Property Getters/Setters Summary
functiongetCalcStackSize()
function
           Specifies the stack size for calculating cells recursively. -1 for this property means the calculation will use WorkbookSettings.CalcStackSize of corresponding workbook.
functiongetCalculationMonitor()
function
           The monitor for user to track the progress of formula calculation.
functiongetIgnoreError()
function
           Indicates if you need to hide the error in calculating formulas. The error may be unsupported function, external links, etc.
functiongetPrecisionStrategy()
function
           Specifies the strategy for processing precision of calcuation. The value of the property is CalculationPrecisionStrategy integer constant.
functiongetRecursive()
function
           Indicates whether calculate the dependent cells recursively when calculating one cell and it depends on other cells.
 

    • Constructor Detail

      • CalculationOptions

        function CalculationOptions()
    • Property Getters/Setters Detail

      • getIgnoreError/setIgnoreError : boolean 

        function getIgnoreError() / function setIgnoreError(value)
        
        Indicates if you need to hide the error in calculating formulas. The error may be unsupported function, external links, etc.
      • getCalculationMonitor/setCalculationMonitor : AbstractCalculationMonitor 

        function getCalculationMonitor() / function setCalculationMonitor(value)
        
        The monitor for user to track the progress of formula calculation.
      • getCalcStackSize/setCalcStackSize : Number 

        function getCalcStackSize() / function setCalcStackSize(value)
        
        Specifies the stack size for calculating cells recursively. -1 for this property means the calculation will use WorkbookSettings.CalcStackSize of corresponding workbook. WorkbookSettings.CalcStackSize
      • getPrecisionStrategy/setPrecisionStrategy : Number 

        function getPrecisionStrategy() / function setPrecisionStrategy(value)
        
        Specifies the strategy for processing precision of calcuation. The value of the property is CalculationPrecisionStrategy integer constant.
      • getRecursive/setRecursive : boolean 

        function getRecursive() / function setRecursive(value)
        
        Indicates whether calculate the dependent cells recursively when calculating one cell and it depends on other cells.