Document Solutions for Excel, Java Edition | Document Solutions
com.grapecity.documents.excel Package / IFormulaOptions Interface

In This Topic
    IFormulaOptions Interface Methods
    In This Topic

    For a list of all members of this type, see IFormulaOptions members.

    Public Methods
     NameDescription
     MethodGets calculation mode.  
     MethodGets whether to enable iterative calculation.  
     MethodGets the maximum change of iterative calculation.  
     MethodGets the maximum iterations of iterative calculation.  
     MethodSets the calculation mode, this setting will only affect I/O of MS Excel/SSJSON/SJS files. Setting CalculationMode as CalculationMode.Manual will prevent MS Excel or SpreadJS from automatically calculating formulas on opening the workbook.Additionally, CalculationMode.Manual improves the speed of opening workbooks that contain a large number of formulas in MS Excel and SpreadJS.If you want to disable the calculation for the current workbook, please use Workbook.setEnableCalculation.  
     MethodSets whether to enable iterative calculation.  
     MethodSets the maximum change of iterative calculation.  
     MethodSets the maximum iterations of iterative calculation.  
    Top
    See Also