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

In This Topic
    IFormulaOptions Interface Members
    In This Topic

    The following tables list the members exposed by IFormulaOptions.

    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