CXlMacros::OptionsCalculation

Controls when and how formulas in open workbooks are calculated

[C++]
static int OptionsCalculation(
   short int type_num,
   bool iter = false,
   int max_num = 100,
   double max_change = 0.001,
   bool update = true,
   bool precision = false,
   bool date_1904 = false,
   bool calc_save = false,
   bool save_values = true
);

Parameters

type_num

Type_num is a number from 1 to 3 indicating the type of calculation:- 1=Automatic; 2=Automatic except tables; 3=Manual.

iter

Iter corresponds to the Iteration check box.

max_num

Max_num is the maximum number of iterations.

max_change

Max_change is the maximum change of each iteration.

update

Update corresponds to the Update Remote References check box.

precision

Precision corresponds to the Precision As Displayed check box.

date_1904

Date_1904 corresponds to the 1904 Date System check box.

calc_save

Calc_save corresponds to the Recalculate Before Save check box.

save_values

Save_values corresponds to the Save External Link Values check box.

Return value

Zero if the function has been called successfully; non-zero if the function could not be called. See Error codes for a list of return values.

Remarks

See the Microsoft Excel on-line Help for full details about this function.

Requirements

Header: xlfuncs.h

See Also

CXlMacros Class | CXlMacros Methods