Method Details

• getEnableIterativeCalculation

  boolean getEnableIterativeCalculation()

  Gets whether to enable iterative calculation.

• setEnableIterativeCalculation

  void setEnableIterativeCalculation(boolean value)

  Sets whether to enable iterative calculation.

• getMaximumIterations

  int getMaximumIterations()

  Gets the maximum iterations of iterative calculation.

• setMaximumIterations

  void setMaximumIterations(int value)

  Sets the maximum iterations of iterative calculation.

• getMaximumChange

  double getMaximumChange()

  Gets the maximum change of iterative calculation.

• setMaximumChange

  void setMaximumChange(double value)

  Sets the maximum change of iterative calculation.

• getCalculationMode

  CalculationMode getCalculationMode()

  Gets calculation mode.

  Returns:

  Calculation mode.

• setCalculationMode

  void setCalculationMode(CalculationMode calculationMode)

  Sets 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(boolean).

  Parameters:

  calculationMode - The calculation mode to set.